Paweł Sztromwasser wrote: > When you run one job at a time it takes about 40-45 sec. Here are the > times for 5 users trying to import simultanously > > no created started ended ended - started(sec) > 1 11:59:16 11:59:22 12:00:02 40 > 2 11:59:16 11:59:30 12:00:40 70 > 3 11:59:16 11:59:45 12:01:17 92 > 4 11:59:16 11:59:42 12:03:07 205 > 5 11:59:16 11:59:36 12:04:20 284 > > Each job starts before the quickest one ends, but they wait for > something just after parsing headers. Only one at a time is able to > proceed import. They must have some shared resource they block when > executing and that is probably the database. But is that how it > supposed to be? Only one user is able to import RawBioAssay at a time > and blocks the db for so long?
I am not able to reproduce this behaviour. I tested with five jobs and they run just fine and the last one to start is actually the second one to finish, just one second after the first job: 2007-10-31 13:12:13 2007-10-31 13:18:02 5 minutes 49 seconds 2007-10-31 13:12:16 2007-10-31 13:18:26 6 minutes 10 seconds 2007-10-31 13:12:28 2007-10-31 13:18:24 5 minutes 56 seconds 2007-10-31 13:12:39 2007-10-31 13:18:25 5 minutes 46 seconds 2007-10-31 13:12:52 2007-10-31 13:18:03 5 minutes 11 seconds Maybe it is a problem with your database configuration. But I am not an expert of that. I have based my configuration on the 'my-innodb-heavy-4G.cnf' that ships with MySQL. Since I don't have 4G memory I had to decrease some memory/buffer sizes. Otherwise I have made no changes. /Nicklas ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ basedb-devel mailing list basedb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/basedb-devel
