… index the table I get the following record in the slow query log: # Time: 120911 17:18:05 # User@Host: root…_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: 12F14 SET timestamp=1347398285; select * from sbtest where pad=’abc’; Rows_examined=0…_id: 12F1D SET timestamp=1347398722; select * from sbtest a,sbtest b where a.id=5 and b.id=a.k; mysql> explain select…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…7 exec_time=0 error_code=0 SET TIMESTAMP=1359714099/*!*/; BEGIN /*!*/; # at 726 # at 773 #… | 0.000007 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | +———————-+————+ 17 rows in set (0.00…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 3 Comments
One may think one may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes… thread causes queries to be omitted from slow query log but the fact thread uses SET TIMESTAMP functionality. If you do this within… to the past and SET TIMESTAMP was implemented, which instead of patching bunch of function simply writes different timestamp to this variable. When…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… enable logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise we might…_examined: 655360 use test; SET timestamp=1325145746; select count(*) from auto_inc; Compare that to Percona Server with log_slow_verbosity=full: # Time…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…’ Rows_examined: ‘, rows_examined, CHAR(10), ‘SET timestamp=’, UNIX_TIMESTAMP(start_time), ‘;’, CHAR(10), IF(FIND_IN_SET(sql_text, ‘Sleep,Quit,Init …,Reset stmt,Set option,Fetch,Daemon,Error’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… logged into slow log, however the new version is loaded with a set of cool new features. CONNECTION IDENTIFIER Each slow log entry…_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s….000000 InnoDB_queue_wait: 0.067538 # InnoDB_pages_distinct: 20 SET timestamp=1193841780; SELECT DISTINCT c from sbtest where id between 501895…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query… previously performed well suddenly show up on slow query log until InnoDB again updates the …Tmp_disk_tables: 0 Tmp_table_sizes: 0 SET timestamp=1316767697; show table status from `db1`; As …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… prefix of another command line option innodb_changed_pages_limit. MySQL option handling would then shadow the former with the latter… (Laurynas Biveinis). Time in slow query log was displayed incorrectly when slow_query_log_timestamp_precision variable was set to microseconds. Bug fixed #887928…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set to microseconds. Bug fixed #887928… prefix of another command line option innodb_changed_pages_limit. MySQL option handling would then shadow the former with the latter…
