Server System Variables 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. If you start  mysqld  with  --skip-new ,  concurrent_insert  is set to  NEVER . See also Section 8.11.3, “Concurrent Inserts” . 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 • connect_timeout 2 Value Description NEVER  (or 0) Disables concurrent inserts AUTO  (or 1) (Default) Enables concurrent insert for  MyISAM tables that do not have holes ALWAYS  (or 2) Enables concurrent inserts for all  MyISAM  tables, even those that have holes. For a table with a hole, new rows are inserted at the end of the table if it is in use by another thread. Otherwise, MySQL acquires a normal write lock and inserts the row into the hole. Command-Line Format --connect-timeout=# System Variable connect_timeout Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 10 Minimum Value 2 Maximum Value 31536000 784 System Variable core_file Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean