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 your connection fails? Please, perform the following statements when the problem occurs again and provide its' output: SHOW STATUS; SHOW VARIABLES; SHOW PROCESSLIST; Lev Shamardin <[EMAIL PROTECTED]> wrote: > 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 the server does not > close the tables automatically, e.g. if you open two windows and start > mysql -u root in both, then run "SHOW OPEN TABLES" in one window, it > will display 0 open tables. Then you run "USE <database>" in the > second window, and SHOW OPEN TABLES in the first will display 8 open > tables. But when you exit from mysql client in the second window, the > SHOW OPEN TABLES in the first one still shows 8 open tables, and this > number grows after each reconnect to any of the databases on the > server. > > We have several databases with small tables (~1000 rows) which are > SELECTed and UPDATED every 10 seconds, and one big table (~1000000 > rows) into which the records are INSERTed several times an hour. The > number of concurrent connections is rather small - usually no more > then 2-3 connections. > > What can be wrong and how can we fix the problem? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
