awesome-mysql-performance
awesome-mysql-performance copied to clipboard
🔥 A curated list of awesome links related to MySQL / MariaDB / Percona performance tuning
Added 2 articles: - [Configuring innodb_flush_method system variable for InnoDB performance](https://minervadb.xyz/configuring-innodb_flush_method-system-variable-for-innodb-performance/) - [Video] [Where is the MySQL variable - innodb_flush_method?](https://www.youtube.com/watch?v=8VPh_UHhXcI) The link not working: [MySQL (innodb) performance tuning](https://www.ilsistemista.net/index.php/linux-a-unix/26-mysql-performance-tuning.html?start=4) , deleted.
Added 2 articles and 1 video: - [Configuring innodb_flush_method system variable for InnoDB performance](https://minervadb.xyz/configuring-innodb_flush_method-system-variable-for-innodb-performance/) - [innodb_flush_method: Optimizing MySQL](https://linuxblog.io/innodb_flush_method-innodb_flush_log_at_trx_commit-optimizing-mysql/) - [Video] [Where is the MySQL variable - innodb_flush_method?](https://www.youtube.com/watch?v=8VPh_UHhXcI)
Move [How MySQL Opens and Closes Tables](https://dev.mysql.com/doc/refman/5.7/en/table-cache.html) under table_open_cache
Sort MySQL variable by the name it will simplified search
The link to the article does not work. - [MAKING IT BETTER: BASIC MYSQL PERFORMANCE TUNING (MYSQLD)](https://mediatemple.net/community/products/dv/204404044/making-it-better%3A-basic-mysql-performance-tuning-(mysqld))
Added myisam_sort_buffer_size variable and article to it. ### myisam_sort_buffer_size - [Tuning myisam_sort_buffer_size](https://releem.com/docs/mysql-performance-tuning/myisam_sort_buffer_size)
Added thread_handling variable and article to it. ### thread_handling - [Tuning thread_handling](https://releem.com/docs/mysql-performance-tuning/thread_handling)