/mysql_best_configuration

MySQL Optimal Configuration Template

Primary LanguageShell

MySQL Optimal Configuration File

This configration file opts for MySQL 5.6 and 5.7. If you have any problem, dont hesitate to concact me. Let us make an optimal MySQL configuration file template for product enviroment.

I assume the MySQL Server as followings. You should tune the variables according to your server.

  • 32 CPU core
  • 256G Memory
  • SSD storage with 20000 IOPS in 16K page size