mysql — Can’t connect to local MySQL server

All website in the server can not work. All of them throw out error message as below:
Can’t connect to local MySQL server

i tried to restart mysql server,but it can not be restarted.
well,i need to check the mysql log file.well,i got the problem:

14:03:00 [ERROR] /usr/sbin/mysqld: Disk is full writing ‘./mysql-bin.000047′ (Errcode: 28). Waiting for someone to free space… (Expect up to 60 secs delay for server to continue after freeing disk space)

Source code    
df -alh

i found that the /var partition is full,which is used to store mysql process file.so no new connection can be established. and you even cannot restart the mysql server.as restart mysql server also need to create process file in this partion

so the only thing to do is to free disk space, clean log file,remove uneeded backup file

Source code    
/etc/init.d/mysqld restart

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*


9 − = two

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>