MySQL Cluster Process Test

This test reports the total number of processes executing on the target MySQL database cluster and the number of processes in the different process states - starting, running, stopping, stopped, failed, unknown etc. Using this test, administrators can isolate failed processes and can initiate a probe to figure out the reason behind the failed processes.

Target of the test : A MySQL Cluster

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each node in the target cluster being monitored

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port at which the specified host listens.

MCMPath

Specify the full path to the location where the target MySQL Cluster manager is installed. For example, your location can be C:\Users\user\AppData\Roaming/mcmd.conf. By default, none is specified against this parameter.

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

Process count

Indicates the total number of processes executing on this node.

Number

This measure is a good indicator of process load on each node of the target MySQL database cluster.

Added processes

Indicates the number of processes that were added to this node during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the processes/package executing the processes that were added for each node.

Starting processes

Indicates the number of processes that were in Stating state during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the processes/package executing the processes that were in Starting state for each node.

Running processes

Indicates the number of processes that were in Running state during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the processes/package executing the processes that were in Running state for each node.

Stopping processes

Indicates the number of processes that were in Stopping state during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the processes/package executing the processes that were in Stopping state for each node.

Stopped processes

Indicates the number of processes that were stopped on this node during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the processes/package executing the processes that were in Stopped state for each node.

Failed processes

Indicates the number of processes that failed on this node during the last measurement period.

Number

Ideally, the value of this measure should be 0.

The detailed diagnosis of this measure lists the name of the processes/package executing the processes that failed for each node.

Unknown processes

Indicates the number of processes that were in an Unknown state during the last measurement period.

Number

The detailed diagnosis of this measure lists the name of the processes/package executing the processes that were in Unknown state for each node.