Improve My-SQL performance

Problem

If you have a slow server or problems to generate reports you should take a look at the MySQL configuration.

Solution

Backup and then make the following changes to my.ini

For MySQL 8.0 you typically find this file under C:\ProgramData\MySQL\MySQL Server 8.0
Note that ProgramData is a hidden folder!
For MySQL 5.5 you typically find my-ini under C:\Program Files\MySQL\MySQL Server 5.5

innodb_buffer_pool_size=2G
innodb_buffer_pool_instances=1

Set innodb_buffer_pool_size to 2G. If you have less than 4 GB memory on your server dedicated for GpsGate usage, set it to half the memory you have.

After you have done the changes, restart MySQL.

1. Open Services under Administrative Tools in the Windows Control Panel.
2. Right-click on Franson NMEA Service and select Stop
3. Right-click on MySQL and select Restart.
4. Right-click on Franson NMEA Service and select Start

Troubleshooting

MySQL not starting

If MySQL does not start after editing my.ini, try the solution proposed in this article.