…server. Mysqldump works well for this, but can quite slow on larger schemas. One of the downsides to …Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER…VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that come to mind …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux… raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, …ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… massive slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log… – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log… better for this use case. You will need version 0.6 or later to get these features. Be aware that playback…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
…. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar… Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time showing… excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded…. Bug fixed #1116177. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded…. Bug fixed #1079135. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… support for MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6 is GA, so… a try. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t have a…
Comment: Solving INFORMATION_SCHEMA slowness
May 5, 2013 By 25 Comments
….mysql.com/bug.php?id=19588 – reported fixed in MySQL 5.1.21 but many people reported I_S was slow. http://bugs.mysql.com/bug.php?id=56178 – reported fixed in MySQL 5.5.16, 5.6.3. What version…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… about the impact of the MySQL slow query log. Since we’re working on Percona Server 5.6, I did wonder if this… in the slow query log. The code for my prototype can be found at lp:~stewart/percona-server/5.6-slow-query-plugin… the following: straight MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some….000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | +———————-+————+ 17 rows in…
