Awesome-MySQL-performance
🔥 A curated list of awesome links related to MySQL / MariaDB / Percona configuration tuning for improved performance.
Common MySQL Tuning articles
MySQL/MariaDB Variables tuning
aria_pagecache_buffer_size
innodb_buffer_pool_chunk_size
innodb_buffer_pool_instances
innodb_buffer_pool_size
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
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.