EmergencyEMERGENCY? Get 24/7 Help Now!

How small changes impact complex systems – MySQL example

 | December 31, 2014 |  Posted In: Benchmarks, MySQL, Percona Cloud Tools, Percona Server

If you’ve been studying complex systems you know what minor changes might cause consequences of much greater proportions, sometimes causing some effects that are not easily explained at first. I recently ran across a great illustration of such behavior while doing MySQL benchmarks which I thought would be interesting to share. I’m using a very […]

Read More

How well does your table fit in the InnoDB buffer pool in MySQL 5.6+?

 | December 29, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona Server

Some time ago, Peter Zaitsev posted a blog titled “How well does your table fits in innodb buffer pool?” He used some special INFORMATION_SCHEMA tables developed for Percona Server 5.1 to report how much of each InnoDB table and index resides in your buffer pool. As Peter pointed out, you can use this view into […]

Read More

Testing TokuDB’s Group Commit Algorithm Improvement

 | December 23, 2014 |  Posted In: Tokutek, TokuView

The MySQL 5.6 Release has introduced some changes to how two phase commit works and is managed.  In particular, the commit phase of transactions to the binary log is now serialized and this behavior is something we identified fairly immediately.  We implement a group commit algorithm that needed to be altered so that TokuDB’s group […]

Read More

File carving methods for the MySQL DBA

 | December 23, 2014 |  Posted In: Insight for DBAs, MySQL, Security

This is a long overdue blog post from London’s 44con Cyber Security conference back in September. A lot of old memories were brought to the front as it were; the one I’m going to cover in this blog post is: file carving. So what is file carving? despite the terminology it’s not going to be a […]

Read More

Testing backup locks during Xtrabackup SST on Percona XtraDB Cluster

 | December 22, 2014 |  Posted In: MySQL, Percona XtraBackup, Percona XtraDB Cluster

Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL) in Xtrabackup. While Xtrabackup can hot-copy Innodb, everything else in MySQL must be locked (usually […]

Read More

Store UUID in an optimized way

 | December 19, 2014 |  Posted In: MySQL

A few years ago Peter Zaitsev, in a post titled “To UUID or not to UUID,” wrote: “There is timestamp based part in UUID which has similar properties to auto_increment and which could be used to have values generated at same point in time physically local in BTREE index.” For this post I’ve rearranged the timestamp part […]

Read More

Scaling TokuDB Performance with Binlog Group Commit

 | December 17, 2014 |  Posted In: Tokutek, TokuView

TokuDB offers high throughput for write intensive applications, and the throughput scales with the number of concurrent clients.  However, when the binary log is turned on, TokuDB 7.5.2 throughput suffers.  The throughput scaling problem is caused by a poor interaction between the binary log group commit algorithm in MySQL 5.6 and the way TokuDB commits […]

Read More