MySQL 4.x server
MySQL 4.x server
Log Track Supported: Yes
Config Track Supported: No
Custom Properties Supported: None
Supported Control Actions: None
Supported Metrics:
| Name | Alias | Units | Category | Default On | Default Interval |
|---|---|---|---|---|---|
| Availability | Availability | percentage | AVAILABILITY | true | 5 min |
| Aborted Clients | AbortedClients | none | THROUGHPUT | false | 10 min |
| Aborted Clients per Minute | AbortedClients1m | none | THROUGHPUT | false | 10 min |
| Aborted Connects | AbortedConnects | none | THROUGHPUT | false | 10 min |
| Aborted Connects per Minute | AbortedConnects1m | none | THROUGHPUT | false | 10 min |
| Bytes Received | BytesReceived | B | THROUGHPUT | true | 10 min |
| Bytes Received per Minute | BytesReceived1m | B | THROUGHPUT | true | 10 min |
| Bytes Sent | BytesSent | B | THROUGHPUT | true | 10 min |
| Bytes Sent per Minute | BytesSent1m | B | THROUGHPUT | true | 10 min |
| Data Length | DataLength | B | UTILIZATION | true | 5 min |
| Index Length | IndexLength | B | UTILIZATION | false | 5 min |
| Total Rows | TotalRows | none | UTILIZATION | false | 5 min |
| Number of admin commands | CmdAdminCommands | none | UTILIZATION | false | 10 min |
| Number of admin commands per Minute | CmdAdminCommands1m | none | UTILIZATION | false | 10 min |
| Number of alter table commands | CmdAlterTable | none | UTILIZATION | false | 10 min |
| Number of alter table commands per Minute | CmdAlterTable1m | none | UTILIZATION | false | 10 min |
| Number of analyze commands | CmdAnalyze | none | UTILIZATION | false | 10 min |
| Number of analyze commands per Minute | CmdAnalyze1m | none | UTILIZATION | false | 10 min |
| Number of backup table commands | CmdBackupTable | none | UTILIZATION | false | 10 min |
| Number of backup table commands per Minute | CmdBackupTable1m | none | UTILIZATION | false | 10 min |
| Number of begin commands | CmdBegin | none | UTILIZATION | false | 10 min |
| Number of begin commands per Minute | CmdBegin1m | none | UTILIZATION | false | 10 min |
| Number of change db commands | CmdChangeDb | none | UTILIZATION | false | 10 min |
| Number of change db commands per Minute | CmdChangeDb1m | none | UTILIZATION | false | 10 min |
| Number of change master commands | CmdChangeMaster | none | UTILIZATION | false | 10 min |
| Number of change master commands per Minute | CmdChangeMaster1m | none | UTILIZATION | false | 10 min |
| Number of check commands | CmdCheck | none | UTILIZATION | false | 10 min |
| Number of check commands per Minute | CmdCheck1m | none | UTILIZATION | false | 10 min |
| Number of commit commands | CmdCommit | none | UTILIZATION | false | 10 min |
| Number of commit commands per Minute | CmdCommit1m | none | UTILIZATION | false | 10 min |
| Number of create db commands | CmdCreateDb | none | UTILIZATION | false | 10 min |
| Number of create db commands per Minute | CmdCreateDb1m | none | UTILIZATION | false | 10 min |
| Number of create function commands | CmdCreateFunction | none | UTILIZATION | false | 10 min |
| Number of create function commands per Minute | CmdCreateFunction1m | none | UTILIZATION | false | 10 min |
| Number of create index commands | CmdCreateIndex | none | UTILIZATION | false | 10 min |
| Number of create index commands per Minute | CmdCreateIndex1m | none | UTILIZATION | false | 10 min |
| Number of create table commands | CmdCreateTable | none | UTILIZATION | false | 10 min |
| Number of create table commands per Minute | CmdCreateTable1m | none | UTILIZATION | false | 10 min |
| Number of delete commands | CmdDelete | none | UTILIZATION | false | 10 min |
| Number of delete commands per Minute | CmdDelete1m | none | UTILIZATION | false | 10 min |
| Number of drop db commands | CmdDropDb | none | UTILIZATION | false | 10 min |
| Number of drop db commands per Minute | CmdDropDb1m | none | UTILIZATION | false | 10 min |
| Number of drop function commands | CmdDropFunction | none | UTILIZATION | false | 10 min |
| Number of drop function commands per Minute | CmdDropFunction1m | none | UTILIZATION | false | 10 min |
| Number of drop index commands | CmdDropIndex | none | UTILIZATION | false | 10 min |
| Number of drop index commands per Minute | CmdDropIndex1m | none | UTILIZATION | false | 10 min |
| Number of drop table commands | CmdDropTable | none | UTILIZATION | false | 10 min |
| Number of drop table commands per Minute | CmdDropTable1m | none | UTILIZATION | false | 10 min |
| Number of flush commands | CmdFlush | none | UTILIZATION | false | 10 min |
| Number of flush commands per Minute | CmdFlush1m | none | UTILIZATION | false | 10 min |
| Number of grant commands | CmdGrant | none | UTILIZATION | false | 10 min |
| Number of grant commands per Minute | CmdGrant1m | none | UTILIZATION | false | 10 min |
| Number of insert commands | CmdInsert | none | UTILIZATION | false | 10 min |
| Number of insert commands per Minute | CmdInsert1m | none | UTILIZATION | false | 10 min |
| Number of insert select commands | CmdInsertSelect | none | UTILIZATION | false | 10 min |
| Number of insert select commands per Minute | CmdInsertSelect1m | none | UTILIZATION | false | 10 min |
| Number of kill commands | CmdKill | none | UTILIZATION | false | 10 min |
| Number of kill commands per Minute | CmdKill1m | none | UTILIZATION | false | 10 min |
| Number of load commands | CmdLoad | none | UTILIZATION | false | 10 min |
| Number of load commands per Minute | CmdLoad1m | none | UTILIZATION | false | 10 min |
| Number of load master table commands | CmdLoadMasterTable | none | UTILIZATION | false | 10 min |
| Number of load master table commands per Minute | CmdLoadMasterTable1m | none | UTILIZATION | false | 10 min |
| Number of lock tables commands | CmdLockTables | none | UTILIZATION | false | 10 min |
| Number of lock tables commands per Minute | CmdLockTables1m | none | UTILIZATION | false | 10 min |
| Number of optimize commands | CmdOptimize | none | UTILIZATION | false | 10 min |
| Number of optimize commands per Minute | CmdOptimize1m | none | UTILIZATION | false | 10 min |
| Number of purge commands | CmdPurge | none | UTILIZATION | false | 10 min |
| Number of purge commands per Minute | CmdPurge1m | none | UTILIZATION | false | 10 min |
| Number of rename table commands | CmdRenameTable | none | UTILIZATION | false | 10 min |
| Number of rename table commands per Minute | CmdRenameTable1m | none | UTILIZATION | false | 10 min |
| Number of repair commands | CmdRepair | none | UTILIZATION | false | 10 min |
| Number of repair commands per Minute | CmdRepair1m | none | UTILIZATION | false | 10 min |
| Number of replace commands | CmdReplace | none | UTILIZATION | false | 10 min |
| Number of replace commands per Minute | CmdReplace1m | none | UTILIZATION | false | 10 min |
| Number of replace select commands | CmdReplaceSelect | none | UTILIZATION | false | 10 min |
| Number of replace select commands per Minute | CmdReplaceSelect1m | none | UTILIZATION | false | 10 min |
| Number of reset commands | CmdReset | none | UTILIZATION | false | 10 min |
| Number of reset commands per Minute | CmdReset1m | none | UTILIZATION | false | 10 min |
| Number of restore table commands | CmdRestoreTable | none | UTILIZATION | false | 10 min |
| Number of restore table commands per Minute | CmdRestoreTable1m | none | UTILIZATION | false | 10 min |
| Number of revoke commands | CmdRevoke | none | UTILIZATION | false | 10 min |
| Number of revoke commands per Minute | CmdRevoke1m | none | UTILIZATION | false | 10 min |
| Number of rollback commands | CmdRollback | none | UTILIZATION | false | 10 min |
| Number of rollback commands per Minute | CmdRollback1m | none | UTILIZATION | false | 10 min |
| Number of select commands | CmdSelect | none | UTILIZATION | false | 10 min |
| Number of select commands per Minute | CmdSelect1m | none | UTILIZATION | false | 10 min |
| Number of set option commands | CmdSetOption | none | UTILIZATION | false | 10 min |
| Number of set option commands per Minute | CmdSetOption1m | none | UTILIZATION | false | 10 min |
| Number of show binlogs commands | CmdShowBinlogs | none | UTILIZATION | false | 10 min |
| Number of show binlogs commands per Minute | CmdShowBinlogs1m | none | UTILIZATION | false | 10 min |
| Number of show databases commands | CmdShowDatabases | none | UTILIZATION | false | 10 min |
| Number of show databases commands per Minute | CmdShowDatabases1m | none | UTILIZATION | false | 10 min |
| Number of show fields commands | CmdShowFields | none | UTILIZATION | false | 10 min |
| Number of show fields commands per Minute | CmdShowFields1m | none | UTILIZATION | false | 10 min |
| Number of show grants commands | CmdShowGrants | none | UTILIZATION | false | 10 min |
| Number of show grants commands per Minute | CmdShowGrants1m | none | UTILIZATION | false | 10 min |
| Number of show keys commands | CmdShowKeys | none | UTILIZATION | false | 10 min |
| Number of show keys commands per Minute | CmdShowKeys1m | none | UTILIZATION | false | 10 min |
| Number of show logs commands | CmdShowLogs | none | UTILIZATION | false | 10 min |
| Number of show logs commands per Minute | CmdShowLogs1m | none | UTILIZATION | false | 10 min |
| Number of show master status commands | CmdShowMasterStatus | none | UTILIZATION | false | 10 min |
| Number of show master status commands per Minute | CmdShowMasterStatus1m | none | UTILIZATION | false | 10 min |
| Number of show open tables commands | CmdShowOpenTables | none | UTILIZATION | false | 10 min |
| Number of show open tables commands per Minute | CmdShowOpenTables1m | none | UTILIZATION | false | 10 min |
| Number of show processlist commands | CmdShowProcesslist | none | UTILIZATION | false | 10 min |
| Number of show processlist commands per Minute | CmdShowProcesslist1m | none | UTILIZATION | false | 10 min |
| Number of show slave status commands | CmdShowSlaveStatus | none | UTILIZATION | false | 10 min |
| Number of show slave status commands per Minute | CmdShowSlaveStatus1m | none | UTILIZATION | false | 10 min |
| Number of show status commands | CmdShowStatus | none | UTILIZATION | false | 10 min |
| Number of show status commands per Minute | CmdShowStatus1m | none | UTILIZATION | false | 10 min |
| Number of show innodb status commands | CmdShowInnodbStatus | none | UTILIZATION | false | 10 min |
| Number of show innodb status commands per Minute | CmdShowInnodbStatus1m | none | UTILIZATION | false | 10 min |
| Number of show tables commands | CmdShowTables | none | UTILIZATION | false | 10 min |
| Number of show tables commands per Minute | CmdShowTables1m | none | UTILIZATION | false | 10 min |
| Number of show variables commands | CmdShowVariables | none | UTILIZATION | false | 10 min |
| Number of show variables commands per Minute | CmdShowVariables1m | none | UTILIZATION | false | 10 min |
| Number of slave start commands | CmdSlaveStart | none | UTILIZATION | false | 10 min |
| Number of slave start commands per Minute | CmdSlaveStart1m | none | UTILIZATION | false | 10 min |
| Number of slave stop commands | CmdSlaveStop | none | UTILIZATION | false | 10 min |
| Number of slave stop commands per Minute | CmdSlaveStop1m | none | UTILIZATION | false | 10 min |
| Number of truncate commands | CmdTruncate | none | UTILIZATION | false | 10 min |
| Number of truncate commands per Minute | CmdTruncate1m | none | UTILIZATION | false | 10 min |
| Number of unlock table commands | CmdUnlockTables | none | UTILIZATION | false | 10 min |
| Number of unlock table commands per Minute | CmdUnlockTables1m | none | UTILIZATION | false | 10 min |
| Number of update commands | CmdUpdate | none | UTILIZATION | false | 10 min |
| Number of update commands per Minute | CmdUpdate1m | none | UTILIZATION | false | 10 min |
| Connections | Connections | none | THROUGHPUT | false | 10 min |
| Connections per Minute | Connections1m | none | THROUGHPUT | false | 10 min |
| Temporary Disk Tables Created | CreatedTmpDiskTables | none | UTILIZATION | false | 10 min |
| Temporary Disk Tables Created per Minute | CreatedTmpDiskTables1m | none | UTILIZATION | false | 10 min |
| Temporary Memory Tables Created | CreatedTmpMemTables | none | UTILIZATION | false | 10 min |
| Temporary Memory Tables Created per Minute | CreatedTmpMemTables1m | none | UTILIZATION | false | 10 min |
| Temporary Files Created | CreatedTmpFiles | none | UTILIZATION | false | 10 min |
| Temporary Files Created per Minute | CreatedTmpFiles1m | none | UTILIZATION | false | 10 min |
| Delayed Insert Threads | DelayedInsertThreads | none | UTILIZATION | false | 10 min |
| Delayed Insert Threads per Minute | DelayedInsertThreads1m | none | UTILIZATION | false | 10 min |
| Delayed Writes | DelayedWrites | none | UTILIZATION | false | 10 min |
| Delayed Writes per Minute | DelayedWrites1m | none | UTILIZATION | false | 10 min |
| Delayed Errors | DelayedErrors | none | UTILIZATION | false | 10 min |
| Delayed Errors per Minute | DelayedErrors1m | none | UTILIZATION | false | 10 min |
| Flush Commands | FlushCommands | none | UTILIZATION | false | 10 min |
| Flush Commands per Minute | FlushCommands1m | none | UTILIZATION | false | 10 min |
| Number of Rows Deleted | HandlerDelete | none | UTILIZATION | false | 10 min |
| Number of Rows Deleted per Minute | HandlerDelete1m | none | UTILIZATION | false | 10 min |
| Number of Rows Read from First Index | HandlerReadFirst | none | UTILIZATION | false | 10 min |
| Number of Rows Read from First Index per Minute | HandlerReadFirst1m | none | UTILIZATION | false | 10 min |
| Number of Rows Read from Key | HandlerReadKey | none | UTILIZATION | false | 10 min |
| Number of Rows Read from Key per Minute | HandlerReadKey1m | none | UTILIZATION | false | 10 min |
| Number of Next Rows Read in Key Order | HandlerReadNext | none | UTILIZATION | false | 10 min |
| Number of Next Rows Read in Key Order per Minute | HandlerReadNext1m | none | UTILIZATION | false | 10 min |
| Number of Prev Rows Read in Key Order | HandlerReadPrev | none | UTILIZATION | false | 10 min |
| Number of Prev Rows Read in Key Order per Minute | HandlerReadPrev1m | none | UTILIZATION | false | 10 min |
| Number of Rows Read from Fixed Position | HandlerReadRnd | none | UTILIZATION | false | 10 min |
| Number of Rows Read from Fixed Position per Minute | HandlerReadRnd1m | none | UTILIZATION | false | 10 min |
| Number of Next Rows Read from Datafile | HandlerReadRndNext | none | UTILIZATION | false | 10 min |
| Number of Next Rows Read from Datafile per Minute | HandlerReadRndNext1m | none | UTILIZATION | false | 10 min |
| Number of Rows Updated | HandlerUpdate | none | UTILIZATION | false | 10 min |
| Number of Rows Updated per Minute | HandlerUpdate1m | none | UTILIZATION | false | 10 min |
| Number of Rows Inserted | HandlerWrite | none | UTILIZATION | false | 10 min |
| Number of Rows Inserted per Minute | HandlerWrite1m | none | UTILIZATION | false | 10 min |
| Key Blocks Used | KeyBlocksUsed | none | UTILIZATION | false | 10 min |
| Key Blocks Used per Minute | KeyBlocksUsed1m | none | UTILIZATION | false | 10 min |
| Key Read Requests | KeyReadRequests | none | UTILIZATION | false | 10 min |
| Key Read Requests per Minute | KeyReadRequests1m | none | UTILIZATION | false | 10 min |
| Key Reads | KeyReads | none | UTILIZATION | false | 10 min |
| Key Reads per Minute | KeyReads1m | none | UTILIZATION | false | 10 min |
| Key Write Requests | KeyWriteRequests | none | UTILIZATION | false | 10 min |
| Key Write Requests per Minute | KeyWriteRequests1m | none | UTILIZATION | false | 10 min |
| Key Writes | KeyWrites | none | UTILIZATION | false | 10 min |
| Key Writes per Minute | KeyWrites1m | none | UTILIZATION | false | 10 min |
| Max Used Connections | MaxUsedConnections | none | THROUGHPUT | false | 10 min |
| Max Used Connections per Minute | MaxUsedConnections1m | none | THROUGHPUT | false | 10 min |
| Not Flushed Delayed Rows | NotFlushedDelayedRows | none | UTILIZATION | false | 10 min |
| Not Flushed Delayed Rows per Minute | NotFlushedDelayedRows1m | none | UTILIZATION | false | 10 min |
| Open Tables | OpenTables | none | UTILIZATION | false | 5 min |
| Open Files | OpenFiles | none | UTILIZATION | false | 5 min |
| Open Streams | OpenStreams | none | UTILIZATION | false | 5 min |
| Opened Tables | OpenedTables | none | UTILIZATION | false | 10 min |
| Opened Tables per Minute | OpenedTables1m | none | UTILIZATION | false | 10 min |
| Questions | Questions | none | THROUGHPUT | true | 10 min |
| Questions per Minute | Questions1m | none | THROUGHPUT | true | 10 min |
| Select Full Join | SelectFullJoin | none | UTILIZATION | false | 10 min |
| Select Full Join per Minute | SelectFullJoin1m | none | UTILIZATION | false | 10 min |
| Select Full Range Join | SelectFullRangeJoin | none | UTILIZATION | false | 10 min |
| Select Full Range Join per Minute | SelectFullRangeJoin1m | none | UTILIZATION | false | 10 min |
| Select Range | SelectRange | none | UTILIZATION | false | 10 min |
| Select Range per Minute | SelectRange1m | none | UTILIZATION | false | 10 min |
| Select Range Check | SelectRangeCheck | none | UTILIZATION | false | 10 min |
| Select Range Check per Minute | SelectRangeCheck1m | none | UTILIZATION | false | 10 min |
| Select Scan | SelectScan | none | UTILIZATION | false | 10 min |
| Select Scan per Minute | SelectScan1m | none | UTILIZATION | false | 10 min |
| Slave Open Temp Tables | SlaveOpenTempTables | none | UTILIZATION | false | 10 min |
| Slave Open Temp Tables per Minute | SlaveOpenTempTables1m | none | UTILIZATION | false | 10 min |
| Slow Launch Threads | SlowLaunchThreads | none | UTILIZATION | false | 10 min |
| Slow Launch Threads per Minute | SlowLaunchThreads1m | none | UTILIZATION | false | 10 min |
| Slow Queries | SlowQueries | none | UTILIZATION | true | 10 min |
| Slow Queries per Minute | SlowQueries1m | none | UTILIZATION | true | 10 min |
| Sort Merge Passes | SortMergePasses | none | UTILIZATION | false | 10 min |
| Sort Merge Passes per Minute | SortMergePasses1m | none | UTILIZATION | false | 10 min |
| Sort Range | SortRange | none | UTILIZATION | false | 10 min |
| Sort Range per Minute | SortRange1m | none | UTILIZATION | false | 10 min |
| Sort Rows | SortRows | none | UTILIZATION | false | 10 min |
| Sort Rows per Minute | SortRows1m | none | UTILIZATION | false | 10 min |
| Table Locks Immediate | TableLocksImmediate | none | UTILIZATION | false | 10 min |
| Table Locks Immediate per Minute | TableLocksImmediate1m | none | UTILIZATION | false | 10 min |
| Table Locks Waited | TableLocksWaited | none | UTILIZATION | false | 10 min |
| Table Locks Waited per Minute | TableLocksWaited1m | none | UTILIZATION | false | 10 min |
| Threads Cached | ThreadsCached | none | UTILIZATION | false | 10 min |
| Threads Cached per Minute | ThreadsCached1m | none | UTILIZATION | false | 10 min |
| Threads Created | ThreadsCreated | none | UTILIZATION | false | 10 min |
| Threads Created per Minute | ThreadsCreated1m | none | UTILIZATION | false | 10 min |
| Threads Connected | ThreadsConnected | none | UTILIZATION | true | 5 min |
| Threads Running | ThreadsRunning | none | UTILIZATION | false | 10 min |
| Threads Running per Minute | ThreadsRunning1m | none | UTILIZATION | false | 10 min |
| Up Time | Uptime | sec | AVAILABILITY | false | 5 min |
| Number of delete multi commands | CmdDeleteMulti | none | UTILIZATION | false | 10 min |
| Number of delete multi commands per Minute | CmdDeleteMulti1m | none | UTILIZATION | false | 10 min |
| Number of ha close commands | CmdHaClose | none | UTILIZATION | false | 10 min |
| Number of ha close commands per Minute | CmdHaClose1m | none | UTILIZATION | false | 10 min |
| Number of ha open commands | CmdHaOpen | none | UTILIZATION | false | 10 min |
| Number of ha open commands per Minute | CmdHaOpen1m | none | UTILIZATION | false | 10 min |
| Number of ha read commands | CmdHaRead | none | UTILIZATION | false | 10 min |
| Number of ha read commands per Minute | CmdHaRead1m | none | UTILIZATION | false | 10 min |
| Number of load master data commands | CmdLoadMasterData | none | UTILIZATION | false | 10 min |
| Number of load master data commands per Minute | CmdLoadMasterData1m | none | UTILIZATION | false | 10 min |
| Number of show binlog events commands | CmdShowBinlogEvents | none | UTILIZATION | false | 10 min |
| Number of show binlog events commands per Minute | CmdShowBinlogEvents1m | none | UTILIZATION | false | 10 min |
| Number of show new master commands | CmdShowNewMaster | none | UTILIZATION | false | 10 min |
| Number of show new master commands per Minute | CmdShowNewMaster1m | none | UTILIZATION | false | 10 min |
| Number of show slave hosts commands | CmdShowSlaveHosts | none | UTILIZATION | false | 10 min |
| Number of show slave hosts commands per Minute | CmdShowSlaveHosts1m | none | UTILIZATION | false | 10 min |
Configuration help:
Configure MySQL 4.x for Monitoring
The MySQL 4.x plugin monitors the MySQL server using standard JDBC queries. The only prerequisites for enabling monitoring are:
- You can connect to the MySQL server as ${jdbcUser} using the JDBC URL ${jdbcUrl}
- The user ${jdbcUser} is able to issue 'SHOW STATUS' commands to MySQL
General Log and Config Track Properties
- Enable Log Tracking - Check to enable log tracking.
- Track event log level - Only track events of level greater than or equal to this level. Order is: [Error, Warn, Info, Debug]
- Log Pattern Match - Include messages that match the given regular expression. The given pattern can be a substring to look for in log messages or a regular expression. See: java.util.regex.Pattern.
- Log Pattern Exclude - Exclude messages that match the given regular expression.
- Log Files - Comma delimited list of log files to track. Relative files are resolved to ${installpath}.