… I need for my setup (I still can have synthetic auto_inc PK, but in that case I still will need SECONDARY…=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… prevent the deadlock errors, but will not change the lock waiting that your application will need to do for hotspots. wsrep… with autocommits, you can rely on wsrep_retry_autocommit to auto-retry the transactions for you. However, each autocommit is retried… retry manually are typical answers. However, this means more latency waiting for a write to go through, and possibly some poor…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
… in such a case. Bug fixed #1180662. Low values for wait_timeout on the server could cause server to close the… is being taken. Fixed by setting the bigger value for wait_timeout option on the server to prevent server from closing connections if the global wait_timeout value is set too low. Bug fixed #1180922. Other…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… demonstrate, the no-cache system is being crushed by IO wait. FlashCache and vCache both show improvements, but it’s not…_fast_shutdown = 1 #not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000…
Comment: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
Which of the open source flashcache solutions are most popular? * https://github.com/stec-inc/EnhanceIO * Linux dm-cache * Facebook flashcache
Comment: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 15, 2013 By 2 Comments
… why this could be happening? how does the master’s auto detection takes place? TIA don’t know what went wrong…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
Excellent description. I have been waiting for someone to begin writing about Galera at this level … replication. Apparently each client must wait for it’s turn writing to the binlog and waiting for confirmation from the slave, there…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested ? Sign up…
Comment: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
Can’t wait til the production ready version of 5.6 comes out just for the GTIDs. On an unrelated note.. anyone notice that the code blocks don’t work in Chrome? Works fine in IE.
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
….0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave…
