centos+lmnpa用了一段时间居然吃完了空间,mysql也连接不了
centos+lmnpa,用了一段时间,之前一直有4g多可用空间的也没装过什么,一直开着,今天网站突然上不了,看了看可用空间居然为0,究竟是哪里的吃了那么多空间啊?
mysql 发现没了mysql.sock
以下是错误日志
110831 20:20:02 mysqld_safe mysqld from pid file /usr/local/mysql/var/MyVPS1289.pid ended
110831 20:20:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110831 20:20:58 Event Scheduler: Loaded 0 events
110831 20:20:58 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
110907 10:33:03 /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000012110907 14:31:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110907 14:31:30 Event Scheduler: Loaded 0 events
110907 14:31:30 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
110907 14:36:29 /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000013' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
110907 14:36:29 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 14:46:29 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 14:56:29 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 15:02:49 /usr/local/mysql/libexec/mysqld: Normal shutdown
110907 15:02:49 Event Scheduler: Purging the queue. 0 events
110907 15:02:51 /usr/local/mysql/libexec/mysqld: Forcing close of thread 624user: 'root'
110907 15:03:29 /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000013' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
110907 15:03:29 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 15:13:29 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 15:18:50 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 15:30:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 15:33:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 15:40:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprint110907 17:20:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 17:30:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 17:40:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110907 17:57:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
[ 本帖最后由 vincess 于 2011-9-7 18:50 编辑 ] 我好像开了日志,请问怎么关掉啊? https://www.vpser.net/manage/delete-mysql-mysql-bin-0000-logs.html
页:
[1]