How MySQL will act if there is no space left on hard disk?
To answer this question, let’s test it:
Our first test is with MySQL 5.6.24-debug with disabled binary
log:
Trying to import huge dump, after while it says table is full:
Query OK, 12725 rows affected (2.46 sec) Records: 12725 Duplicates: 0 Warnings: 0 Query OK, 12724 rows affected (2.40 sec) Records: 12724 Duplicates: 0 Warnings: 0 Query OK, 12726 rows affected (2.53 sec) Records: 12726 Duplicates: 0 Warnings: 0 ERROR 1114 (HY000): The table 'sales' is full ERROR 1114 (HY000): The table 'sales' is full ERROR 1114 (HY000): The table 'sales' is full
In error log you will see something like:
[root@localhost mysql]# tail -f /opt/mysql/datadir/error.err Version: '5.6.24-debug' socket: '/opt/mysql/datadir/mysqld-new.sock' port: 3307 Shahriyar Rzayev's MySQL 2015-04-24 03:56:09 7fabeffff700 InnoDB: Error: Write to file ./sales2/sales.ibd failed at …[Read more]