…… [ OK ] Mounting configfs… [ OK ] Starting cman… [ OK ] Waiting for quorum… [ OK ] Starting fenced… [ OK ] Starting …ms_MySQL [p_mysql] Masters: [ percona1 ] Slaves: [ percona2 percona3 ] We can see that some resources changed … upgrade to 6.4, it’s time to stop the maintenance mode… but…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…-schema-change). Here are some highlights: Official support for MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL 5… tries and wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication?…least amount of data we can change in Innodb at a time is a single row, …prevent the deadlock errors, but will not change the lock waiting that your application will need to…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… anything you find in standard async MySQL replication. It is my belief … really does no more than to change if the fc_limit is dynamically…this case might mean a long wait before flow control gets relaxed again….replication conflicts more likely and therefore time-consuming to the application. How …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… (configuration D) which combined the parameter changes from tests B and C. … –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=…#not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable…pool_wait_freeblogpercona.commanual Innodb_buffer_pool_write_requestsblogpercona.commanual innodb_change…Threads_runningblogpercona.commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona.commanual …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… not block waiting for the transaction to commit. For the reasons described above the implementation of Metadata Locking was changed, starting MySQL 5.5.3. Let’s see how this works now. Metadata Locking behavior starting MySQL 5.5… you can see how the query spent nearly all its time waiting in the “Opening tables” state. Now this behavior with respect…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes…| OFF | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 | 5 | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 |…| | SQL_MODE | | NO_ENGINE_SUBSTITUTION | | INNODB_OLD_BLOCKS_TIME | 0 | 1000 | | LOG_ERROR | /mnt/…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
… replicas have also committed successfully. In MySQL‘s semi-synchronous replication, the commit …time, it will be delayed relative to the master. However, other transactions can continue committing and sending their changes… crash occurs while the master is waiting for acknowledgment from a slave, it …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… testcase under Helgrind. (For the time being, running the whole MySQL testsuite is not very practical….ic:150) ==9090== by 0x6B34515: fil_aio_wait (fil0fil.c:4512) ==9090== by 0x6BC58E0: io_…changes that might make the issues not-so-minor. Additionally, I’d consider backporting and using MySQL…
