MySQL Database Slowness in Windows 10

If you’re experiencing slowness of MySQL 8.0 on Windows 10 especially for Innodb Engine, Adjust the values shown below on your MySQL Configuration file:

#innodb_buffer_pool_size=8M
innodb_buffer_pool_size=2G

#innodb_log_file_size=48M
innodb_log_file_size=500M

#innodb_thread_concurrency=9
innodb_thread_concurrency=2

#innodb_buffer_pool_instances=8
innodb_buffer_pool_instances=2

Then, go to services and restart MySQL.  Your queries should now load very fast.

 

 

Ads by Google

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.