…(29); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction root@localhost:test 14:38:03>insert into t values(23); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction root@localhost:test 14:44:37>insert into t values… STATUS information as follow: —TRANSACTION 0 27638, ACTIVE 1207 sec, process no 2909, OS thread id 1100101952 inserting mysql tables in use 1…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… running transaction, two identical statements get different values, because some other transaction has modified the table’s rows. For example: transaction1> START TRANSACTION… STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… in ACTIVE state. Especially ACTIVE transactions which do not currently run any query are suspicious. There are however cases when screaming fire about ACTIVE transactions… is when you have long enough ACTIVE transactions which have some locks, like in this case: MySQL thread id 2059, query id 1014425…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… latency of round-trip transactions should be in an acceptable range. It opens the possibility for active master – active master setups. You can… three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
… you commit a transaction, the commit does not complete until all replicas have also committed successfully. In MySQL‘s semi-synchronous replication, the commit completes before the transaction is even sent to any of…. As a result, the effect is that the client’s activity is throttled so that it cannot outpace the replica’s…
Post: When does Innodb Start Transaction ?
January 11, 2011 By 9 Comments
… in transaction list. It is only when you read (or write) to INNODB table you can see transaction is started: —TRANSACTION F56AED, ACTIVE 4 sec, process no 23727, OS thread id 139753656395520 MySQL thread id 112, query…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… the subsequent purge work is ensured by a long-running transaction with a REPEATABLE READ isolation level and started WITH CONSISTENT SNAPSHOT. In the middle of the workload this transaction commits and so the purge begins. The tests were performed… activity could be throttled better as to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
… kind of error complicating automatic handling. When we tested different transactional storage engines we surely saw lock related tables being far… you have too InnoDB: many active transactions running concurrently? I hope with pluggable storage engine interface Sun/MySQL spends some time to make…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
…’t execute the given command because you have active locked tables or an active transaction) – this is also I used DELETE instead of… having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children allowed to process request; So you can do following instead: mysql> rename table rep to rep_maint; Query OK, 0 rows…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…SHOW INNODB STATUS is information about currently active transactions: ———— TRANSACTIONS ———— Trx id counter 0 80157601 Purge …MySQL there will be ether not started state if there is no active Innodb transaction for this connection, or ACTIVE if transaction is active. Note transaction…
