救命啊，mysql突然把磁盘占满了！在线等

chouxiaozi

071116 11:30:12 [ERROR] /servers/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
071116 11:30:12 [ERROR] /servers/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
071116 11:30:12 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
071116 14:41:35 [ERROR] /servers/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000035' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
071116 14:51:35 [ERROR] /servers/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000035' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
071116 15:01:35 [ERROR] /servers/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000035' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
071116 15:11:36 [ERROR] /servers/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000035' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
071116 15:21:36 [ERROR] /servers/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000035' (Errcode: 2. Waiting for someone to free space... Retry in 60 secs
"worldteam.err" 785L, 33787C

以上是日志

咋天我把mysql的连接数从100改到了1000  请各们帮忙

showsa

如果不是master，把bin-log关闭吧，然后将mysql-bin.0000×× 都删了

tony_413

mysql的权限，还有就是你可以先用mysql_install_db脚本重新初始化一下，然后确认数据库里面有没有host.frm文件。

[ 本帖最后由 tony_413 于 2007-11-16 16:15 编辑 ]

chouxiaozi

好的，谢谢二位

MYSQLER

楼主解决了吗

chouxiaozi

解决了，谢谢！