MySQL Forums
Forum List  »  Performance

Re: out of memory error
Posted by: Rick James
Date: April 09, 2013 09:23AM

> 32bit mysql
> mysqld is using about 4G of memory

Sounds like you are out of memory!

So, why is it using all of 4G?...

MySQL tends to release memory that it is not needed.

With these, there may be new clues.
SHOW GLOBAL STATUS;
SHOW VARIABLES;

Start by decreasing max_connections.

> I"m running innodb
So, you may as well decrease key_buffer_size to 20M

> http://mysql.rjweb.org/doc.php/memory

Options: ReplyQuote


Subject
Views
Written By
Posted
14419
April 08, 2013 12:26PM
Re: out of memory error
3748
April 09, 2013 09:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.