Re: Unexpected RAM usage on MySQL
Posted by: Peter Brawley
Date: March 16, 2019 11:18AM

> InnoDB 4682006528 3599335424 8281341952

So all InnoDB ops in RAN needs innodb_buffer_pool_size=8GB, plus somefor growth.

> I guess I'd need to use the slow query log for those, right?


>> 3 Nearly a thousand hrs between InnoDB log rotations is way too lomg

> Isn't that done automatically when needed? I'll lookup how to do it.

Best adjust log size such that it rotates every 30-60 mins,

> didn't try to lower the swappiness,

Right, first get swap use down to zero.

What do the mysql log and syslog say when that db size query crashes the server?

How much RAM is the app using? Other processes?

Options: ReplyQuote

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.