… the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction…and Python clients when plugin-dir option was set in the [client] section of the my.cnf… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help …
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…, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these (or any… the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that have critical bugs. Version check will warn…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… to change the permissions to mysql:mysql. 4- Start the new slave from that GTID position: slave1 > SET GLOBAL gtid_purged=”c777888a-b6df…; 5- Check the replication status: slave1 > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…on startup or on demand. Time interval between checks done by log copying thread is now …Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle…. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed #945161. Missing …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction…and Python clients when plugin-dir option was set in the [client] section of the my.cnf… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help …
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… with setting up, managing and monitoring PXC. MariaDB Galera Cluster users should fit right in: http://www.percona.com/live/mysql-conference… multi-node simultaneous writing, you should check this out: http://www.percona.com/live/mysql-conference-2013/sessions/hazards-multi-writing-dual…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… it ideal for companies with large data sets and mission-critical applications that cannot tolerate…uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client…. cause SST to fail. Fixed by fix checking if xtrabackup_pid file exists once innobackupex …
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By 2 Comments
…, and doing it excellently. This makes the plugins easier to set up and use, and I believe it should help avoid… you can use for fairly arbitrary checks of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend using it only for two purposes: Check…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring …and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…. mysql> INSERT INTO Foo (A,B) VALUES (111,2222), (333,444); mysql> INSERT INTO Bar (ID,X,Y) VALUES (21,333,444); mysql> SET FOREIGN_KEY_CHECKS=0; mysql> INSERT INTO Bar (ID,X,Y) VALUES (42,555,666); — THIS IS AN ORPHAN mysql> SELECT…
