…MySQL has traditionally been challenging. Most data can be obtained from the slow or general log…to the log (all the lists in these variables are comma separated). As pointed here, anything that would generate a write to the general log…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…to announce the release of Percona XtraBackup 2.1…writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5…MySQL 5.6. This option can be used to produce 5… tables and slow IO…fail when copying logs. Fixed by terminating xtrabackup process immediately on log…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5…to wait for metadata locks, at that point the ALTER simply blocks any type of queries to the table, we know that writes… cached result to clien | 0.000011 | | logging slow query …MySQL 5.1 the second CREATE would just fail…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
…to the new major version make sure you upgrade to latest current version at first. Ie upgrade to recent MySQL 5.0 before upgrading to MySQL 5.1…to write not about MySQL…logged some of my experiences as a bug but here are some more details about the problems Upgrade Script fails to shut down MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… Linux Server release 5.2 (Tikanga) …log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1…if the query fails, then you…to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log…you need to really know how to write queries…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… web sites failing to take care of this provides very easy task to launch a …slow query log as query which does not use indexes, even if it is quite fast: mysql…1.6 million of rows to be scanned, while we well know it will be just 5… are some differences. I should write another article about ORDER BY …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…to get rid of–purge–the old versions of the records as they become obsolete. In MySQL 5.1…log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1…writing, the code is already different in the trunk. Huh? The dedicated purge threads in 5.6.2 completely fail to…they only slow the growth…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL 5…LOG — Log sequence number 84 3000620880 Log flushed up to 84 3000611265 Last checkpoint at 84 2939889199 0 pending log writes, 0 pending chkp writes 14073669 log…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…MySQL version 5.1.67-14.4 on March 8, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1…to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas Biveinis). Writing bitmap larger than 4GB would cause write to fail. Also a write…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…mysql-5.0.51a) % su root Password: First you should apply the changes to the database configuration, specifically you need to enable slow logging…logged while doing it only for every n-th of them thus limiting the number of writes to the log. Note: this feature will fail to…
