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!

Fix

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