I came across Neelakanth Nadgir’s blog while doing some research, and his performance analysis tools (cmdtruss and inniostat) are pretty sweet. If you are looking to learn more about MySQL performance, you should take a look at High Performance MySQL and the Sun engineering blogs. There is some awesome stuff out there!
MySQL maintains numerous operational metrics (e.g., connections, questions, etc), which can be accessed by running ’show status’ or one of it’s variants from the mysql client. The mysqlreport Perl script can be used to summarize this data into a nicely formatted report with several useful performance metrics:
$ mysqlreport –user privuser –password password -all
MySQL 5.0.24 [...]
MyQSL comes with several utilities to configure and manage a database platform. One useful utility is the mysql_secure_installation script, which limits access to the ‘root’ account, removes the test database, and removes anonymous accounts. To use the mysql_secure_installation script, you can run it with the path to your my.cnf:
$ mysql_secure_installation –defaults =my.cnf
NOTE: RUNNING ALL PARTS [...]
