Link to home
Start Free TrialLog in
Avatar of Paul Konstanski
Paul KonstanskiFlag for United States of America

asked on

MySQL Memory Keeps Increasing

The MySQL Memory keeps getting into a cycle. It steadily increases and hits a max and then all of a sudden drops way back down only to repeat the cycle again.  See the attached image showing 7 days of this cycle.

What is the best practice to find out what is causing this problem?
MemoryUsage.png
SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Incidentally, Tomas's suggestions are good general advice for ensuring you're running queries efficiently, but I get the feeling the problem has less to do with optimizing queries and more with either a really bad single query that shouldn't ever be run, bad code, or a bad configuration.

If you want additional advice on tuning and optimization of queries and the server config, I have an article on it here:
https://www.experts-exchange.com/articles/1250/3-Ways-to-Speed-Up-MySQL.html
Avatar of Paul Konstanski

ASKER

I have been some tuning and identified a couple of key issues that have really helped. The biggest thing so far is setting up some indexes on key tables.

Thanks for the insights.