dear all!
I am running mysql 4.0.13 (Linux-X86)
my innodb table accasionally comes to a deadlock,
when i run some sql such a "delete from tb_memfee where no='206681'".
if it come to a deadlock,
i cannot update any column of the row - where no is '206681' in the
table tb_memfee.
how can i
Hi
Can somebody help me to figure out why this deadlock happen?
Thanks
=
050405 9:12:17 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 50 seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reser
/order.mysql.com/
- Original Message -
From: "¶óÀϱ¸" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 11, 2003 4:42 PM
Subject: deadlock problem?
> dear all!
>
> I am running mysql 4.0.13 (Linux-X86)
> my innodb table accas
Hi,
I've got a deadlock problem using InnoDB tables in MySQL 4.1.5 for win32. I have two
tables, 'jobs' and 'results', where 'results' has a foreign key 'id_job' that
references the primary key of 'jobs'. There may be more than o
On Wed, 6 Oct 2004, David Edwards wrote:
> I've got a deadlock problem using InnoDB tables
(...)
> Transaction 1:
> START TRANSACTION;
> DELETE FROM results WHERE id_job = 25920;
> INSERT INTO results(result,id_job) VALUES (31.461937,25920);
> COMMIT;
>
> Trans
e lock there are and how they relate to each other. Is there any way I can get
both types of lock in one go, in the first statement I execute?
Thanks,
David
Tobias Asplund <[EMAIL PROTECTED]> wrote:
On Wed, 6 Oct 2004, David Edwards wrote:
> I've got a deadlock problem using Inn
ySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL support from http://www.mysql.com/support/index.html
...
From: David Edwards ([EMAIL PROTECTED])
Subject: Re: InnoDB deadlock problem
View: Complete Threa
Hi,
I sent the following e-mail to the msql-mysql-modules list earlier today
regarding a deadlock error using DBD::mysql.
I was advised by Jochen Wiedmann that DBD::mysql is simply a thin layer
on top of the C interface, and that I should therefore forward my
problem to this list, so here goe