Page 1 of 1

I could not find much information about few timeouts....

Posted: Thu Jan 26, 2006 12:34 pm
by raghavan20
1. Can anyone explain me the use of interactive timeout, wait_timeout and connection_timeout?

Code: Select all

mysql> show variables like '%timeout%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| connect_timeout          | 5     |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50    |
| interactive_timeout      | 28800 |
| net_read_timeout         | 30    |
| net_write_timeout        | 60    |
| slave_net_timeout        | 3600  |
| sync_replication_timeout | 10    |
| table_lock_wait_timeout  | 50    |
| wait_timeout             | 28800 |
+--------------------------+-------+
10 rows in set (0.00 sec)
2. Can anyone explaine me the use of long_query_time?

Code: Select all

mysql> show variables like '%long%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| long_query_time | 10    |
+-----------------+-------+
1 row in set (0.02 sec)