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].
Featured Articles:
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- 20 Linux Server Hardening Security Tips
- Linux: 20 Iptables Examples For New SysAdmins
- My 10 UNIX Command Line Mistakes
- 25 PHP Security Best Practices For Sys Admins
- The Novice Guide To Buying A Linux Laptop
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- Top 20 OpenSSH Server Best Security Practices
- Top 10 Open Source Web-Based Project Management Software
Facebook it - Tweet it - Print it -
We're here to help you make the most of sysadmin work. So, subscribe!
{ 1 comment… read it below or add one }
hello i am Passionate to monitor my server so i was looking for good mysql monitoring tool. When on my way i found monyog, an agentless. really awesome. Great looking real-time charts .. just enjoy!!!