MySQL Tuning

query_cache_limit       = 128K
query_cache_size        = 64M
query_cache_type        = 1
query_cache_min_res_unit= 512
sql_mode                = NO_ENGINE_SUBSTITUTION
performance-schema      = 0

innodb_log_file_size          = 256M
innodb_buffer_pool_size       = 4G
innodb_log_buffer_size        = 512M
innodb_file_per_table         = 1
innodb_buffer_pool_instances  = 8
innodb_thread_concurrency     = 0
innodb_flush_log_at_trx_commit= 2