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: m

Re: triggers? when they execute and locking

2005-12-05 Thread Ben De Luca
diagnose this weird behavior? Ben De Luca wrote: Im am trying to implement a task running system with mysql and Im coming across a few problems with what I am trying to do. Simply I am trying to insert a list of tasks into the DB for various computers to run, I want to track when they ran and

triggers? when they execute and locking

2005-12-04 Thread Ben De Luca
Im am trying to implement a task running system with mysql and Im coming across a few problems with what I am trying to do. Simply I am trying to insert a list of tasks into the DB for various computers to run, I want to track when they ran and where they ran. I also have to limit some of