If I use a FLUSH TABLES command, what will happen to others that might be in the middle of using a table?
I have a PHP application running on PHP 4.0.3 that doesn't seem to close tables properly, and I am constantly having trouble with the mySQL server crashing on me. I shut down the server, ran myisamchk on all tables, and I had a range of messages from: myisamchk: warning: 1 clients is using or hasn't closed the table properly to myisamchk: warning: 185 clients is using or hasn't closed the table properly ...depending on the table. But almost every table had at least 1 of these messages And I know that those tables are not in use at the time. So I'm thinking that it might be good to add a FLUSH TABLES command to the bottom of every page that uses mySQL. But this means that FLUSH TABLES would be run at least about 5-10 times each minute. Is that going to burden the server? - Jonathan --------------------------------------------------------------------- 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
