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
f
>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,
Are you using connection pooling in your application?
Regards,
Chandru
On 5/27/2011 11:05 AM, Claudio Nanni wrote:
'MySQL server has gone away'
Can be a network problem,
Just to increase complexity :)
On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote:
I had experience with such type of error,
Try setting wait_timeout=36000
Regards,
Chandru
On 5/29/2011 11:13 PM, ars k wrote:
Hi Aveek,
I would like to suggest some points here:
You could try increasing the max allowed packets to 128MB. Though you think
16MB is enough, increasing it is not going to affect the server. It is
dynamic valu
Hi Aveek,
I would like to suggest some points here:
You could try increasing the max allowed packets to 128MB. Though you think
16MB is enough, increasing it is not going to affect the server. It is
dynamic value, so you could revert back the changes if you feel so.
Also make sure log_warnings=2 wh
'MySQL server has gone away'
Can be a network problem,
Just to increase complexity :)
On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote:
> I had experience with such type of error, It was due lack of resources
> available to MySql, max connections exceeds on the server.
> you can write a simple scr
I had experience with such type of error, It was due lack of resources
available to MySql, max connections exceeds on the server.
you can write a simple script which will grab and store output of 'show
processlist' every min. and later you cna investigate the issue.
On Wed, May 25, 2011 at 3:34 A
Nothing in the error log or the slow query log that suggests that the query
size is too large or us taking too much time to execute.
Thanks
Aveek
On May 25, 2011, at 3:53 PM, Rik Wasmus wrote:
>> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?":
>> MySQL server has gone
> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?":
> MySQL server has gone away
>
> The error "MySQL server has gone away" is the error from the db handle. Can
> anyone give me any pointers on why that happens? I looked up the
> documentation in MySQL docs and the most com
relay log
'/var/run/mysqld/mysqld-relay-bin.01' (relay_log_pos 4)
100817 6:42:11 [ERROR] Could not find target log during relay log initialization
100817 6:42:11 [ERROR] Failed to initialize the master info structure
100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections.
Vers
The account has full permission on all the databases.
--- On Fri, 20/8/10, Ananda Kumar wrote:
From: Ananda Kumar
Subject: Re: MySQL Server has gone away
To: "jitendra ranjan"
Cc: "Krishna Chandra Prajapati" , "Prabhat Kumar"
, mysql@lists.mysql.com
Date: Fr
ead_cache_size': unsigned value
> 33554432 adjusted to 16384
> 100817 6:42:10 InnoDB: Started; log sequence number 0 44054
> 100817 6:42:11 [Warning] Neither --relay-log nor --relay-log-index were
> used; so replication may break when this MySQL server acts as a slave and
> has hi
y-bin.01' (relay_log_pos 4)
100817 6:42:11 [ERROR] Could not find target log during relay log initialization
100817 6:42:11 [ERROR] Failed to initialize the master info structure
100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/va
there is high chance of corruption of any data files, but it will clear only
after looking of your error file (generated by mysql) can you post the 50
last lines of your mysql error file.
On Thu, Aug 19, 2010 at 4:35 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Jitendra,
>
Hi Jitendra,
Check your error log file. Some thing might have gone wrong.
Krishna
On Wed, Aug 18, 2010 at 9:41 PM, jitendra ranjan
wrote:
> Hi,
>
> Whenever i run any commnd on mysql it gives message as below then gives the
> result successfully. What is the reason of the below error message :
;
> How do I tell what the TTL is?
>
> I'm not too familiar with perfmon. How do I set it up to watch MySQL
> connections?
>
> Thanks,
> Jesse
>
> - Original Message - From: "Gary Smith"
> To: "Jesse" ;
> Sent: Tuesday, March 24, 20
tions?
Thanks,
Jesse
- Original Message -
From: "Gary Smith"
To: "Jesse" ;
Sent: Tuesday, March 24, 2009 2:55 PM
Subject: Re: MySQL server has gone away...
Netstat -an. How many 3306 entries do you have in there. What's the TTL on
them. Once the pool issu
An update on this issue. It just happened again, and the first error was:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection to
MySQL server during que
Then, after that, I got a BUNCH of "[MySQL][ODBC 3.51
Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away
Go into the my.cnf and increase the connection timeout and see if that
fixes it.
Remember. Connection pooling is about reuse and sometimes when the server
is using less connections its using the same ones over and over again.
Then you get a burst and then connections that haven't been used are
Persistent connections that are dropped when the service is restarted OR
the idle timeout has passed. if this is a connection pool and it hasn't
been used in a long time the server can drop the connection but the pool
will still thinkbits open and pass it out. Thus the server has gone away
mess
this means that your connection has timed out... there's a mysql_ping command
you can use to reconnect.- Original Message -From: Jesse Date: Tuesday,
March 24, 2009 11:44 amSubject: MySQL server has gone away...To:
mysql@lists.mysql.com> We are running MySQL Server version
5.0.67-commun
If I fire a lot of querries, I get an error "mysql server has gone
away/lost
connection with the server" .
I've seen this error for the second reason you've mentioned, wrong
queries. You'll need to show us the query so we can see any possible
issues.
--
MySQL General Mailing List
For lis
Hello everyone,
This problem seems to be solved...
> The problem i'm experiencing is that at certain moments, the connection
> between my perlscripts and the database gets disconnected.
[...]
> I thought the query at that spot would be wrong, but it turns out that
> this alone is not causing th
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> What is happening is that when you start you perl script which
> contains a lot of queries, you are first establishing a connection to
> MySQL, and then you are running some queries, and somewhere in between
> you are losing connection to the server,
Quoting sheeri kritzer ([EMAIL PROTECTED]):
> Do a "show status like 'uptime'" after the script runs. See if the
> server crashed (if so, uptime will be low) -- if the server crashed
> you might get that error.
The server itself does not crash. Uptime shows that, besides the fact
that this would
On 5/5/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> >Can anyone shed any light on this issue?
> This might shed more light into your problem
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But still, the query returns th
Do a "show status like 'uptime'" after the script runs. See if the
server crashed (if so, uptime will be low) -- if the server crashed
you might get that error.
show variables like "%connections" should show you how many
connections you can have per user and total. That shouldn't be the
problem
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> >Can anyone shed any light on this issue?
> This might shed more light into your problem
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But still, the query returns the same data, if I run it alone, or in the
complete sta
On 5/5/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
Hi,
I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual
Opteron250 64 bit machine with 4gb memory.
The problem i'm experiencing is that at certain moments, the connection
between my perlscripts and the database gets disconnecte
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
> Any reason why this happens? Should I be worried?=20
You have an old MySQL version (4.1.8), upgrade to the latest release.
Jørn Dahl-Stamnes wrote:
> I have been using mysql client for some time when I got this er
Mortgage Corp
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 16, 2005 4:39 PM
To: Kraer, Joseph
Cc: mysql@lists.mysql.com
Subject: Re: MySQL server has gone away
"Kraer, Joseph" <[EMAIL PROTECTED]> wrote on 11/16/2005 04
"Kraer, Joseph" <[EMAIL PROTECTED]> wrote on 11/16/2005 04:17:17 PM:
> First let me say that I'm a newbie and that I've seen a few instances of
> this error in the list, but I haven't seen my case.
>
> I'm running WAMP5, v. 1.4.4. I'm trying to restore an Eventum v. 1.4
> backup done with mysqld
Hello.
Check your MySQL error log. Sever could die during the query.
See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
Michael <[EMAIL PROTECTED]> wrote:
> I'm using PHP with MySQL to save files uploaded by users (up to 50MB) to
> a database. I'm having problems getting MySQL to
50 matches
Mail list logo
