…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…. now. Basically, we re-focused it on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… no longer the case, the second CREATE will simply block with unintended consequences. A workaround here would be to set lock_wait_timeout variable to a very low value and then execute the CREATE TABLE, this will make sure that the CREATE… DROP table waiting to run on the same table, and as such I have reported the bug: http://bugs.mysql.com/bug.php?id…
Post: MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server
February 28, 2013 By 5 Comments
… lock_wait_timeout that shocked me. From the MySQL 5.5 docs for lock_wait_timeout: This variable specifies the timeout in seconds for attempts to acquire metadata locks. The… only set a timeout, or any kind of wait or interval value, to such a high value to play a practical joke on…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…another value on the second session: transaction2 > START TRANSACTION; transaction2 > INSERT INTO t VALUES(26); ERROR 1205 (HY000): Lock wait timeout exceeded…innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it needs to lock the index records and the gaps…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…the locks necessary on the local node, but it has no idea about the rest of the cluster. So, it optimistically shoots the transaction out to the…on two different nodes we will open transactions and attempt to modify the same row: node1 mysql> set…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…locking in the database server. This plugin can alert on…timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… cached. MySQL Query Cache is not. It does not cache the plan but full result sets. This… you’re not using query_cache_wlock_invalidate=ON locking table for write would not invalidate query…on invalidation Table granularity is often too bad. With other caches you may implement version based or timeout…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… to take a bit closer look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before… – you do not have to deal with complicated lock graphs or rely on timeout for deadlock resolution. For workloads with frequent row waits… and retrying transaction or giving error to the user you’re forced to wait. Setting lock wait timeout to some small value is not…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
…timeout has proper value or set it per session. Set Curl Timeouts Set both TIMEOUT and CONNECT_TIMEOUT as these apply to different connection stages and just setting timeout…on locks or owning the lock and so one of them is the…
