MYSQL 8 -Performance Optimization
Reading here ? https://www.traccar.org/mysql-optimization/
Thanks, but above parameters are not there. So was just wondering if we change implement above mysql suggestions will it improve traccar performance.
The last three would probably be a very bad idea.
Not sure about the first two. Don't know what they do.
How helpful it is to make below changes in mysql to increase the performance of traccar
max_heap_table_size -- 128MB
tmp_table_size -- 128MB
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
SET AUTOCOMMIT = 0;