Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! Anyway, thanks.  Regards, Mahmood On Monday, April 3, 2017 11:37 PM, Reindl Harald wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good news! > > I c

Re: MySQL server has gone away

2017-04-03 Thread 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. Regards, Mahmood On Monday, April 3, 2017 10:32 PM, Mahmood N wrote: Dear reindl, I tested with both 5 and 1 and see the log files are empty.

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear reindl, 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! Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty.  Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>since when is phpinfo() - the *real* active configuration be it changed >by some config snippet, vhost-configuration or even ini_set() - the same >than a random file in /etc? Sorry I totally didn't understand that sentence... Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>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 Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit the email test, the refresh time for that pa

Re: MySQL server has gone away

2017-04-03 Thread 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_ca

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one terminal and at the same time, submit a test em

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 30912

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
So it likely has died, or perhaps is mis-configured. On April 3, 2017 7:07:25 AM EDT, Mahmood N wrote: Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order o

MySQL server has gone away

2017-04-03 Thread Mahmood N
Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message Debug info: MySQL server has gone away SELECT id, sid, sta