… long_query_time microseconds to execute to file. This option is standard MySQL, however after you apply the patch, it will no… msl patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL 5.0.54a msl patch for MySQL 5.0.56 msl patch for MySQL 5.0.45 with InnoDB extensions msl patch…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… is in microseconds and you can set it for example to 300000 which is 0.3s! # Query_time: 0.503016 Lock_time: 0.000048… Merge_passes: 0 # No InnoDB statistics available for this query SELECT COUNT(1) FROM t2; Important note: Although the patch was tested… in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not work on other…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
…(10,2) DEFAULT NULL, `LocalName` char(45) NOT NULL DEFAULT ”, `GovernmentForm` char(45) NOT NULL DEFAULT ”, `HeadOfState` … From there, there’s a helpful patch in 5.0-percona called INDEX_STATISTICS that can then…or set your slow query log to zero microseconds (5.1 feature) and then find someway to…
