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].
🐧 Get the latest tutorials on Linux, Open Source & DevOps via:
- RSS feed or Weekly email newsletter
- Share on Twitter • Facebook • 3 comments... add one ↓
Category | List of Unix and Linux commands |
---|---|
File Management | cat |
Firewall | Alpine Awall • CentOS 8 • OpenSUSE • RHEL 8 • Ubuntu 16.04 • Ubuntu 18.04 • Ubuntu 20.04 |
Network Utilities | dig • host • ip • nmap |
OpenVPN | CentOS 7 • CentOS 8 • Debian 10 • Debian 8/9 • Ubuntu 18.04 • Ubuntu 20.04 |
Package Manager | apk • apt |
Processes Management | bg • chroot • cron • disown • fg • jobs • killall • kill • pidof • pstree • pwdx • time |
Searching | grep • whereis • which |
User Information | groups • id • lastcomm • last • lid/libuser-lid • logname • members • users • whoami • who • w |
WireGuard VPN | Alpine • CentOS 8 • Debian 10 • Firewall • Ubuntu 20.04 |
Nice tools thank you.
Exellent !!!!! Thank you !!!!
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!!!