Re: MySQL server has gone away

Am 03.04.2017 um 19:45 schrieb Mahmood N:
> So I set long_query_time=5 and restarted the service. Test the email
> page again. Still the logs are empty

WTF - you had it set to 5 seconds 2 hours ago
i am out here...........

Am 03.04.2017 um 18:11 schrieb Mahmood N:
 > The my.conf file contains
 >
 > log_error=/var/log/mysql/error.log
 > slow_query_log=1
 > slow_query_log_file=/var/log/mysql/error_slow.log
 > max_connections=200
 > max_user_connections=30
 > wait_timeout=30
 > interactive_timeout=50
 > long_query_time=5
 > character-set-client-handshake = FALSE
 > thread_concurrency = 8
 > query_cache_size = 16M
 > thread_cache_size = 8
 > max_allowed_packet = 8M

"long_query_time=5" is low when you talk about 5 seconds as i remember 
in previuos posts - given that a reasonable server should be able to 
handle hunredts to thousands of requests per second anything above 1 
second is a alert sign

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql