mysql_tuning.md

List mysql tuning information

document

• Best practices for configuring parameters for Amazon RDS for MySQL, part 1: Parameters related to performance
• MySQL 5.7 Performance Tuning After Installation

有關 AWS RDS 的 monitor

• Overview of Monitoring Amazon RDS 這篇很重要，要來看看

有關 RDS parameter groups 的調整

• static parameter，要 reboot 才會生效
• dynamic parameter，修改後就會生效
• Dynamic parameters, 可以有 session level or global scope
• How do I modify the values of an Amazon RDS DB parameter group?
• 顯示目前的 variable

$ show variables like "max_connections"; # 預設為 session level
$ show session variables like 'max_connections';
$ show global variables like 'max_connections';

目前有調整的參數

• parameter groups 調整
  • interactive_timeout: 300 (s)
  • wait_timeout: 300 (s)
  • max_connections，由 64 改為 96，(instance: t3.micro, 1G RAM)
    • AWS 計算方式: {DBInstanceClassMemory/12582880}
  • slow_query_log: 1 (以便能開啟 slow log)
• reference
  • What is the default mysql wait_timeout and interactive_timeout
  • Changing MySQL wait_timeout variable

advance

• MySQL Performance Cheat Sheet