Hello, I have a multi-threaded application written in Delphi and I am having a mysterious problem. There are 4 threads that write to several MySQL tables, but I am seeing what looks to be some type of “deadly embrace” that I don’t know how to resolve. Each thread has a separate database connection (using ZeosLib) and when two of the threads attempt to read a table, and a third thread simultaneously tries to either read or write to the same table, all three threads are locking up. Does anyone know how to resolve these issues with MySQL (I’ve never seen this kind of behavior with MS-SQL)? My current workaround is to only allow two threads to access the table simultaneously, but I’m not happy with it. Also, the database is running on the local machine, and I am not issuing any file locks. All access to the tables are via SELECT, INSERT, DELETE or UPDATE queries. MySQL version is: 3.23.52-nt Thanks for any advice… Dan Cumpian
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
