…0.162272 | | end | 0.000008 | | query end | 0.000004 | | closing tables | 0.000032 | | freeing items | 0.000035 | | logging slow query | 0.000004 | | cleaning up | 0.000005 | +———————-+———-+ So the unstable response times…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…on slow query log, happily the server was running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take most time to…problems picking up long_query_time when it is set online, meaning changing it via set global long_query_time=0 and restarting slave …
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
…0.000002 | 0.00 | 1 | 0.0000020000 | | logging slow query | 0.000001 | 0.00 | 1 | 0.0000010000 | +———————-+———-+——-+——-+————–+ Much nicer. Now you can see that over 3/4ths of the time…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… MySQL 5.0. What can you do in MySQL 5.0 and below ? Use Our Patch – With this patch you can get all queries logged as slow queries (with times) and as you can change long-query-time…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…the Percona Software Repositories). Based on MySQL 5.1.66, including all the… been updated to version 1.1.0 (rev. 83d8f3af176e1698acd9eb3ac5174700ace40fe0). Fast InnoDB Checksum feature… this caused Query_time to increase for every query stored procedure logged to the slow query log. Bug fixed #719386…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…0 on October 14, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL… (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312…Slow Query Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log-slow…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…changed page tracking log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp … Percona Server 5.1.59-13.0. Bug fixed #1100159 (Laurynas Biveinis). Fixed the… line option innodb_changed_pages_limit. MySQL option handling would then shadow the …
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… enable full slow query logging (with long_query_time = 0) for some time during peak load. Then you can use pt-query-digest to analyze the queries and have… SQL query writing and wanted to learn MySQL administration suggest any book or practices. Of course I’m biased but High Performance MySQL…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… HEAP for in memory tables. So first MySQL versions did not bother naming variables with …not support it (HEAP/MEMORY). Note in 5.0 you now have very nice value of … logs, slow query log or general log. flush, flush_time Flushing (closing) of tables after query is complete or every flush_time seconds…
Post: mk-query-digest, query comments and the query cache
…MySQL log files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs…