mysql performance config tuning

  1. In this sample server has 128 GB RAM
  2. innodb_buffer_pool_size – recommended  80% ram size
innodb_buffer_pool_size = 80G
max_connections = 10001
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 1M
innodb_flush_log_at_trx_commit = 1
table_cache = 1024
thread_cache = 16
query_cache_size = 0
thread_concurrency = 24
query_cache_type = 0