Always backup your data along with the my.ini or my.cnf file
To add to the performance of a MySQL database, there are many tweaks for the my.ini or my.cnf file. Two things that you can do is first add a SSD as a secondary drive and then move your temp file to the SSD by adding the following line just below the [mysqld] section –
You must change the letter H to the drive letter of your new SSD drive. If you have a linux based computer, set the appropriate permissions.
Restart mysql or restart the computer.