Home > Monitor MySQL Database Users with VividCortex

Monitor MySQL Database Users with VividCortex

VividCortex now supports per-user metrics in Top Queries, so you can monitor MySQL database user activity in detail. By changing the Rank menu from Queries to Users you can now see a breakdown of user activity in the familiar format, all with 1 second resolution. Here “user” means the database user account that the application uses to access the database.

Database_Users

Computed columns also work as usual so you can quickly figure out which users consume more resources such as CPU or IO in addition to the standard metrics (count, time, latency, error rate, etc). Additional information such as per-host user activity and scatterplots of additional data can be found after clicking to drill into the query.

We detect the user by sniffing from the TCP traffic, as usual. There are two places we can capture it: during connection, or from a COM_CHANGE_USER packet. Sometimes we can’t detect a user for a connection in which case we show that as unknown_user

If you’d like a demo of VividCortex, contact us – or simply sign up for a free trial, no credit card required.

SolarWinds
We’re Geekbuilt.® Developed by network and systems engineers who know what it takes to manage today's dynamic IT environments, SolarWinds has a deep connection to…
Read more

Tweets

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Read about sustainability in IT and data centers in this @DigiconAsia article by SolarWinds Head Geek… t.co/1WMQ9t69c3

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Learn about important factors in improving IT security for hospitals in this article featuring SolarWinds Head Geek… t.co/4761faWe0O

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

We are excited to announce our next SolarWinds Day virtual event, Feb 15, to celebrate our customers and help busin… t.co/omQp7majSv