> 1) Are your users connected temporarely (disconnecing after a certain time) or > do you stay connected until the server crashes ;-)
Both temporary connections and persistent connections. The number of connections fluctuates based on the number of simultaneous clients. > 2) Check your processlist and see if your max user connections or > max connections (depending on your client) is reached. max_connections was set to 2000 and the threads connected was still under 500. > Best regards > > Nils Valentin > Tokyo/Japan >> I have a system that when I start mysqld, it works fine for a while >> (anywhere from 10 minutes to 2 hours) and then stops taking connections. I >> get the Can't connect to local MySQL server through socket ... however, the >> socket is still there. >> >> What's even weirder, is that any processes that are still connected, >> continue to work fine. >> >> The MySQL server installed is 3.23.56 binary for AIX 5.1 Standard >> downloaded off of a mysql.com mirror. >> >> Anyone have any ideas on how to solve this problem or why it might be >> happening? > -- > ================================================ > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp/staff/nils > ------------------------------------------------ > 有限会社ナレッジデザイン > 〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F > Phone: 0424-40-7912 Fax: 0424-40-7913 > URL: http://www.knowd.co.jp >================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
