Hello,
Hope it is a good place for the following question
I use Mysql (3.23.39) and InnoDB tables on Linux (2.2.17-14smp)
and I got deadlock (In suppose it is a deadlock) when I do intensive work.
intensive work = one insert + one update + 2 selects
(simultaneously, with 4 differents processes, on the same table)
I got deadlock = My processes went down (after the timeout I had set)
and if I try an interactive request on the table (like select
count(*) from ...
I never got the answer.
If I do a 'mysqladmin processlist', I see about 10 threads of
insert/update/select
worst, if I do a 'mysqladmin kill ...' to kill some thread, nothing
happens
The only way to recover, is to kill the mysqld processes and restart mysql
Thank you for your help
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
Tél : 04 72 69 42 18
http://www.in2p3.fr/CC
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
