Increase performance on MySQL with a SSD and modifying your my.ini or my.cnf file

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.

About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Technology and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s