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.

ADVERTISEMENTS

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

🐧 Get the latest tutorials on SysAdmin, Linux/Unix, Open Source & DevOps topics via:
CategoryList of Unix and Linux commands
File Managementcat
FirewallCentOS 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 VPNCentOS 8 Debian 10 Firewall Ubuntu 20.04

ADVERTISEMENTS
3 comments… add one
  • 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!!!

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

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

  • Mike Sep 7, 2012 @ 15:44

    Nice tools thank you.

Leave a Reply

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

Use HTML <pre>...</pre>, <code>...</code> and <kbd>...</kbd> for code samples.