오류가 발생했습니다.mysqld dead but pid file exists
이것은 몇 시간마다 발생합니다. 재부팅하면 잘 되다가 다시 다운되더라구요.
[root@ip-10-0-0-149 log]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 7.8G 1.5G 6.3G 19% /
devtmpfs 486M 56K 486M 1% /dev
tmpfs 499M 0 499M 0% /dev/shm
tail
다음을 제공합니다:
140717 18:28:43 [ERROR] Got an error from thread_id=4432, /builddir/build/BUILD/ mysql-5.5.38/storage/myisam/mi_delete.c:121
140717 18:28:43 [ERROR] MySQL thread id 4432, OS thread handle 0x7ff640688700, q uery id 269080 localhost root updating DELETE FROM wp_statistics_useronline WHERE timestamp < '1405621693'
140717 18:28:43 [ERROR] Got error 134 when reading table './blog/wp_statistics_u seronline'
140717 18:28:43 [ERROR] Got error 134 when reading table './blog/wp_statistics_u seronline'
140717 18:28:43 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './blo g/wp_statistics_useronline.MYI'; try to repair it
140717 18:28:43 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './blo g/wp_statistics_useronline.MYI'; try to repair it
140717 18:28:43 [ERROR] Got an error from thread_id=4433, /builddir/build/BUILD/ mysql-5.5.38/storage/myisam/mi_delete.c:121
140717 18:28:43 [ERROR] MySQL thread id 4433, OS thread handle 0x7ff64074b700, q uery id 269144 localhost root updating DELETE FROM wp_statistics_useronline WHERE timestamp < '1405621693'
답변1
바라보다이 게시물.
REPAIR
테이블을 삭제하거나 복원 해야 할 것 같습니다 .