… post in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least for this workload…=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_hash…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…side, things start to degrade. If you’re just setting up a test environment to get familiar with …on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster …the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db…
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
…-in 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… where id=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table t1 engine=innodb; And the alter will timeout after approximately…
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… makes an achievement, your application updates this table with a statement like this: UPDATE achievements SET count = count + 1 where achievement = ‘killed…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… it and how. There’s still one noticeable omission: pt-table-sync. It’s still unclear if or how one would…, 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 5.5) for metadata locks. Now –set-vars is used to set both of these…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been … TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…Python clients when plugin-dir option was set in the [client] section of the my…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been … TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…Python clients when plugin-dir option was set in the [client] section of the my…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail …would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed #945161….
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
…locks right ? So if you see locked tables reported in SHOW ENGINE INNODB STATUS you might be confused and rightfully so as Innodb table locking…
