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

@SteHollyoak We apologize for the inconvenience. Please DM us your contact information, and we'll escalate to the team. Thank you.

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

What lessons can channel businesses learn from 2020 for a more successful year? Exploring new vertical markets will… t.co/XkYGiLFIaJ

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

What’s a cloud financial officer and why should this role be in all organizations? Find out in this… t.co/vNJe6xsG7s