Linux MySQL timeout

From Site
http://dba.stackexchange.com/questions/10578/client-times-out-while-mysql-query-remains-running

mysql> show variables like '%timeout'; ++---+ ++---+ ++---+ 10 rows in set (0.00 sec)
 * Variable_name             | Value |
 * connect_timeout           | 10    |
 * delayed_insert_timeout    | 300   |
 * innodb_lock_wait_timeout  | 50    |
 * innodb_rollback_on_timeout | OFF  |
 * interactive_timeout       | 60    |
 * net_read_timeout          | 30    |
 * net_write_timeout         | 60    |
 * slave_net_timeout         | 3600  |
 * table_lock_wait_timeout   | 50    |
 * wait_timeout              | 60    |

My VM
mysql> show variables like '%timeout'; ++--+ ++--+ ++--+ 10 rows in set (0.00 sec)
 * Variable_name             | Value    |
 * connect_timeout           | 10       |
 * delayed_insert_timeout    | 300      |
 * innodb_lock_wait_timeout  | 50       |
 * innodb_rollback_on_timeout | OFF     |
 * interactive_timeout       | 28800    |
 * lock_wait_timeout         | 31536000 |
 * net_read_timeout          | 30       |
 * net_write_timeout         | 60       |
 * slave_net_timeout         | 3600     |
 * wait_timeout              | 28800    |


 * Found this here --> http://edwin.baculsoft.com/2010/11/set-mysql-connection-timeout/
 * trying updating my variables

mysql> SET GLOBAL wait_timeout=30; Query OK, 0 rows affected (0.00 sec)

mysql> mysql> mysql> mysql> show variables like '%timeout'; ++--+ ++--+ ++--+ 10 rows in set (0.00 sec)
 * Variable_name             | Value    |
 * connect_timeout           | 30       |   <--- this one worked
 * delayed_insert_timeout    | 300      |
 * innodb_lock_wait_timeout  | 50       |
 * innodb_rollback_on_timeout | OFF     |
 * interactive_timeout       | 28800    |
 * lock_wait_timeout         | 31536000 |
 * net_read_timeout          | 30       |
 * net_write_timeout         | 60       |
 * slave_net_timeout         | 3600     |
 * wait_timeout              | 28800    |   < Did not updated :\

mysql>


 * UPDATE -- Some variables are not in the "GLOBAL" variables

mysql> mysql> show variables like '%timeout'; ++--+ ++--+ ++--+ 10 rows in set (0.00 sec)
 * Variable_name             | Value    |
 * connect_timeout           | 10       |
 * delayed_insert_timeout    | 300      |
 * innodb_lock_wait_timeout  | 50       |
 * innodb_rollback_on_timeout | OFF     |
 * interactive_timeout       | 28800    |
 * lock_wait_timeout         | 31536000 |
 * net_read_timeout          | 30       |
 * net_write_timeout         | 60       |
 * slave_net_timeout         | 3600     |
 * wait_timeout              | 28800    |

mysql> mysql> mysql> mysql> mysql> mysql> SET wait_timeout=30; Query OK, 0 rows affected (0.00 sec)

mysql> mysql> mysql> mysql> show variables like '%timeout'; ++--+ ++--+ ++--+ 10 rows in set (0.00 sec)
 * Variable_name             | Value    |
 * connect_timeout           | 10       |
 * delayed_insert_timeout    | 300      |
 * innodb_lock_wait_timeout  | 50       |
 * innodb_rollback_on_timeout | OFF     |
 * interactive_timeout       | 28800    |
 * lock_wait_timeout         | 31536000 |
 * net_read_timeout          | 30       |
 * net_write_timeout         | 60       |
 * slave_net_timeout         | 3600     |
 * wait_timeout              | 30       |

mysql> SET lock_wait_timeout=30; Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%timeout'; ++---+ ++---+ ++---+ 10 rows in set (0.00 sec)
 * Variable_name             | Value |
 * connect_timeout           | 10    |
 * delayed_insert_timeout    | 300   |
 * innodb_lock_wait_timeout  | 50    |
 * innodb_rollback_on_timeout | OFF  |
 * interactive_timeout       | 28800 |
 * lock_wait_timeout         | 30    |
 * net_read_timeout          | 30    |
 * net_write_timeout         | 60    |
 * slave_net_timeout         | 3600  |
 * wait_timeout              | 30    |

mysql> SET interactive_timeout=30; Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%timeout'; ++---+ ++---+ ++---+ 10 rows in set (0.00 sec)
 * Variable_name             | Value |
 * connect_timeout           | 10    |
 * delayed_insert_timeout    | 300   |
 * innodb_lock_wait_timeout  | 50    |
 * innodb_rollback_on_timeout | OFF  |
 * interactive_timeout       | 30    |
 * lock_wait_timeout         | 30    |
 * net_read_timeout          | 30    |
 * net_write_timeout         | 60    |
 * slave_net_timeout         | 3600  |  <-- Done ;)
 * wait_timeout              | 30    |

mysql>