The Sysadmin’s Daily Grind: Mtop
HEALTH CHECK
It would be great if every MySQL database enjoyed perfect health 24 by 7, but unfortunately, trouble sometimes strikes. A logfile isn’t much help if you are investigating why a database is flooded with requests. Mtop to the rescue.
We looked at ApacheTop in this column not too long ago. ApacheTop is a tool that tells you what your web server is doing right now, pointing out potential bottlenecks. In this month’s column, we will be looking at another member of the top family: Mtop, the realtime monitor for MySQL [1]. The Mtop tarball weighs in at a mere 48 kbytes. It requires a few Perl modules: Curses, DBI, DBD::mysql, and Net::Domain – but you will probably have most of these installed anyway, and CPAN will fill any gaps in next to no time. After satisfying the dependencies, enter perl Makefile.PL, make, and make install in /usr/local/bin/ to complete the Mtop build. The next step is to allow Mtop access to your MySQL process information, as – in contrast to Apachetop – Mtop does not simply parse the server logfiles, but requires direct access. I decided to set up a user with extremely restricted privileges in MySQL and did not assign a password. The following SQL prompt should do the trick for version 4.0.2 or newer of MySQL: grant super, reload, U process on *.* to mysqltop; grant super, reload, U process on *.* to mysqltop@localhost; flush privileges;
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
US / Canada
UK / Australia
News
-
Linux Kernel 6.0 Officially Released
Although it will be some time before most Linux distributions ship with the latest kernel, the next major release is now available.
-
ExTiX 22.9 Released with Support for Installing Android Apps
The developers of the ExTiX Linux Distribution have released a new version that includes added support to make installing and using Android apps on the desktop a breeze.
-
System76 Skips Pop!_OS 22.10 to Focus on COSMIC Desktop
In a move that is sure to raise some eyebrows, System76 has chosen to concentrate on COSMIC Desktop instead of staying in step with Ubuntu releases.
-
New Look for System76 Thelio
System76 has given their already stellar Thelio desktop computer a redesign by way of the chassis accent panel.
-
Ubuntu Software Store Rumored to Replace Gnome Software
An alternative to GNOME Software has been written, using Flutter, and it’s making enough noise that Canonical is rumored to be considering using it as the default.
-
A New Arch-Based Linux Distribution Has Arrived
Crystal Linux is a new distribution with the goal of bringing the power of Arch Linux to the masses.
-
Fedora 37 Beta Available
The Fedora development team announced the beta for version 37 of the open-source operating system would be released on time on September 13, 2022.
-
Salix 15.0 Offers Updates and a Modernized Look
Salix is a Slackware-based Linux distribution with a new look and a goal of being fast, user-friendly, and highly stable.
-
Ubuntu 20.04.5 LTS Release Now Available
The latest point release of the Ubuntu 20.04 LTS distribution is now available and sports kernel 5.15.
-
MX Linux 21.2 Offers Improvements and Bug Fixes
MX Linux 21.2, aka “Wildflower,” is now officially available and is the second refresh of the MX-21 release.