Menu Close
How Can We Help?
You are here:
Print

Reduce MySQL Windows Memory

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.

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.