How to Monitor MySQL’s performance

MySQL AB :: How to Monitor MySQL’s performance

…how you can monitor the database performance of your MySQL installation. Monitoring is always an iterative and continuous process. You need to learn what patterns are OK for your database and what are the signs of slight problems or even dangerous situations.Below are the main items you can use to monitor your system:

mysqladmin extended (absolute values)

mysqladmin extended -i10 -r (relative values)

mysqladmin processlist

mysql -e “show innodb status”

OS data. vmstat/iostat

MySQL error log

InnoDB tablespace info.

There are 0 comments to this post.