… in your case I guess running txt like “% keyword1 %” and txt like “% keyword2 %” instead of running MySQL Full text search query would be… or something similar. If you have the code for your Full Text Search system you share it. Now speaking about index… and groupid for each document which is not needed for full text search itself, only needed if they are used in…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…=0; set unique_checks=0; load data local infile ‘infile.txt‘ into table load_test fields terminated by ‘\t’ lines terminated…) the following in one terminal: perl mk-fifo-split infile.txt –fifo /tmp/my-fifo –lines 1000000 And this in the… completely true, since the buffer pool must have been overly full with this table’s data. Next time I do something…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… 5 minutes or other interval of your choice. 2) Use full slow query log and mk-query-digest. This method is…-log –filter ‘($event->{user} || “”) =~ m/[SLAVE_THREAD]/’ > /tmp/report-slave.txt In the report you will see something like this as… 0 117.75k 0 # 0% (5k) Filesort # 0% (5k) Full_join # 0% (7k) Full_scan # 0% (10k) Tmp_table # 0% (4k) Tmp…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… disks currently cost about $400 each, and are roughly half full. (That actually matters — the fuller they get, the slower they…. [baron@ginger logstats]$ diskstats -g sample -i 6000 sda3-stats.txt #ts device rd_mb_s rd_cnc rd_rt wr…
