Re: mysql server does not close tables

2005-07-20 Thread Gleb Paharenko
Hello. > | | open_files_limit | 50 You have a very low value for open_files_limit. Increase it to several thousands. See: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html Please next time send you answers to the list. > On 7/20/05, Gleb Paharenko <[EMAIL PR

Re: mysql server does not close tables

2005-07-20 Thread Gleb Paharenko
Hello. > table_cache size is 64. I also discovered that the server does not > close the tables automatically, e.g. if you open two windows and start MySQL usually closes tables only in some cases. See: http://dev.mysql.com/doc/mysql/en/table-cache.html What error do you obtain when

mysql server does not close tables

2005-07-20 Thread Lev Shamardin
Hi all, We have a Mysql 4.0.24 running on FreeBSD 4.11 Yesterday server started to refuse new connections, while the established connections did function properly. I discovered that the problems start when the number of open tables reaches 20, the table_cache size is 64. I also discovered that th