Search found 2 matches

by goiasi
21.03.2006, 12:41
Forum: 6.1.5
Topic: Mysql: client is using or hasn't closed the table properly
Replies: 4
Views: 2692

Ok. I thought it was problem of the client library that doesn't close correctly the connection. Executing a command FLUSH TABLE <table> after the insert the myisamchk doesn't give the warning. It would be a good practice executing the flush command after the inserts or it slow down much the applicat...
by goiasi
20.03.2006, 19:33
Forum: 6.1.5
Topic: Mysql: client is using or hasn't closed the table properly
Replies: 4
Views: 2692

Mysql: client is using or hasn't closed the table properly

Hi. I created an application that realize an insert in a table in MySQL 4.0. I realized the insert using method ExecSQL of TZQuery zeosdbo and after that I disconnect from the database using TZConnection.Disconnect. But executing the command myisamchk it warns about tables closed incorrectly # myisa...