awesome-mysql-performance
Performance guide
A curated collection of resources and tips on MySQL performance tuning for improved server efficiency and reliability
🔥 A curated list of awesome links related to MySQL / MariaDB / Percona performance tuning
501 stars
25 watching
41 forks
last commit: 11 months ago
Linked from 1 awesome list
awesome-listawesome-listsconfigconfigurationdatabase-managementdatabasesmariadbmariadb-databasemariadb-mysqlmariadb-servermysqlmysql-databasemysql-serverperconapercona-mysqlpercona-serverperformancetuningtuning-parameters
Awesome-MySQL-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 | |||
Awesome-MySQL-performance / Books | |||
| High Performance MySQL | |||
| Indexing beyound the basics | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / aria_pagecache_buffer_size | |||
| Finding an optimal size for Aria Pagecache | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / innodb_buffer_pool_chunk_size | |||
| InnoDB Buffer Pool Resizing: Chunk Change | |||
| Tuning innodb_buffer_pool_chunk_size | |||
| MySQL InnoDB buffer pool configuration | Role of InnoDB buffer pool chunk size and Instances | [Video] | ||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / innodb_buffer_pool_instances | |||
| Tuning innodb_buffer_pool_instances | |||
| How Many innodb_buffer_pool_instances Do You Need in MySQL 8? | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / 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 | ||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / 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? | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / innodb_flush_method | |||
| Tuning innodb_flush_method | |||
| MySQL (innodb) performance tuning | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / innodb_log_file_size | |||
| What is a big innodb_log_file_size? | |||
| Tuning innodb_log_file_size | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / innodb_read_io_threads | |||
| Tuning innodb_read_io_threads | |||
| How do you tune innodb_read_io_threads? | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / innodb_write_io_threads | |||
| Tuning innodb_write_io_threads | |||
| How do you tune innodb_read_io_threads? | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / join_buffer_size | |||
| Tuning join_buffer_size | |||
| Tuning MySQL my.cnf? Avoid this common pitfall! | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / key_buffer_size | |||
| Tuning key_buffer_size | |||
| Optimizing key_buffer_size | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / max_allowed_packet | |||
| Tuning max_allowed_packet | |||
| How to change max_allowed_packet size | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / max_connections | |||
| Tuning max_connections | |||
| Max Connection Tuning with MariaDB Enterprise Server | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / max_heap_table_size | |||
| Tuning max_heap_table_size | |||
| Rule of thumb for tmp_table_size and max_heap_table_size MySQL properties | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / read_rnd_buffer_size | |||
| Tuning read_rnd_buffer_size | |||
| MySQL: What read_buffer_size Value is Optimal? | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / sort_buffer_size | |||
| Tuning sort_buffer_size | |||
| MySQL sort_buffer_size | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / thread_cache_size | |||
| Tuning thread_cache_size | |||
| MySQL Optimization Tip – Thread Cache Size | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / thread_pool_size | |||
| Tuning thread_pool_size | |||
| Thread Pool Tuning | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / tmp_table_size | |||
| Tuning tmp_table_size | |||
| MySQL tmp_table_size optimization settings for how much appropriate _mysql | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / table_open_cache | |||
| Tuning table_open_cache | |||
| Optimize table_open_cache | |||
Awesome-MySQL-performance / MySQL/MariaDB Variables tuning / bulk_insert_buffer_size | |||
| Tuning bulk_insert_buffer_size | |||
| How to set bulk_insert_buffer_size in mysql? | |||
Awesome-MySQL-performance / Talks | |||
| MySQL Performance Tuning: Part 1. Configuration (Covers MySQL 5.7) | |||
Awesome-MySQL-performance / Configuration | |||
| MySQLTuner-perl | 9,011 | 12 months ago | 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 | ||
vettabase/awesome-mariadb
thibaultduponchelle/perlres