awesome-mysql-performance

🔥 A curated list of awesome links related to MySQL / MariaDB / Percona configuration tuning to improve performance

Articles

• Ten MySQL performance tuning settings after installation
• MySQL Server and SQL Performance Tuning
• 101 Tips to MySQL Tuning and Optimization
• MySQL Performance Cheat Sheet
• Performance Tuning and Configurations for your MySQL Server
• MAKING IT BETTER: BASIC MYSQL PERFORMANCE TUNING (MYSQLD)
• MySQL 101: Tuning MySQL After Upgrading Memory
• Is InnoDB Buffer Pool big enough?
• Optimizing table_open_cache
• InnoDB Performance Optimization Basics
• InnoDB Buffer Pool Resizing: Chunk Change
• What is a big innodb_log_file_size?
• How MySQL Opens and Closes Tables
• How Quora Shards MySQL to Handle 13+ Terabytes

Talks

• MySQL Performance Tuning: Part 1. Configuration (Covers MySQL 5.7)

Configuration

• MySQLTuner-perl - A script that allows you to review a MySQL installation quickly and make recommendations to increase performance and stability.
• Releem - MySQL Performance Tuning as a Service. Releem helps you to automatically monitor MySQL metrics, and tune MySQL configuration to improve performance and reduce costs of server resources.