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
• Aria Pagecache Sizing: Balancing Performance and Resources
• [Video] Understanding the Page Cache in MariaDB: Is it Shared Across Database Connections?

bulk_insert_buffer_size

• Tuning bulk_insert_buffer_size
• How to set bulk_insert_buffer_size in mysql?

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_change_buffering

• Tuning innodb_change_buffering
• MySQL Change Buffer – What When and FAQ

innodb_file_per_table

• Tuning innodb_file_per_table
• How to reclaim space in InnoDB when innodb_file_per_table is ON

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_buffer_size

• Tuning innodb_log_buffer_size
• innodb_log_buffer_size: Configure InnoDB Log Buffer Size

innodb_log_file_size

• What is a big innodb_log_file_size?
• Tuning innodb_log_file_size

innodb_max_dirty_pages_pct

• Tuning innodb_max_dirty_pages_pct
• What the Flush? - Hack MySQL

innodb_purge_threads

• Tuning innodb_purge_threads
• InnoDB Purge

innodb_page_cleaners

• Tuning innodb_page_cleaners
• Fun with innodb_page_cleaners

innodb_read_io_threads

• Tuning innodb_read_io_threads
• How do you tune innodb_read_io_threads?

innodb_thread_concurrency

• Tuning innodb_thread_concurrency
• Optimizing MySQL Throughput: Fine-Tuning InnoDB Thread Concurrency

innodb_redo_log_capacity

• Tuning innodb_redo_log_capacity
• InnoDB Redo Log

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

query_cache_type

• Tuning query_cache_type

optimizer_search_depth

• Tuning optimizer_search_depth

query_cache_size

• Tuning query_cache_size

query_cache_limit

• Tuning query_cache_limit

query_cache_min_res_unit

• Tuning query_cache_min_res_unit
• What is the best setting for query_cache_min_res_unit

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

table_definition_cache

• Tuning table_definition_cache
• MariaDB/MySQL – Table Open Cache & Table Definition Cache

thread_cache_size

• Tuning thread_cache_size
• MySQL Optimization Tip – Thread Cache Size

thread_pool_size

• Tuning thread_pool_size
• Thread Pool Tuning

thread_stack

• Tuning thread_stack
• How thread_stack variable relates to amount of UNION in a query?

tmp_table_size

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

transaction_prealloc_size

• Tuning transaction_prealloc_size

table_open_cache

• Tuning table_open_cache
• Optimize table_open_cache

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 - Releem is a database advisor for MySQL, MariaDB & PostgreSQL that provides automatic metrics analysis, actionable insights, and safe automation.