…condition…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…’); $time_start = microtime(true); // Performing SQL query $query = ‘SELECT * FROM longf’; $result =… also slow down things a bit. So script with prepared statements: < ?php $mysqli = ...conditions it could be opposite. Prepared statements are typically considered for performance reasons if statement…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… MySQL Slow Query Log. The name comes from the instrument in a weather station that measures wind speed. SQL queries …reports by different query conditions; * graphing reports; * explaining queries; * searching and displaying samples; * displaying table status and CREATE statements; * reviewing and …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow… a new mutex to protect from race conditions. Bugs Fixed:#745241 (Alexey Kopytov). As the… Querying INNODB_SYS_TABLES after an ALTER TABLE statement leaded to a server crash. Bug Fixed: #…
