MySQL Diagnostics & Tuning
Tools
Tools
Performance
Performance
Reasons why MySQL might have poor performance...
Reasons why MySQL might have poor performance...
Resource Bottlenecks (I/O, Memory, CPU)
Sub-optimal Server Settings
Other programs (e.g. Backup, Virus-Checkers etc)
Faulty hardware
Bad queries / database design
Table Corruption / Fragmentation
OS / MySQL Bugs
Storage issues (full filesystems, incorrect permissions)
Bibliography
Bibliography
https://haydenjames.io/mysql-performance-tuning-tips-scripts-tools/https://www.mysql.com/why-mysql/benchmarks/https://www.mysql.com/why-mysql/performance/index.htmlhttps://dev.mysql.com/doc/refman/8.0/en/crashing.htmlhttps://ottertune.com/https://bobcares.com/blog/mysql-performance-issues/
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
https://serverfault.com/questions/101047/how-can-i-tell-how-many-queries-per-second-mysql-is-handlinghttps://stackoverflow.com/questions/8987679/how-to-retrieve-the-current-version-of-a-mysql-database-management-system-dbms
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
https://serverfault.com/questions/101047/how-can-i-tell-how-many-queries-per-second-mysql-is-handlinghttps://stackoverflow.com/questions/8987679/how-to-retrieve-the-current-version-of-a-mysql-database-management-system-dbms