MySQL Forums
Forum List  »  Performance

Re: Virtual Memory MySQL Server
Posted by: Rick James
Date: July 09, 2013 08:04AM

I know of MySQL servers that have been up for _years_ without blowing out memory.

(Simplified view) MySQL allocates the caches when it starts up -- innodb_buffer_pool is, I believe, allocated all at once; key_buffer grows to the indicated size as needed. Other allocations come and go as needed.

Did you modify any of the settings in my.cnf? If so, which ones did you increase significantly? Or use 'G' instead of 'M'?

If you would like, paste in SHOW VARIABLES and SHOW GLOBAL STATUS. I will look for any naughty settings and provide other advice.

Options: ReplyQuote


Subject
Views
Written By
Posted
6429
July 05, 2013 08:11AM
2775
July 06, 2013 11:14AM
2499
July 08, 2013 04:54AM
Re: Virtual Memory MySQL Server
2165
July 09, 2013 08:04AM


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.