服务器 Gind.cn
  1. 服务器 Gind.cn
  3. Mysql：磁盘已满写入
Intereting Posts
Nagios / NSCA：命令文件'/var/nagios/rw/nagios.cmd'不存在 Nginxredirect帮助 Windows 8 x64与VMWare Workstation或内部ESXi Amavis的postfix在mail.log中返回“name = localhost type = A：Host not found” Dovecot LDA（交付）和LDAP组 将公共文件夹中的通讯组列表移动到Sharepoint联系人？ Zimbra 8.7.1：连接：无法从ldap确定启用的服务 PHP升级后停止工作 Windows 7：有无名的用户安装和改变字体 无法在CentOS 5.5上configuration配额。 奇怪的行为quotacheck和其他配额命令 最好的方法来testing打开的端口 在生产中使用更新的Xen Dom0内核 “无法find自动发现服务”：Exchange 这个目录下文件的目的是什么：/ var / lib / apt / lists？ 在Ubuntu中授予Windows域用户的权利？

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输出 

 [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. mysql用户的磁盘配额？
  2. 文件系统损坏或硬盘故障。

你是否在开机或在系统日志中看到任何文件系统错误？