Awesome-MySQL-performance

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

Common MySQL Tuning articles

• Ten MySQL performance tuning settings after installation
• MySQL Server and SQL Performance Tuning
• MySQL Performance Cheat Sheet
• Performance Tuning and Configurations for your MySQL Server
• MAKING IT BETTER: BASIC MYSQL PERFORMANCE TUNING (MYSQLD)
• InnoDB Performance Optimization Basics
• MySQL 101: Tuning MySQL After Upgrading Memory
• How MySQL Opens and Closes Tables

Books

• High Performance MySQL
• Indexing beyound the basics

MySQL/MariaDB Variables tuning

aria_pagecache_buffer_size

• Finding an optimal size for Aria Pagecache

innodb_buffer_pool_chunk_size

• InnoDB Buffer Pool Resizing: Chunk Change
• Tuning innodb_buffer_pool_chunk_size
• [Video] MySQL InnoDB buffer pool configuration | Role of InnoDB buffer pool chunk size and Instances

innodb_buffer_pool_instances

• Tuning innodb_buffer_pool_instances
• How Many innodb_buffer_pool_instances Do You Need in MySQL 8?

innodb_buffer_pool_size

• Tuning innodb_buffer_pool_size
• Innodb_buffer_pool_size – Is 80% of RAM the right amount?
• Is InnoDB Buffer Pool big enough? and Can we shrink InnoDB Buffer Pool?

innodb_flush_log_at_trx_commit

• Tuning innodb_flush_log_at_trx_commit
• Is it safe to use innodb_flush_log_at_trx_commit = 2?

innodb_flush_method

• Tuning innodb_flush_method
• MySQL (innodb) performance tuning

innodb_log_file_size

• What is a big innodb_log_file_size?
• Tuning innodb_log_file_size

innodb_read_io_threads

• Tuning innodb_read_io_threads
• How do you tune innodb_read_io_threads?

innodb_write_io_threads

• Tuning innodb_write_io_threads
• How do you tune innodb_read_io_threads?

join_buffer_size

• Tuning join_buffer_size
• Tuning MySQL my.cnf? Avoid this common pitfall!

key_buffer_size

• Tuning key_buffer_size
• Optimizing key_buffer_size

max_allowed_packet

• Tuning max_allowed_packet
• How to change max_allowed_packet size

max_connections

• Tuning max_connections
• Max Connection Tuning with MariaDB Enterprise Server

max_heap_table_size

• Tuning max_heap_table_size
• Rule of thumb for tmp_table_size and max_heap_table_size MySQL properties

read_rnd_buffer_size

• Tuning read_rnd_buffer_size
• MySQL: What read_buffer_size Value is Optimal?

sort_buffer_size

• Tuning sort_buffer_size
• MySQL sort_buffer_size

thread_cache_size

• Tuning thread_cache_size
• MySQL Optimization Tip – Thread Cache Size

thread_pool_size

• Tuning thread_pool_size
• Thread Pool Tuning

tmp_table_size

• Tuning tmp_table_size
• MySQL tmp_table_size optimization settings for how much appropriate _mysql

table_open_cache

• Tuning table_open_cache
• Optimize table_open_cache

bulk_insert_buffer_size

• Tuning bulk_insert_buffer_size
• How to set bulk_insert_buffer_size in mysql?

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.