MySQL DB MPI

The netage Management Plug-in (MPI) for MySQL databases enables professional monitoring and problem detection for the MySQL database instances. The MPI adds MySQL database monitoring and management capabilities to the boom server.

The MySQL DB MPI is an adapted version of the MySQL DB SPI (Smart Plug-In) for HP OMU/OMW with 100% identical code. The MPI version (boom compatible) has an additional component to the SPI version (HP OMU/OMW compatible) that ensures a secure and fast interconnection with the boom server.

For more information about features in the MySQL DB MPI and SPI see the fact sheet. To see the entire list of metrics see below.

The MySQL DB for Windows manual can be found here, and the MySQL DB for Unix is here.

Metrics:

MySQLMPI_AbortedClientsDelta MySQLMPI_AbortedConnectionsRate MySQLMPI_AlterDbDelta MySQLMPI_AlterTableDelta MySQLMPI_AvgAbortedClients MySQLMPI_AvgBytesReceived MySQLMPI_AvgBytesSent MySQLMPI_AvgCpuUsed MySQLMPI_AvgHandlerCommit MySQLMPI_AvgOpenedTables MySQLMPI_AvgQueries MySQLMPI_AvgSelectFullJoin MySQLMPI_AvgSelectFullRangeJoin MySQLMPI_AvgSelectRange MySQLMPI_AvgSelectScan MySQLMPI_AvgSlowLaunchThreads MySQLMPI_AvgSlowQueries MySQLMPI_AvgSortMergePasses MySQLMPI_AvgThreadsCreated MySQLMPI_AvgThreadsRunning MySQLMPI_BinlogCacheUsage MySQLMPI_ConcurrentQueries MySQLMPI_Connections MySQLMPI_CreateFunctionDelta MySQLMPI_CreateIndexDelta MySQLMPI_CreateTableDelta MySQLMPI_DeltaHandlerRollback MySQLMPI_DeltaQCacheMemPrunes MySQLMPI_DeltaTmpDiskTables MySQLMPI_DeltaTmpTables MySQLMPI_DropFunctionDelta MySQLMPI_DropTableDelta MySQLMPI_DropUserDelta MySQLMPI_FreeDiskInnodb MySQLMPI_FreeDiskInnodbLogs MySQLMPI_FreeDiskSpace MySQLMPI_GrantsDelta MySQLMPI_InnoDBBufferHitRate MySQLMPI_InnoDBBufferPoolWaits MySQLMPI_InnoDBLockWaits MySQLMPI_InnoDBLogWaits MySQLMPI_InnoDBRead MySQLMPI_InnoDBSize MySQLMPI_InnoDBWrite MySQLMPI_KeyReadRatio MySQLMPI_KeyWriteRatio MySQLMPI_MaxOpenedTables MySQLMPI_MaxThreadsCache MySQLMPI_MemoryUsed MySQLMPI_messages MySQLMPI_MyISAMSize MySQLMPI_MyISAMTblLockRatio MySQLMPI_MYISAM_Check MySQLMPI_OpenTables MySQLMPI_QueryCacheFragments MySQLMPI_QueryCacheHitRate MySQLMPI_ResponseTime MySQLMPI_RevokeAllDelta MySQLMPI_RevokesDelta MySQLMPI_STATUS MySQLMPI_TableFreeCache MySQLMPI_ThreadPoolFreeSize MySQLMPI_ThreadsRunning MySQLMPI_TmpTablesOnDiskRatio