If you want to make MySQL use less memory at the expense of some performance you can make one quick fix that can drastically cut the memory usage.

In your my.cnf file:


# my.cnf
performance_schema = 0

Then restart the mysql service. That should cut down the usage.


Related External Links: