#innodb_temp/temp_8.ibt, desired size 16384 bytes. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.įor InnoDB it looks like so: posix_fallocate(): Failed to preallocate data for file. Turning logging off for the server process. Message reprinted in 600 secs.įor slow query log you would see an error message like so: Could not use /var/log/mysql/mysql-slow.log for logging (error 28 - No space left on device). Message reprinted in 600 secs.įor relay log the error message looks like so: Disk is full writing './relay-bin.000007' (OS errno 28 - No space left on device). When the MySQL server ran out of disk space, you would see one of the following errors in your application (as well as in the MySQL error log): ERROR 3 (HY000) at line 1: Error writing file '/tmp/AY0Wn7vA' (Errcode: 28 - No space left on device)įor binary log the error message looks like so: Disk is full writing './binlog.000019' (OS errno 28 - No space left on device).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |