Hello Shafi,
On 8/25/2011 02:02, Shafi AHMED wrote:
Thank you everyone who have responded back...
The issue is fixed now after increasing the max connections param
I disagree. I believe you only reduced the symptom of the problem. The
real problem was you had too many open connections. The
Great, thank you sir!
Appreciate your comprehensive reply
Best Rgs,
Shafi AHMED
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Thursday, August 25, 2011 1:30 PM
To: Shafi AHMED
Cc: mysql@lists.mysql.com
Subject: Re: Reg...My Hung MYSQL instance
- Original Message -
> From: "Shafi AHMED"
>
> Thank you everyone who have responded back...
> The issue is fixed now after increasing the max connections param
Glad to hear that, but it seems unlikely, to me.
Certain things, like the query cache, index cache, etc. are allocated once, a
; Andrew Moore
Subject: Re: Reg...My Hung MYSQL instance
- Original Message -
> From: "Suresh Kuna"
>
> Can you paste your error log and configuration file with the total
> memory you have on the server.
Hey, someone posting something actually useful. You must be n
- Original Message -
> From: "Suresh Kuna"
>
> Can you paste your error log and configuration file with the total
> memory you have on the server.
Hey, someone posting something actually useful. You must be new here :-D
Ahmed, do you have more connections than you used to? Some of the m
Hello Shafi,
Can you paste your error log and configuration file with the total memory
you have on the server.
On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore wrote:
> It will only do what you let it. If your server ui consuming too much
> memory
> it because you've let it.
> On Aug 23, 2011 9:22
Kill the Mysql process as of now & set the proper buffer parameters as per
the usage. start the mysql instance.
On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore wrote:
> It will only do what you let it. If your server ui consuming too much
> memory
> it because you've let it.
> On Aug 23, 2011 9:
It will only do what you let it. If your server ui consuming too much memory
it because you've let it.
On Aug 23, 2011 9:22 AM, "Shafi AHMED" wrote:
> Dear, Today suddenly my database went into hung state due to Out of Memory
> [ Killed process 1330 (mysqld) ].
>
> Please advise me folks.This happ