…Mounting configfs… [ OK ] Starting cman… [ OK ] Waiting for quorum… [ OK ] Starting fenced… [..., it's time to stop the...MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL to determine when it…, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got some…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… features that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use… external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested ? Sign up…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… year, semi-sync must serialize all transactions and wait for them one at a time. So, Callaghan’s law applied to semi… retried only the number of times specified by this variable (default is 1 retry). This means more waiting, and after the limit…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… tries and wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the …limit in this case might mean a long wait before flow control gets relaxed again. However, …more expensive replication conflicts more likely and therefore time-consuming to the application. How to tell …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-…_shutdown = 1 #not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
… order of operations is: 1. logrotate renames the log file. MySQL continues to write to the renamed file because it has… logging is paused (set global long_query_time=2000;) 2b. There is a small wait for buffered logs to be flushed (select… (FLUSH LOGS;) 2d. Slow logging resumed (set global long_query_time=@lqt_save;)
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… you can see how the query spent nearly all its time waiting in the “Opening tables” state. Now this behavior with respect… to a table that has a DDL operation waiting, will block. Why? Because MySQL sees that the old entries in the Table… was using MySQL version < 5.5 as the datastore. There was another interesting case this time with how Active MQ uses MySQL when…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on… might only mean that we were IO-bound the whole time waiting on fsync operations. But we didn’t go from a…. But I was on the client’s time and I wasn’t going to spend time redoing it — I did not see…
