☰

Mysql：磁盘已满写入

tag-icon • tag-icon mysql centos
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. 文件系统损坏或硬盘故障。

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

相关内容