Re: deadlocks on concurrent INSERTS

2006-12-07 Thread James Neff
Output of: show innodb status; | InnoDB | | = 061207 4:56:43 INNODB MONITOR OUTPUT = Per second averages calculated from the last 17 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count

deadlocks on concurrent INSERTS

2006-12-06 Thread James Neff
Greetings, I've got 6 Java client applications (running on 6 different PC's, including one of them on the database server) reading data from a flat file and inserting data into a table on my database: mysqld Ver 5.1.12-beta-log for unknown-linux-gnu on x86_64 (MySQL Community Server (GPL))

Re: deadlocks on concurrent INSERTS

2006-12-06 Thread Ben de Luca
What does a `show innodb status show`? On 07/12/2006, at 2:44 AM, James Neff wrote: Greetings, I've got 6 Java client applications (running on 6 different PC's, including one of them on the database server) reading data from a flat file and inserting data into a table on my database: