MySQL User Activity Test

This test reports the number and state of the processes of each user who is currently connected to the MySQL server. Using the metrics reported by this test, administrators can promptly isolate idle processes, which are a drain on a server’s resources.

Target of the test : A MySQL server

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for each user currently connected to the MySQL server monitored

Configurable parameters for the test
  1. TEST PERIOD – How often should the test be executed
  2. Host – The IP address of the MySQL server
  3. Port – The port on which the server is listening
  4. db – the name of a database on the server
  5. Usernameand password - The eG agent has to be configured with the credentials of a user who has server-wide process and select privileges on the monitored MySQL server. To know how to create such a user, refer to Pre-requisites for Monitoring the MySQL Server topic.
  6. Confirm password – Confirm the password by retyping it here.
  7. idle time - Specify the time duration (in seconds) above which the processes that are waiting in the database will be regarded as idle. 
  8. DETAILED DIAGNOSIS – To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

    The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

    • The eG manager license should allow the detailed diagnosis capability
    • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Total processes:

Indicates the total number of processes for this user.

Number

The detailed diagnosis of this measure if enabled, lists out all the processes for this user.

Active processes:

Indicates the number of processes of this user that are currently active.

Number

The detailed diagnosis of this measure indicates the exact active processes of this user and the time for which the processes are actually active.

Inactive processes:

Indicates the processes that were inactive for this user in this database.

Number

The detailed diagnosis of this measure if enabled, indicates the inactive processes of this user and the time for which the processes were inactive.

Idle processes:

Indicates the processes that are idle for this user in this database.

Number

The detailed diagnosis of this measure if enabled, indicates the idle processes of this user and the time for which the processes were idle.

The detailed diagnosis of the Active processes measure, if enabled, will indicatethe exact active processes of this user and the time for which the processes were actually active.

DDactiveprocs

Figure 1 : The detailed diagnosis of the Active processes measure

The detailed diagnosis of this measure if enabled, indicates the idle processes of this user and the time for which the processes were idle. Using this information, you can understand how each of the idle connections were made - i.e., using which program - and from where - i.e., from which host.

DDidleprocs

Figure 2 : The detailed diagnosis of the Idle processes meaure