June 19, 2013

Post: Ultimate MySQL variable and status reference list

conditionSlow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow

Post: Handling big result sets

…’); $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

… 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

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: #…