Re: MySQL 4 goes to sleep with table locks?

2004-02-07 Thread Alfredo Cole
El Sáb 07 Feb 2004 02:28, escribió: Mr. Alfredo Pls, will you give the complete structure as 'create query' of your database? that will help us to solve your problem. Pradap This is the structure of the table that holds the sequential numbers for various documents that need them: CREATE

MySQL 4 goes to sleep with table locks?

2004-02-06 Thread Alfredo Cole
I am using Mandrake 9.1 and MySQL 4.0.11 from the LM CD's. In my application, I have a table that stores the sequential numbers of invoices prepared by several stores. Every time a salesman prepares an invoice for a customer, the system goes to this table, locks it with lock tables table