之前经常出现502错误，按论坛置顶的方法，现在不出现502，MYSQL却经常崩溃
之前经常出现502错误，按https://bbs.vpser.net/thread-1144-1-1.html 这里的方法，现在不出现502了，但MYSQL几乎是每隔2天就要崩溃一次，必须重启MYSQL才能行，军歌帮忙看看怎么弄啊我的是VPS，1G内存，centos5.6系统，150G硬盘，空间绝对够用
/usr/local/mysql/var/主机名.err 错误日志超过字数限制了，打包上传了，麻烦下载看下
[ 本帖最后由 jmxye 于 2012-7-7 06:29 编辑 ] 挂载和硬盘情况
# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/hda3 4956416198325 4758091 5% /
/dev/hda1 26104 49 26055 1% /boot
tmpfs 129386 1129385 1% /dev/shm
/dev/hdb1 17039360122187 16917173 1% /home/wwwroot
You have new mail in /var/spool/mail/root
# df -h
Filesystem SizeUsed Avail Use% Mounted on
/dev/hda3 19G 17G1.4G93% /
/dev/hda1 99M 28M 67M30% /boot
tmpfs 506M 0506M 0% /dev/shm
/dev/hdb1 128G3.0G119G 3% /home/wwwroot
# 1206063:04:48 /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000014' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
1206063:04:48 /usr/local/mysql/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
按提示是硬盘满了，/ 目录下可用空间太少了 原帖由 licess 于 2012-7-7 07:39 发表 https://bbs.vpser.net/images/common/back.gif
1206063:04:48 /usr/local/mysql/libexec/mysqld: Disk is full writing './mysql-bin.000014' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continu ... 军歌我的有150G硬盘啊，怎么会空间小呢
我之前是挂载在home/wwwroot下的
现在该怎么弄啊，麻烦帮忙 可以按https://www.vpser.net/manage/delete-mysql-mysql-bin-0000-logs.html 删除日志应该会腾出一些空间
也可以按https://www.vpser.net/manage/mysql-import-export.html 这个先备份数据，在按http://lnmp.org/faq.html 这个把数据mysql 改到/home/wwwroot/目录
页:
[1]