Mysql:磁盘已满写入

Mysql:磁盘已满写入

最近我的 mysql 服务器出现了一些问题,因此我决定检查错误日志:


[root@LSN-D1179 log]# tail -10 mysqld.log  
100325 19:30:03 [ERROR] /usr/libexec/mysqld: Table './lfe/actions' is marked as crashed and should be repaired  
100325 19:30:03 [ERROR] /usr/libexec/mysqld: Table './lfe/actions' is marked as crashed and should be repaired  
100325 19:30:18 [ERROR] /usr/libexec/mysqld: Disk is full writing './omuz/ibf_task_logs.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs  
100325 19:34:34 [ERROR] /usr/libexec/mysqld: Disk is full writing './omuz/ibf_profile_portal_views.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs  
100325 19:39:46 [ERROR] /usr/libexec/mysqld: Disk is full writing './omuz/ibf_posts.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs  
100325 19:40:18 [ERROR] /usr/libexec/mysqld: Disk is full writing './omuz/ibf_task_logs.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs  
100325 19:44:34 [ERROR] /usr/libexec/mysqld: Disk is full writing   './omuz/ibf_profile_portal_views.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs  
100325 19:49:46 [ERROR] /usr/libexec/mysqld: Disk is full writing './omuz/ibf_posts.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
100325 19:50:18 [ERROR] /usr/libexec/mysqld: Disk is full writing './omuz/ibf_task_logs.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
100325 19:54:34 [ERROR] /usr/libexec/mysqld: Disk is full writing './omuz/ibf_profile_portal_views.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs  

这是我的 df -h 输出


[root@LSN-D1179 log]# df -h  
Filesystem            Size  Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00
                      143G  6.2G  129G   5% /  
/dev/sda1              99M   12M   83M  13% /boot  
tmpfs                 490M     0  490M   0% /dev/shm  

如您所见,我有足够的可用空间;所以我无法找出 mysqld.log 中的这些“磁盘已满”错误。

有人知道我该怎么做才能解决这个问题吗?

乌古尔

答案1

我能想到的只有两件事:

  1. mysql 用户的磁盘配额?
  2. 文件系统损坏或硬盘故障。

您在启动时或在系统日志中看到任何文件系统错误吗?

相关内容