… Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3… | | Sorting result | 0.000002 | | Sending data | 0.000040 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0… | | Sorting result | 0.000004 | | Sending data | 0.000033 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000004 | | freeing items | 0…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, ….ic:221) ==9090== by 0x6B39223: fsp_fill_free_list (fsp0fsp.c:1455) ==9090== by 0x6B3DED8… by 0x6A87FC: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:269) ==9090== …
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 …proxy_userblogpercona.commanual pseudo_thread_idblogpercona.commanual Qcache_free_blocksblogpercona.commanual Qcache_free_memoryblogpercona.commanual Qcache_hitsblogpercona.commanual Qcache_…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 3 Comments
… all interested in MySQL. We really want you to be there — and that’s why we’re giving away free tickets and…, and then post another blog entry here to announce the results. Make sure we (or our sponsor) can contact you privately… other expenses. Ten second prizes are a free copy of the new book “High Performance MySQL, 3rd Edition” which will be available…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… do? Basically we send a query to MySQL, and we do not wait for result but rather get response later. The MySQLnd… ($links as $k=>$link) { if ($result = $link->reap_async_query()) { $res = $result->fetch_row(); # Handle returned result mysqli_free_result($result); } else die(sprintf(“MySQLi Error…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…}” ]; then echo “Exiting, not enough free space (${full}%, ${avail}MB free)”>&2 exit 1 fi host=$(mysql -ss -e ‘SELECT p.HOST FROM… port 3306 and port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s… “mk-query-digest –type=tcpdump –no-report –print” on the resulting tcpdump file (after inspecting the captured SHOW INNODB STATUS and…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…and in many cases also don’t log the resulting errors. The best place to fix these problems … a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of… too much memory and/or for too little free memory in general. This plugin requires careful configuration…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
…Percona Server for MySQL A free, open-source solution, Percona Server for MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough …on quality of service have resulted in the industry’s most predictable response times and throughput. Standard MySQL suffers from complete lockups…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… though Performance Schema overhead was reduced in MySQL 5.6 it is still not free and it will cause an overhead, yet… Read Only one to simplify things and get more repeatable results without spending too much time on it. I used Ubuntu… reasonable result and I do not think 3% difference will be noticed in most production cases. For benchmark with 64 threads MySQL…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old … correspond to global memory allocation and will result in increased memory allocation until server is … is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate …
