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:





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