| List: | General Discussion | « Previous MessageNext Message » | |
| From: | MAS! | Date: | January 16 2008 9:06am |
| Subject: | Re: Lost Connection each hour :( | ||
| View as plain text | |||
> can you post values of wait_timeout and interactive_timeout > variables. You can get them from SHOW VARIABLES output. If they are > set to 3600 (1 hour in secs), set them to something bigger like one > week and then you will see if it helps or not. You can read more about +--------------------------+-------+ | 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 | | table_lock_wait_timeout | 50 | | wait_timeout | 28800 | +--------------------------+-------+ :( may be I have to increase the net_% variables?
| Thread | ||
|---|---|---|
| • Lost Connection each hour :( | MAS! | 15 Jan |
| • Re: Lost Connection each hour :( | Moon's Father | 16 Jan |
| • Re: Lost Connection each hour :( | MAS! | 16 Jan |
| • Re: Lost Connection each hour :( | Moon's Father | 16 Jan |
| • Re: Lost Connection each hour :( | MAS! | 16 Jan |
| • Re: Lost Connection each hour :( | Moon's Father | 16 Jan |
| • Re: Lost Connection each hour :( | Baron Schwartz | 16 Jan |
| • Re: Lost Connection each hour :( | Dušan Pavlica | 16 Jan |
| • Re: Lost Connection each hour :( | MAS! | 16 Jan |
| • Re: Lost Connection each hour :( | Dušan Pavlica | 16 Jan |
| • Re: Lost Connection each hour :( | Matthias Witte | 17 Jan |
