Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ What happens after the MySQL disk space is full     - Kubernetes cluster deployment (Server)

- Linux System Getting Started Learning: On Linux how to convert text files to PDF (Linux)

- Analysis of common mistakes when compiling MySQL installation (Database)

- Linux Timing task Crontab command Detailed (Linux)

- Django 1.8 TEMPLATE_DIRS configuration and STATICFILES_DIRS (Server)

- Can not remember how to solve the problem under Ubuntu brightness setting (Linux)

- C # Future: Tracking null reference (Programming)

- Erlang concurrency and foundation (Programming)

- libreadline.so.6: can not open shared object file problem solution (Linux)

- Linux use iptables ban Ping (Linux)

- Appweb configuration in detail (Server)

- RPM package fabrication method (Linux)

- Sublime Text 3 best features, plug-ins and settings (Linux)

- How to configure FirewallD in RHEL / CentOS 7 and Fedora in (Linux)

- Ubuntu System Log Configuration / var / log / messages (Linux)

- Ubuntu install Lighttpd + Mono support .net (Linux)

- Timing task Crontab under Linux system (Linux)

- Ubuntu 14.04 LTS 64-bit installation and activation Sublime Text 3 can not solve the Chinese input method to solve the problem (Linux)

- How to configure MariaDB replication in CentOS Linux (Database)

- Adding SSH to Github (Linux)

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

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.

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.
- Install minimize RHEL / CentOS 7 some things need to do (Linux)
- Linux RAID Set RAID 10 or 0 + 1 (Linux)
- Linux operating system security settings initial understanding (Linux)
- MongoDB configuration in Ubuntu 14.04 (Database)
- Nginx configuration support f4v video format player (Server)
- Use chattr and lsattr command to manage linux files and directory attributes (Linux)
- git checkout generated in the use of temporary br (Linux)
- Linux kernel compilation, the configuration of the motor drive (Programming)
- Detailed Linux network security policies and protection measures (Linux)
- Ubuntu 15.10 / 14.04 install subtitling software Aegisub (Linux)
- Upgrading Oracle to (Database)
- Linux novice common commands (Linux)
- Linux environment installation of rvm and ruby (Linux)
- Storm how to ensure that at least once semantics (Programming)
- Linux scheduling summary (Linux)
- Ubuntu install Eclipse for C / C ++ and related configuration (Linux)
- How do I upgrade to Ubuntu 15.04 (Beta) (Linux)
- 10 Nginx safety tips (Linux)
- Terminal Linux command prints - echo (Linux)
- CentOS7 install NTFS-3G driver (Linux)
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.