Essential tools for monitoring and administrating MySQL Server
The MySQL distribution provides several tools for database developers and administrators, but they don't always work everywhere. Fortunately, the worldwide MySQL community has produced plenty of useful tools. Baron Schwartz surveys the possibilities and offers suggestions for what you should use.
At some point I have used most of these tools:
Tools to Monitor Queries and Transactions
=> mytop - Old but still good tool
=> innotop - MySQL and InnoDB monitor
=> phpmytop and ajaxmytop - Web-based monitoring tools (very good if you don't have shell access).
Tools to Monitor a MySQL Server
=> mysqlreport - Easy to understand MySQL status report perl script
See list of Open Tools for MySQL Administrators list [oreillynet.com].
You may also be interested in other helpful articles:
- How do I monitor what my MySQL server is doing?
- Download Google MySQL patches
- Recover MySQL root password
- Linux/UNIX: sharing a CUPS printer queue
- MySQL Proxy Load balancing and Failover Tutorial
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
Recent Comments
Today ~ 15 Comments
Yesterday ~ 15 Comments
Yesterday ~ 4 Comments
Yesterday ~ 6 Comments
Yesterday ~ 21 Comments