Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ What happens after the MySQL disk space is full     - Oracle Migration partition table (Database)

- CentOS7 virtual machine settings, and bridging problems (Linux)

- Spring Data MongoDB combat (Database)

- VMware virtual machine Ubuntu install arm-linux-gcc cross-compiler environment (Linux)

- CentOS 5.10 installed Oracle 11G R2 (Database)

- C # C ++ Java interface type conversion (Programming)

- iptraf: A Practical TCP / UDP network monitoring tools (Linux)

- Actual custom yum repository ---- gem commands commonly used parameters (Linux)

- Java integrated development environment common set of operations (Linux)

- VirtualBox CentOS is configured as a local disk mirroring software source (Linux)

- Google open source TCP team repaired the Linux kernel TCP flaw (Linux)

- Ora-00020: maximum number of processes (500) exceeded (Database)

- Oracle view object space usage show_space (Database)

- Java thread lifecycle (Programming)

- ORA-01157 & ORA-01110 Troubleshooting (Database)

- Compression decompression command under Linux (Linux)

- MySQL server after an unexpected power outage can not start (Database)

- OpenGL Superb Learning Notes - GLSL language foundation (Programming)

- XenServer virtual machines installed in dual-card configuration (Server)

- Linux System Getting Started Learning: The Linux anacron command (Linux)

 
         
  What happens after the MySQL disk space is full
     
  Add Date : 2017-04-13      
         
         
         
  REVIEW

When the disk space is full, MySQL what happens? How they should respond?

What happens

When the disk space is filled, MySQL is unable to write any data, including data written to the table, and binlog, binlog-index and other documents.

Of course, because InnoDB is dirty data can be placed in memory, so it will not show up immediately can not be written unless opened binlog, write request will be blocked.

When MySQL detects the disk space is full, it will:

Per minute: check whether the space is released, in order to write new data. When there is free space, it will continue to write data, as usual.
Every ten minutes: If you still have not found the remaining space, it writes a record in the log reports of disk space is full (this time only a few bytes written or enough).
How should I do

So, when you notice the disk space is full, how should we deal with it, we recommend:

Improve the monitoring system detecting a frequency to prevent recurrence;
Promptly remove unused files to free up space;
If the thread is full of problems because disk is blocked, it can kill the first, until the next minute it may be re-tested and can work properly;
May lead to some due to disk full thread is blocked, causing other threads are blocked, can kill the lead to blocked thread, other threads are blocked also be able to continue working.
exception

There are exceptions:

When performing REPAIR TABLE or OPTIMIZE TABLE operation, or after executing the ALTER TABLE or LOAD DATA INFILE batch update the index, these operations will create temporary files when the execution of these operations mysqld find disk space is full, this will involve to the table is marked as crashed, delete temporary files (except ALTER tABLE operation, MySQL will abort the operation being performed, remove temporary files, free up disk space).

NOTE: When the execution of these commands mysqld process is killed accidentally, then it generates temporary files are not deleted automatically, you need to manually delete to free up disk space.
     
         
         
         
  More:      
 
- Let Git variety of colors and custom log format output (Linux)
- Practical Handbook: 130+ improve the efficiency of commonly used commands Vim (Linux)
- Install Ubuntu 14.04 and Windows 8 / 8.1 dual-boot in UEFI mode (Linux)
- MySQL performance comparison of large amounts of data storage (Database)
- Linux find command to find files (Linux)
- ThinkPad X220 Ubuntu 14.10 installed on fingerprint recognition (Linux)
- learning Linux ls command examples (Linux)
- Spring use Cache (Programming)
- Nodejs command-line program development tutorial (Programming)
- ORA-12545: Connection failed because the target host or object does not exist (Database)
- Android Studio installed in Ubuntu 15.04 (Linux)
- C ++ hash function (Programming)
- xCAT error Unable to dispatch hierarchical sub-command to NORESOLUTION: 3001 (Linux)
- Installation and configuration to compile MySQL 5.6.10 under CentOS 5.9 (Database)
- OpenResty load balancing MySQL (Database)
- Hackers is how the invasion and control of Things devices? (Linux)
- Android start automatically and add and delete a desktop shortcut (Programming)
- Ubuntu 14.04 LTS NTFS partition can not access solution (Linux)
- Use Linux built-in firewall to improve network access control (Linux)
- The basic principle of pointers in C ++ (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.