…’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up. If… state as ‘null’ and Info says ‘commit’ The ‘Table_locks_waited‘ remains zero while the ‘Table_locks_immediate‘ keeps increasing I have disabled the query cache…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…immediately recall saying it. Applied to a standalone Innodb instance Let’s break it down a bit. Our unit of locking… in separate tables and there also exists a users_groups table to define the …transactions will lock wait until the lock(s) they need are available. The application just waits in…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a transaction that executed a query which opened that table…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a transaction that executed a query which opened that table…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… lock_wait_timeout variable to a very low value and then execute the CREATE TABLE, this will make sure that the CREATE fails immediately (however due to a different reason): session2 > set session lock_wait_timeout=1;CREATE TABLE…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… system_time_zoneblogpercona.commanual table_definition_cacheblogpercona.commanual table_lock_wait_timeoutblogpercona.commanual Table_locks_immediateblogpercona.commanual Table_locks_waitedblogpercona.commanual table_open_cacheblogpercona.commanual table_typeblogpercona.commanual tc_heuristic…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… table will immediately block against the requested global read lock, and subsequent read queries will block against the write query’s requested table lock… flushing tables yet. It’s waiting to get the lock. Flushing tables After the FLUSH TABLES WITH READ LOCK command finally acquires the lock, it …
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… starting index read, thread declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424, query id 1579718… waiting for the semaphore. Notice that this is effectively a global lock. The debian-sys-maint thread is not touching the same tables…. The solution I chose in this case? mysql> KILL 7; Immediately afterward everything cleared up.
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Sort_range’, ’56479689′ ‘Sort_rows’, ’1344092495′ ‘Sort_scan’, ’935242′ ‘Table_locks_immediate‘, ’895966639′ ‘Table_locks_waited‘, ’20096′ ‘Threads_cached’, ’0′ ‘Threads_connected’, ’260′ ‘Threads_created’, ’124272…/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… TABLES WITH READ LOCK. It immediately acquired locks on all tables — effectively write locks, as you say — except this one log table. It held those locks waiting for the lock on the log table…
