MySQL data connection time-out setting

Large-scale multi-threaded operation of the transaction, sometimes open a link, will wait, this time if the database time-out setting is too short, it may appear, the data link is automatically released, of course, set too large is not good, slow SQL or other factors caused by long chain, resulting in the entire system is slow, even hang off. So, set the time-out appropriately. Setup method:

SHOW GLOBAL VARIABLES like '%timeout% '
SET GLOBAL wait_timeout=10000

MySQL data connection time-out setting