Bug #43393 mysql server consumes all memory and dies
Submitted: 4 Mar 2009 21:05 Modified: 5 Apr 2009 8:17
Reporter: Daniel Salinas Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Logging Severity:S1 (Critical)
Version:5.0.51 mysqlab rpms OS:Linux (Rhel 5.2)
Assigned to: CPU Architecture:Any

[4 Mar 2009 21:05] Daniel Salinas 
Description:
Mysql server runs for about a day, then memory utilization goes from an average of 30% to 99.8% and the following trace is thrown:

How to repeat:
Not really sure, this is a multi-tenant hosting server.
[5 Mar 2009 8:17] Valeriy Kravchuk 
Please, try to get complete text of that HUGE query I see in your stack trace:

(SELECT  u.USER_ID, u.USERNAME, u.CREATE_ON, u.LAST_LOGIN, u.STATUS, u.TYPE, (select count(ut.USER_TRACKING_ID) from USER___TRACKING ut where 

...

and send EXPLAIN results for it. Send your my.cnf also and the results of:

uname -a
free

Linux commands.
[5 Apr 2009 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".