You probably know about VividCortex’s Top Queries view, which shows MySQL query activity on one or many systems in industry-leading detail. But did you know you can also see what’s happening on the operating system? Not only do we capture fine-grained metrics about CPU, network, and so on, but we capture per-process metrics.
This is pretty life-changing when you’re trying to figure out what’s happening in your database. How many times have you gotten tunnel vision trying to find the cause of a performance problem by looking at MySQL log files or metrics, and later discovered that the problem was due to a rogue cron job or other process?
The Top Processes view also serves as an easy way to demonstrate how lightweight the VividCortex agents are. The screenshot above was taken over a period of 12 hours on our busiest MySQL server. Obviously, MySQL is the 800-lb gorilla on this system. The second process is our query agent, which comes in at just under 1% of total CPU (system and user CPU together; the metrics are percentages of a single CPU, but this is a multi-CPU system).
You can also see the Share button near the top right. Clicking this button will generate a share link you can paste into email, chat or whatnot. (There’s also a Hubot script).
If you’re not seeing operating system activity in per-process detail at 1-second resolution, you’re not getting the whole picture! Sign up for a free trial, no credit card required. You’ll be up and running in less than a minute.