MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Lock wait timeout exceeded; try restarting transaction
Posted by: Rick James
Date: June 09, 2010 12:49AM

AUTOCOMMIT = ON means that each _query_ is a transaction.
AUTOCOMMIT = OFF means must mean something different? Think about it. InnoDB must do things in "transactions". So, when would a started transaction end? Sounds like "connection-oriented".

So,... back to the question of how long _connections_ last. And, are there "persistent" connections?

Timing things:
* PHP's microtime(true)
* MySQL's slowlog.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Lock wait timeout exceeded; try restarting transaction
12265
Vector Thorn
June 04, 2010 10:07PM
Re: Lock wait timeout exceeded; try restarting transaction
5144
Vector Thorn
June 05, 2010 12:43AM
Re: Lock wait timeout exceeded; try restarting transaction
3238
Rick James
June 06, 2010 09:01AM
Re: Lock wait timeout exceeded; try restarting transaction
4260
Vector Thorn
June 06, 2010 10:39AM
Re: Lock wait timeout exceeded; try restarting transaction
3090
Rick James
June 06, 2010 08:17PM
Re: Lock wait timeout exceeded; try restarting transaction
2510
Vector Thorn
June 06, 2010 08:37PM
Re: Lock wait timeout exceeded; try restarting transaction
3850
Vector Thorn
June 07, 2010 05:53PM
Re: Lock wait timeout exceeded; try restarting transaction
2919
Rick James
June 08, 2010 01:23AM
Re: Lock wait timeout exceeded; try restarting transaction
3148
Vector Thorn
June 08, 2010 01:52AM
Re: Lock wait timeout exceeded; try restarting transaction
2109
Rick James
June 08, 2010 09:02AM
Re: Lock wait timeout exceeded; try restarting transaction
3028
Vector Thorn
June 08, 2010 12:55PM
Re: Lock wait timeout exceeded; try restarting transaction
1887
Rick James
June 09, 2010 12:49AM
Re: Lock wait timeout exceeded; try restarting transaction
3091
Vector Thorn
June 10, 2010 11:22PM
Re: Lock wait timeout exceeded; try restarting transaction
3457
Rick James
June 11, 2010 09:25AM
Re: Lock wait timeout exceeded; try restarting transaction
3082
Vector Thorn
June 11, 2010 04:04PM
Re: Lock wait timeout exceeded; try restarting transaction
1796
Rick James
June 11, 2010 08:02PM
Re: Lock wait timeout exceeded; try restarting transaction
3096
Vector Thorn
June 15, 2010 07:27PM
Re: Lock wait timeout exceeded; try restarting transaction
7334
Vector Thorn
June 15, 2010 08:13PM
Re: Lock wait timeout exceeded; try restarting transaction
2541
Rick James
June 15, 2010 11:02PM
Re: Lock wait timeout exceeded; try restarting transaction
2391
Rick James
June 15, 2010 11:04PM
Re: Lock wait timeout exceeded; try restarting transaction
3179
Vector Thorn
June 15, 2010 11:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.