I have had good suggestions from Mysqltuner in the past.
https://hevodata.com/learn/mysqltuner/
You should run this tool after the traccar server has been running a few days
It would be interesting to know if this is helpfull. So report back when you have tested it.
Thanks can you share few important ones here for betterment of all….
Also what is the suggest value for maxpoolsize
Run mysql tuner on your server. Then you will see realistic values that you can use.
with 10000+ device what is the suggested value for database.maxpoolsize in config with mysql 8 db