Stephan_Craft

I use mysql 3.5 years and recently I have a very frustration problem! Here’s what I get from time to time: SQL error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) SQL error code: Date: Monday 14th of July 2008 10:06:25 PM I try to increase - max_connections=1000, but nothing… In /etc/my.cnf file mysql.sock direction is right. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock someone write that it can be because of the localhost, so I try this bind-address=My-Server-IP but still this error appears(( I notice another thing, when my DB size was over 2GB, I start to get this error… maybe this is a coincident I don’t know. this is mysql status: mysql Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3 Connection id: 808144 Current database: sadmin_fou Current user: sadmin_fou@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 4.1.22-standard Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 5 hours 45 min 22 sec PHP: PHP 4.4.8 (cli) (built: Feb 16 2008 12:49:24) Copyright © 1997-2008 The PHP Group Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies with eAccelerator v0.9.5.2, Copyright © 2004-2006 eAccelerator, by eAccelerator with Zend Extension Manager v1.2.0, Copyright © 2003-2006, by Zend Technologies with Zend Optimizer v3.2.8, Copyright © 1998-2007, by Zend Technologies Please help me solve this problem. Regards, Stephan.