… evs.user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would…. Bug fixed #1133047 (Alex Yurchenko). Upstream bugfix for bug #59354 triggered a regression that could cause transaction conflicts. Bug fixed #1158221…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0… MASTER STATUS to obtain binlog file and position. This could trigger a bug if the server being backed up was standalone…. Release notes with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-beta1 are available in our online documentation…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB… MASTER STATUS to obtain binlog file and position. This could trigger a bug if the server being backed up was standalone…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… scope of this post. Tuning flow control Flow control is triggered when a Synced node exceeds a specific threshold relative to…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods… usual with these cases, we set up pt-stalk to trigger a capture if Threads_running went above a known ‘good… issues. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work, in…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… “1″ to the do_sync sysctl of the cache device triggers a cache flush, but it happens in the background, and…
Post: Unexpected problem with triggers and mysqldump
February 11, 2013 By 8 Comments
…) $ mysql sakila2 < schema.sql $ mysql sakila2 < data.sql ERROR 1235 (42000) at line 86: This version of MySQL doesn’t yet support ‘multiple triggers… you look at the mysqldump documentation, you will see: –triggers Include triggers for each dumped table in the output. This option is… came up before, it may be an indication that using triggers is far from being a common practice with MySQL.
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… to avoid them. TRIGGERS When a statement activates a Trigger only the original query is logged not the subsequent triggered statements. If you… data is necessary to define the same Triggers in Master and Slave servers. Example: mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert into…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… good place to start for finding a symptom that can trigger the problem. If you aren’t sure what “normal” looks… up into the range of 20 or higher. A safe trigger might be 15, if your server never reaches 15 under…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
