aksono [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 20, 2006 8:36 PM
> To: Robert DiFalco
> Cc: mysql@lists.mysql.com
> Subject: Re: Lock wait timeout exceeded during concurrent inserts on an
> InnoDB table
>
> Roberts
>
> How many concurreent inserts you'
t: Re: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Roberts
How many concurreent inserts you've done?
What MySQL version you use?
> Concurrent inserts (there also may be concurrent reads going on) are
> intermittently causing:
>
> java.sql.S
Roberts
How many concurreent inserts you've done?
What MySQL version you use?
> Concurrent inserts (there also may be concurrent reads going on) are
> intermittently causing:
>
> java.sql.SQLException: Lock wait timeout exceeded; try
> restarting transaction
>
> I noticed that adding innod
PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 20, 2006 11:20 PM
Subject: RE: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Ok, I will do that during my next test run. But in the meantime, when I
did it previously, it was oddly enough waiti
: mysql@lists.mysql.com
Subject: Re: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Robert,
please post SHOW INNODB STATUS\G during such lock wait, so that we see
what lock it is waiting for.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row
Robert,
please post SHOW INNODB STATUS\G during such lock wait, so that we see what
lock it is waiting for.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
