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].


🐧 Please support my work on Patreon or with a donation.
🐧 Get the latest tutorials on Linux, Open Source & DevOps via:
CategoryList of Unix and Linux commands
File Managementcat
FirewallAlpine Awall CentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Network Utilitiesdig host ip nmap
OpenVPNCentOS 7 CentOS 8 Debian 10 Debian 8/9 Ubuntu 18.04 Ubuntu 20.04
Package Managerapk apt
Processes Managementbg chroot cron disown fg jobs killall kill pidof pstree pwdx time
Searchinggrep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNAlpine CentOS 8 Debian 10 Firewall Ubuntu 20.04
3 comments… add one
  • Mike Sep 7, 2012 @ 15:44

    Nice tools thank you.

  • Jose de Goes Aug 11, 2012 @ 15:03

    Exellent !!!!! Thank you !!!!

  • Den Nov 4, 2008 @ 12:41

    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!!!

Leave a Reply

Your email address will not be published. Required fields are marked *

Use HTML <pre>...</pre> for code samples. Problem posting comment? Email me @ webmaster@cyberciti.biz