Menu Close

MySQL Windows Memory

Updated On March 19, 2019
You are here:
< Back



How to reduce the MySQL Service Memory Footprint to a minimal size:
– Locate the C:\ProgramData\MySQL80\my.ini file.
– Add performance_schema=0 to [mysql] section.
– Add table_definition_cache=400 to [mysqld] section.

I’m saving this here because I already waste way to much time searching for this settings every damn time I need to reinstall MySQL on Windows with an AWS server…

Credits and original info :
Troubleshooting High Memory Usage with MySQL on Windows – http://www.chriscalender.com/tag/pfs_table_share-row_size/



Comments are welcome.

%d bloggers like this: