MySQL – Database Server Down: File /dev/vda1 Used Up All Disk Space

disk-spaceMySQL

My database server went down last night because there was no diskspace available. I checked what used up diskspace and it was 28GB by /dev/vda1

I have no clue what this is. The database all together will be a maximum of 1 GB diskspace, what is using up all this space?

When I start mysql, I get:

error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'

This is probably also because of the diskspace issue.

Hopefully someone can help me shortly. Many thanks in advance!

Best Answer

I probably found the reason, I made nightly backups to external server, but those were also stored on our server which had exceeded allowed disk usage. I didn`t understand /dev/vda1 at first, but I now get that is not a file but probably a partition or something like that.

Related Solutions

Thesqld – cannot connect to socket after changing datadir location

The problem is the mysql client program configuration. You can specify the --socket=/NEW_DIR/mysql/mysql.sock command-line option or add it under the [mysql] section of your my.cnf file.

Please look at the documentation for specifying options through option files: http://dev.mysql.com/doc/refman/5.0/en/option-files.html

Since changing the socket path affects all the client programs, then it will make sense to update the global my.cnf and set the socket option under the [client] section.

Mysql – Problems in opening MySQL Query Browser

This question is already being answered https://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38:

If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with
socket=/var/lib/mysql/mysql.sock
you can check if mysql is running with the following command:
mysqladmin -u root -p status
try changing your permission to mysql folder. If you are working locally, you can try:
sudo chmod -R 755 /var/lib/mysql/
that solved it for me

Best Answer

Related Solutions

Thesqld – cannot connect to socket after changing datadir location

Mysql – Problems in opening MySQL Query Browser

Related Question