…=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_instances=32 table…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
…’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up. If… as ‘null’ and Info says ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled the query… decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT… files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also… get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
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 thread…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… work 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…
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
… 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… id=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table t1 engine=innodb; And the alter will timeout after approximately a second with the following error: ERROR 1205 (HY000): Lock wait…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… mysqld mysqld [.] rw_lock_x_lock_func(rw_lock_t*, unsigned long, char const*, unsigned long) | — rw_lock_x_lock_func(rw_lock_t*, unsigned long… = 1 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…
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… application. These are maintained in separate tables and there also exists a users_groups table to define the relationship between them. When…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has… bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead of failing…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has… bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead of failing…
