content_image/676875.jpg content_image/676876.jpg content_image/676877.jpg content_image/676879.jpg
<img src='content_image/676875.jpg'>

If AUTO  (the default), MySQL permits INSERT  and SELECT  statements to run concurrently for MyISAM tables that have no free blocks in the middle of the data file. 

This variable can take the values shown in the following table. The variable can be assigned using either the name values or corresponding integer values. 

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

If you start mysqld  with --skip-new , concurrent_insert  is set to NEVER . 

See also Section 8.11.3, “Concurrent Inserts” . 

• connect_timeout 

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

The number of seconds that the mysqld  server waits for a connect packet before responding with Bad handshake . The default value is 10 seconds. 

Increasing the connect_timeout  value might help if clients frequently encounter errors of the form Lost connection to MySQL server at ’ XXX ’, system error: errno . 

• core_file 

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

