… pmp-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql… 1160611) * pmp-check-file-privs didn’t throw the proper error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the great comments…, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special… in a cooperative atmosphere. We run Percona Live MySQL conferences to bring together all MySQL users, vendors, and technologies. This was the…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of… use some of these tools to solve typical, real-world MySQL database administration challenges, such as: Selecting which queries you should… without putting too much load on your server How to check which tables are affected when someone accidentally wrote to a…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…-a3d7-080027635ef5:1-5 After the START SLAVE the slave checks that transaction 5 is already in its own binary log… is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes an overview of MySQL 5.6 GTID that can…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin… part of the graph lines up with the blue part. Check back Thursday for Part 2!
Post: Moving to MySQL 5.6? We can help
April 12, 2013 By Leave a Comment
…, and plan for the migration to MySQL 5.6. The class is called Moving to MySQL 5.6 and is a 2… MySQL 5.6, show you how to verify your application, and plan for a successful migration. You may also want to check out our other MySQL training events. All of our workshops have been updated to MySQL 5.6–so…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…-30.2 milestone at Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey… Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… was still beta. Now that MySQL 5.6 is GA, so is our support for it. Check out the Percona Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure… the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that have critical bugs. Version check will warn…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… this benchmark for MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30 and check how these servers…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… either automatically on startup or on demand. Time interval between checks done by log copying thread is now configurable by innobackupex… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…
