… | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning … reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are serviced from the Query Cache, let’…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…bug 1082599: pt-query-digest fails to parse timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query… pt-query-digest now handles this correctly. Fixed bug 1015590: pt-mysql-…downloaded from http://www.percona.com/downloads/percona-toolkit/ or the…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… the slow query log to the DEV server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file=slow.log Executed 429467 queries Spent 00:00:59.668649 executing queries versus an… find any bugs we would appreciate it being filed on launchpad. You can download the tool from: http://www.percona.com/downloads…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…a look at this bug report (not a bug). Looking at MySQL status Now we’re … | 38563413074 | 1708212 | | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …… queries, in total execution time. By the way, the slow query logs in the stock MySQL …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… data smaller) or can a bit slow it down. Plus there were bunch…’last’ serious bug in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id…There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… more than a year ago. Great news are MySQL finally released new Community release – MySQL 5.0.33, which however as promised… (Links removed) We added one more RPM to stantard MySQL RPMs – MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm This… microsecound in slow-log. More info about the patch http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php?id…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload table / index into buffer_pool. You can use custom queries by… probes during opening table, as it is slow operation. See also http://www.mysqlperformanceblog.com/2006/11/21/opening-tables-scalability/. Partially…
Comment: MySQL Query Cache WhiteSpace and comments
March 25, 2008 By 9 Comments
… mysql command line client now has an *option* to pass comments to the server, but it’s disabled by default: http://bugs.mysql.com/bug… the query recorded in the slow query log). However, when I ran this php script: I *did* see the comment in the slow log: # Time: 080325 9:31:43 # User@Host: dbadmin[dbadmin] @ localhost [] # Query_time: 2 Lock_time…
Comment: Learning about MySQL Table Fragmentation
May 11, 2008 By 20 Comments
… posted this to MySQL: http://bugs.mysql.com/bug.php?id=36588 Originally we had this discussion in our Forums: http://www.webyog.com/forums//index… is that also SHOW TABLE STATUS can be very slow. Same for queries to Information_Schema fetching the same information. But it…
Comment: Innodb row size limitation
April 9, 2011 By 12 Comments
… compressed. The relaxation of the check was done for http://bugs.mysql.com/bug.php?id=50495 . If you’re putting so much data… you probably don’t need all of it for every query and could probably improve performance by moving some of it… of general reporting. There’s no need to slow down the general queries by having the address information in the main record…
