疯狂痴呆 发表于 2015-4-25 20:40:34

MYSQL重启不了，一直卡在shutting down mysql

licess 发表于 2015-4-27 16:19:42

150425 19:50:08 /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_a3b_0.MYI'; try to repair it
150425 19:50:08 Got an error from unknown thread, /root/lnmp1.1-full/mysql-5.5.37/storage/myisam/mi_write.c:226

df -h看一下/tmp是否单独的分区，目录是否已满
检查/tmp 目录权限是否777
都没问题可以尝试使用/usr/local/mysql/bin/myisamchk 命令进行数据表修复
页: [1]
查看完整版本: MYSQL重启不了，一直卡在shutting down mysql