Paul Konstanski
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
What is the best practice to find out what is causing this problem?
MemoryUsage.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Thanks for the insights.
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