MySQL Forums
Forum List  »  General

MySQL restarted due to Disk full
Posted by: karthik rayala
Date: December 04, 2020 09:27AM

Hi Team,

Got mysql restart on one mysql server due to adding the column to existing table.

1. before initiating the alter i have 95 GB disk space free.

2. the table X which is 58GB,, am doing alter on X

3. ALTER TABLE X ADD c_job_id bigint(20) NOT NULL default 0;

4. the disk space decreased until 34GB on the server and the temporary file
also not yet starting consuming disk space(pasted the output below)

root@bagan-master-db:~# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 494G 435G 34G 93% /
none 4.0K 0 4.0K 0% /sys/fs/cgroup
udev 16G 4.0K 16G 1% /dev
tmpfs 3.1G 388K 3.1G 1% /run
none 5.0M 0 5.0M 0% /run/lock
none 16G 0 16G 0% /run/shm
none 100M 0 100M 0% /run/user

root@bagan-master-db:~# ls -lrth /var/lib/mysql/messaging/#sql*
-rw-rw---- 1 mysql mysql 14K Dec 4 11:18 /var/lib/mysql/messaging/#sql-
-rw-rw---- 1 mysql mysql 112K Dec 4 11:18 /var/lib/mysql/messaging/#sql-

5. After that suddenly the disk space is decreasing drastically and it went
100% full and Db restarted..then space released... the time of alter no ther operations are happened except select

7. May i know why this was happen even though i have ample amount of space to
do alter.

Options: ReplyQuote

Written By
MySQL restarted due to Disk full
December 04, 2020 09:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.