mysql disk full_Mysql: Disk is full error

最新推荐文章于 2022-10-07 14:55:58 发布

weixin_39615741

最新推荐文章于 2022-10-07 14:55:58 发布

阅读量924

点赞数

文章标签： mysql disk full

本文链接：https://blog.csdn.net/weixin_39615741/article/details/113238497

版权

I have some problem with my mysql server. 120310 6:55:36 [ERROR] /usr/libexec/mysqld: Disk is full writing './virtual/cdrs.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 6:59:14 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysql/virtual/recordedcalls.MYI' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:05:36 [ERROR] /usr/libexec/mysqld: Disk is full writing './virtual/cdrs.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:09:14 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysql/virtual/recordedcalls.MYI' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:15:36 [ERROR] /usr/libexec/mysqld: Disk is full writing './virtual/cdrs.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:19:14 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysql/virtual/recordedcalls.MYI' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:25:36 [ERROR] /usr/libexec/mysqld: Disk is full writing './virtual/cdrs.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:29:14 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysql/virtual/recordedcalls.MYI' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:35:36 [ERROR] /usr/libexec/mysqld: Disk is full writing './virtual/cdrs.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs 120310 7:39:14 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysql/virtual/recordedcalls.MYI' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs

When i do df -h it return me Filesystem Size Used Avail Use% Mounted on /dev/sda3 221G 124G 86G 60% / /dev/sda1 99M 23M 72M 24% /boot tmpfs 2.0G 0 2.0G 0% /dev/shm

it means there is enough disk space available still my log says disk is full..

my /tmp contain a file mysql.log its size is more than 22GB and still increasing.