…MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb… (Q1.1 for …innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… you’ll get roughly 1.67x the throughput of a …MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5…MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…a few rows into an InnoDB table, but trying to …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then,…InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock…. Even the fairly slow gzip-1 mode works well. The tpcc …is a very interesting solution for MySQL backup servers. All backup solutions …
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…5.5. Here is the related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL….inventory_id, COUNT(1) as installed_…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…table could wait on a metadata lock instead of failing or returning …automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_…MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… –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 5.5) for metadata locks. Now… since. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…table could wait on a metadata lock instead of failing or returning …automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_…MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads …implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool … would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Innodb. The first transaction will acquire the necessary row locks while it commits (which will take the 1 RTT). The other transactions will lock…logic (I usually get less than 5 people who do out of 100)….take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may …
