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
