title: What is the meaning of different mysql timeouts
body: <p>I searched a lot on the internet but not found any brief explanation on mysql timeouts with examples. I want to know the meaning of mysql diffenernt timeouts as listed below and also want to know why and when we use them.</p>
  
  <pre><code>+----------------------------+----------+
  | Variable_name              | Value    |
  +----------------------------+----------+
  | connect_timeout            | 10       |
  | delayed_insert_timeout     | 300      |
  | innodb_lock_wait_timeout   | 50       |
  | interactive_timeout        | 28800    |
  | net_read_timeout           | 3        |
  | net_write_timeout          | 60       |
  | slave_net_timeout          | 3600     |
  | wait_timeout               | 28800    |
  +----------------------------+----------+
  </code></pre>
  
  <p>Also in ruby on rails application i can set <code>read_timeout</code> in my database.yml file. if query is not able to read the data within specified <code>read_timeout</code> value mysql will close the connection. so i also want to know what is the differentce between <code>net_read_timeout</code> and <code>read_timeout</code></p>
  
  <p>Thanks,</p>