Mike's Database Place

MySQL Diagnostics & Tuning

Databases

MySQL

SQL Tuning

Linux Diagnostics & Tuning

MySQL Process Management

MySQL Optimizer

MySQL Status Counters

MySQL Waits

MySQL Errors

InnoDB Monitor

MySQL Slow Queries

MySQL Slow Query Log

Tools

MySQL Enterprise Monitor

MySQL Workbench

Percona Monitoring and Management

innotop

mysqltuner

mtop

mytop

ottertune

Amazon RDS/Aurora only (2022)

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

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

Page updated

Google Sites

Report abuse