Re: MySQL server has gone away
Reindl Harald <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Organization | the lounge interactive design |
| Message-ID | <[email protected]> |
Am 03.04.2017 um 21:22 schrieb Mahmood N: >>well, who did set it that low? > > ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! on a proper server you have a local smtpd like postfix listening on 127.0.0.1 and hence you can send thousands of messages within seconds from a web-application and your local relay queues messages and try to deliver them by default up to 5 days when you use a remote smtpd directly froma php application your are doing all wrong - what when the smtpd is not reachable or got restarted in the middle of sending? how to act on a 4xx temporary error? anything which takes more then 30 seconds needs to be fixed proper and then the timeout would not have been a probkem at all > On Monday, April 3, 2017 11:37 PM, Reindl Harald > <[email protected]> wrote: > > Am 03.04.2017 um 20:41 schrieb Mahmood N: >> Good news! >> >> I changed wait_timeout=30 to wait_timeout=600 and now the error >> disappears... I don't know if long_query_time=1 has effect. > > well, who did set it that low? > > https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_timeout > > http://orbisius.com/howto/web-development/change-mysqls-wait_timeout-interactive_timeout-variables/ > > >> On Monday, April 3, 2017 10:32 PM, Mahmood N <[email protected] > <mailto:[email protected]>> wrote: >> I tested with both 5 and 1 and see the log files are empty. >> >> I am really confused about that error and it is taking more than 2 weeks >> about that! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql