… does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which … and mutex_set_waiters. Interestingly, there are comments next to it that say /* Here we … thread #14 ==9090== at 0x6BC8B23: sync_array_print_long_waits (sync0arr.c:937) ==9090== by …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… badness in this article is fairly complete. (Post comments if I’m wrong.) Here is my definition: … and summing the execution time together. Then it prints out a profile of the classes, so you … query executed for, which has been available in MySQL for years. This is necessary for determining whether …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…constantly referring to the amazing MySQL manual, especially the option and variable reference table. But… preload_buffer_sizeblogpercona.commanual Prepared_stmt_countblogpercona.commanual print_defaultsblogpercona.commanual profilingblogpercona.commanual profiling_history_sizeblogpercona.commanual …
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…. The default report just prints out ALTER statements for …mysql> select * from queries where query_id = 7675136724153707161\G *************************** 1. row *************************** query_id: 7675136724153707161 fingerprint: select * from wp_comments where comment_post_id = ? and comment…
Post: How to pretty-print my.cnf with a one-liner
June 15, 2009 By 17 Comments
…/my.cnf file nicely formatted, and with comments stripped. This Perl one-liner will pretty-print the file: perl -ne ‘m/^([^#][^\s...] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… sometimes which is obviously the problem – they take Apache Slot, MySQL Connection and other resources. I had discussion today who was… example to print nice error message as well as to do some cleanup work – for example you can open another MySQL connection…: There are some comments saying experimenting with sleep() function is wrong and if I would use real MySQL queries this would be…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
…guessing you can use gdb -p . It will not print you exact line of code in PHP which …are not only helpful to debug sleeping connections with MySQL but many other cases when you see web …could be helpful in this regard would appreciate your comments. There might be some smarter tools out where for…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
…same version of mysql, with this patch applied (we compile mysql from source … $dbh->prepare($_); $sth->execute(); $sth->finish(); } } $dbh->disconnect(); ###print “died\n”; exit; # very important. } else { # Don…with caution. Any bugfixes, enhancements, or comments – please post them back here. …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…=/var/lib/mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL Community Edition… command will take about a minute to complete and it prints the following message at the end when everything goes fine…
