…of rows. “val” column in this table has 10000 distinct value, so range 1..100 selects about 1% of the table. The times for full table…number of CPUs will not help. Sometimes it is good idea to manually split query into several, run in…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…in sorted order. If you use many queries…to – SQL or storage engine. Honestly as it had name very similar to read_buffer_size which is currently only used by MyISAM tables…number of columns or there are long VARCHAR columns used – it takes only couple of UTF8 VARCHAR(255) to…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…in particular that the server is trying to find is c1=1, but how can we find…Table_map: `repl`.`t1` mapped to number 15 #100506 12:42:56 server id 1 end_log_pos 340718 Update_rows: table…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…to retrieve the same number of rows on each benchmark (I noticed 100 rows on SQL…to import the result of any SQL query, and if you can form a SELECT query…of recently-changed data. Your application would have to be coded to search both indexes to find…
Comment: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…to spot queries that are attempting to do SQL injection. The –review table contains a column named ‘reviewed’. You can use this table to mark all of your normal SQL query…number of query patterns, and those patterns only change during deployments, so you should be able to see “unusual” queries…
