I have an application that updated or inserted 26,000 records into a MySQL INNODB table in about 12 minutes... A creditable performance as far as I am concerned. However, the application failed on one of the last insert/updates with a lock wait timeout. My script issues a commit every 250 transactions which, I believe, releases any locks up to that point. I've increased lock_wait_timeout to 75 (what is a reasonable higher end limit for this?) but still get the error. I'm using v.4.0.16 on a RH 9.0 box. Any thoughts on what might be happening here? Thanks. Randy
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
