<div>
that error is NOT a deadlock, but a simple lock.<br />
<br />
now, to find the session, I found nothing but some forum entry saying:<br />
&lt;...&gt;<br />
Run mysqladmin debug<br />
Then, the list of locks will be listed in the error log file. <br />
&lt;...&gt;<br />
<br />
hope this helps
</div>


that error is NOT a deadlock, but a simple lock.

now, to find the session, I found nothing but some forum entry saying:
<...>
Run mysqladmin debug
Then, the list of locks will be listed in the error log file.
<...>

hope this helps

<div>
I want to kill a transaction right from my PHP script. Not manually from console
</div>


I want to kill a transaction right from my PHP script. Not manually from console

<div>
in other words, how can I kill ALL transactions in MySQL?
</div>


in other words, how can I kill ALL transactions in MySQL?

<div>
the simplest would be the restart MySQL.<br />
otherwise, to see all sessions:<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html</a><br />
<br />
to kill a session:<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/kill.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/kill.html</a>
</div>


the simplest would be the restart MySQL.
otherwise, to see all sessions:
http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html [http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html]

to kill a session:
http://dev.mysql.com/doc/refman/5.0/en/kill.html [http://dev.mysql.com/doc/refman/5.0/en/kill.html]

<div>
any chance to kill a transaction?
</div>


<div>
<div class="content wysiwyg-content">
When I start new transaction in MySQL sometimes I get an error: <br />
<br />
(1205) Lock wait timeout exceeded; try restarting transaction<br />
<br />
How can I resolve this deadlock in such case? In other words, I want to KILL the transaction which created this deadlock. Can I do this?
</div>
</div>


When I start new transaction in MySQL sometimes I get an error: 

(1205) Lock wait timeout exceeded; try restarting transaction

How can I resolve this deadlock in such case? In other words, I want to KILL the transaction which created this deadlock. Can I do this?

How to resolve a deadlock in MySQL?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.