>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 changed wait_timeout=30 t
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_ti
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.
I am reall
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
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
>
>
So I set long_query_time=5 and restarted the service. Test the email page
again. Still the logs are empty.
Regards,
Mahmood
>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
Am 03.04.2017 um 19:26 schrieb 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 th
>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
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-ha
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
Am 03.04.2017 um 17:52 schrieb 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 te
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
On 4/3/2017 8:15 AM, Mahmood N wrote:
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 ;
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
I'd suspect the underlying query is poorly designed for the amount of data
you have stored. If you have access to the mysql server you could connect
to it using any mysql client and run 'show full processlist' to see the
query as that page is trying to load. The query is probably in the 'sending
da
Thanks for the quick reply. So, how can I get further information?
Thing is that, after 5 minutes, when I refresh the page every thing is normal.
Regards,
Mahmood
On Monday, April 3, 2017 3:39 PM, Ken D'Ambrosio wrote:
Basically, it says that MySQL is not responding to queries. So it
Basically, it says that MySQL is not responding to queries. 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,
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
19 matches
Mail list logo
