High Memory Usage in Mysql 5.6 for Windows

Mar12

Written by:David Aldridge
3/12/2015 7:27 PM 

Whilst trying to run down memory issues on a windows server I noticed that the Mysql instance was using a lot of memory (~500m) even though it was set for very modest buffer sizes.

Turns out that performance schema is enabled by default on mysql 5.6.

To get your memory back to where you expect it to be set the following in my.ini:

performance_schema=0

And then restart mysql.

TrackbackPrint
Location: BlogsDavids Support Blog
Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment  Cancel 
You must be logged in and have permission to create or edit a blog.