Awesome
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
MySQL/MariaDB Variables tuning
aria_pagecache_buffer_size
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
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
innodb_flush_method
innodb_log_file_size
innodb_read_io_threads
innodb_write_io_threads
join_buffer_size
key_buffer_size
max_allowed_packet
max_connections
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
sort_buffer_size
thread_cache_size
thread_pool_size
tmp_table_size
table_open_cache
bulk_insert_buffer_size
Talks
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.