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.

 

 

PhpMyadmin Error – Incorrect format parameter

If you’re experiencing the error, “Incorrect format parameter” in your PhpMyAdmin when importing database, make the following changes in your php.ini file:

$ sudo nano /etc/php/7.4/apache2/php.ini

upload_max_filesize = 64M

post_max_size = 64M

max_execution_time = 6000

Then restart the web server:

$ sudo systemctl restart apache2