content_image/799384.jpg
connection process (even before an IP address is known), or are not specific to any particular IP address (such as out-of-memory conditions). 

• Connection_errors_accept 

The number of errors that occurred during calls to accept()  on the listening port. 

• Connection_errors_internal 

The number of connections refused due to internal errors in the server, such as failure to start a new thread or an out-of-memory condition. 

• Connection_errors_max_connections 

The number of connections refused because the server max_connections  limit was reached. 

• Connection_errors_peer_address 

The number of errors that occurred while searching for connecting client IP addresses. 

• Connection_errors_select 

The number of errors that occurred during calls to select()  or poll()  on the listening port. (Failure of this operation does not necessarily means a client connection was rejected.) 

• Connection_errors_tcpwrap 

The number of connections refused by the libwrap  library. 

• Connections 

The number of connection attempts (successful or not) to the MySQL server. 

• Created_tmp_disk_tables 

The number of internal on-disk temporary tables created by the server while executing statements. 

You can compare the number of internal on-disk temporary tables created to the total number of internal temporary tables created by comparing Created_tmp_disk_tables  and Created_tmp_tables values. 

<img src='content_image/799384.jpg'>

See also Section 8.4.4, “Internal Temporary Table Use in MySQL” . 

• Created_tmp_files 

How many temporary files mysqld  has created. 

• Created_tmp_tables 

## Note 

Due to a known limitation, Created_tmp_disk_tables  does not count on-disk temporary tables created in memory-mapped files. By default, the TempTable storage engine overflow mechanism creates internal temporary tables in memory- mapped files. This behavior is controlled by the temptable_use_mmap  variable, which is enabled by default. 

The number of internal temporary tables created by the server while executing statements. 

