On Apr 6, 2005, at 4:47 PM, Frank Bax wrote:
It seems the "bad file number" error was caused by MySQL trying to have more than 128 files open at one time. This was "fixed" by changing MySQL startup, but the "fix" would not have been needed if MySQL were to close open files after some period of "no activity to a table" - does MySQL ever close a file? If I create a table and run a select on it, then there is no access to that table for months (and MySQL is not shutdown or restarted), does MySQL still have the file open?
Perhaps this page in the manual, <http://dev.mysql.com/doc/mysql/en/table-cache.html>, answers your question.
Yes, I ran myisamchk and there are no problems with database.
Frank
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
