Berikut ini tips singkat untuk tuning MySQL 5.7
nnodb_file_per_table=ON
innodb_stats_on_metadata = OFF
innodb_buffer_pool_instances = 8 (or 1 if innodb_buffer_pool_size < 1GB)
query_cache_type = 0; query_cache_size = 0; (disabling mutex)Sumber: https://www.percona.com/blog/2016/10/12/mysql-5-7-performance-tuning-immediately-after-installation/