…=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G 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…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… 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…, cai.inventory_id All 4 tables in the query are locked!
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… ‘null’ and Info says ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled the… decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and the… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
… you have row locks blocking the ALTER, while the post deals with metadata locks. If you can enable the InnoDB plugin on your… InnoDB, then you can further clarify to yourself that the ALTER in your test case is waiting on InnoDB row locks by setting innodb_lock…=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table t1 engine=innodb; And the alter will timeout after approximately…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout… (or any) system variables. For a quick intro to metadata locks and how they may affect you, see Ovais’s article… out of the box. It’s also aware of metadata locks now, whereas 2.1 was not really aware of them…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested ? Sign up today!
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write… loose-innodb_flush_neighbors=0 loose-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…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…. Applied to a standalone Innodb instance Let’s break it down a bit. Our unit of locking in Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means typically on a single Innodb…: This will behave just like standard Innodb. The first transaction will acquire the necessary row locks while it commits (which will take…
