diff options
Diffstat (limited to 'src/MYSQL-STAT-MIB.txt')
-rw-r--r-- | src/MYSQL-STAT-MIB.txt | 352 |
1 files changed, 311 insertions, 41 deletions
diff --git a/src/MYSQL-STAT-MIB.txt b/src/MYSQL-STAT-MIB.txt index 1580837..8fbc0e6 100644 --- a/src/MYSQL-STAT-MIB.txt +++ b/src/MYSQL-STAT-MIB.txt @@ -18,19 +18,90 @@ IMPORTS FROM INET-ADDRESS-MIB; mysql MODULE-IDENTITY - LAST-UPDATED "201606060944Z" + LAST-UPDATED "201606061638Z" ORGANIZATION "Gray Software" CONTACT-INFO "Sergey Poznyakoff <gray@gnu.org>" DESCRIPTION "This MIB module defines objects for MySQL statistics." - REVISION "201606060944Z" + REVISION "201606061638Z" DESCRIPTION "First revision." ::= { enterprises 9163 101 } replication OBJECT IDENTIFIER ::= { mysql 1 } -replStatus OBJECT IDENTIFIER ::= { replication 1 } -replConfig OBJECT IDENTIFIER ::= { replication 2 } +processList OBJECT IDENTIFIER ::= { mysql 2 } + +-- +-- Replication Slave Status +-- + +replSlaveStatusTable OBJECT-TYPE + SYNTAX SEQUENCE OF ReplSlaveStatusEntry + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "A table of replication status. On replication slave, + it contains a single row, describing the current + status." + ::= { replication 1 } + +replSlaveStatusEntry OBJECT-TYPE + SYNTAX ReplSlaveStatusEntry + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "An entry describing slave status." + INDEX { replSlaveIndex } + ::= { replSlaveStatusTable 1 } + +ReplSlaveStatusEntry ::= SEQUENCE { + replSlaveIndex Integer32, + replSlaveIOState ThreadStatusString, + replMasterLogFile DisplayString, + replReadMasterLogPos Counter32, + replRelayLogFile DisplayString, + replRelayLogPos Counter32, + replRelayMasterLogFile DisplayString, + replSlaveIORunning SlaveRunningState, + replSlaveSQLRunning TruthValue, + replLastSQLErrno Integer32, + replLastSQLError SQLErrorString, + replLastIOErrno Integer32, + replLastIOError SQLErrorString, + replExecMasterLogPos Counter32, + replRelayLogSpace Counter64, + replSecondsBehindMaster TimeStamp, + replMasterHost DisplayString, + replMasterUser DisplayString, + replMasterPort Integer32, + replConnectRetry TimeStamp, + replReplicateDoDB DisplayString, + replReplicateIgnoreDB DisplayString, + replReplicateDoTable DisplayString, + replReplicateIgnoreTable DisplayString, + replReplicateWildDoTable DisplayString, + replReplicateWildIgnoreTable DisplayString, + replSkipCounter Counter32, + replUntilCondition DisplayString, + replUntilLogFile DisplayString, + replUntilLogPos DisplayString, + replMasterServerId Integer32, + replMasterSSLAllowed DisplayString, + replMasterSSLCAFile DisplayString, + replMasterSSLCAPath DisplayString, + replMasterSSLCert DisplayString, + replMasterSSLCipher DisplayString, + replMasterSSLKey DisplayString, + replMasterSSLVerifyServerCert TruthValue +} + +replSlaveIndex OBJECT-TYPE + SYNTAX Integer32 (0..65535) + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "A number uniquely identifying slave status row." + ::= { replSlaveStatusEntry 1 } ThreadStatusString ::= TEXTUAL-CONVENTION DISPLAY-HINT "128t" @@ -46,7 +117,7 @@ replSlaveIOState OBJECT-TYPE "Describes what the thread is doing: trying to connect to the master, waiting for events from the master, reconnecting to the master, etc." - ::= { replStatus 1 } + ::= { replSlaveStatusEntry 2 } replMasterLogFile OBJECT-TYPE SYNTAX DisplayString @@ -55,7 +126,7 @@ replMasterLogFile OBJECT-TYPE DESCRIPTION "The name of the master binary log file from which the I/O thread is currently reading." - ::= { replStatus 2 } + ::= { replSlaveStatusEntry 3 } replReadMasterLogPos OBJECT-TYPE SYNTAX Counter32 @@ -64,7 +135,7 @@ replReadMasterLogPos OBJECT-TYPE DESCRIPTION "The position in the current master binary log file up to which the I/O thread has read." - ::= { replStatus 3 } + ::= { replSlaveStatusEntry 4 } replRelayLogFile OBJECT-TYPE SYNTAX DisplayString @@ -73,7 +144,7 @@ replRelayLogFile OBJECT-TYPE DESCRIPTION "The name of the relay log file from which the SQL thread is currently reading and executing." - ::= { replStatus 4 } + ::= { replSlaveStatusEntry 5 } replRelayLogPos OBJECT-TYPE SYNTAX Counter32 @@ -82,7 +153,7 @@ replRelayLogPos OBJECT-TYPE DESCRIPTION "The position in the current relay log file up to which the SQL thread has read and executed." - ::= { replStatus 5 } + ::= { replSlaveStatusEntry 6 } replRelayMasterLogFile OBJECT-TYPE SYNTAX DisplayString @@ -91,7 +162,7 @@ replRelayMasterLogFile OBJECT-TYPE DESCRIPTION "The name of the master binary log file containing the most recent event executed by the SQL thread." - ::= { replStatus 6 } + ::= { replSlaveStatusEntry 7 } SlaveRunningState ::= TEXTUAL-CONVENTION STATUS current @@ -107,7 +178,7 @@ replSlaveIORunning OBJECT-TYPE DESCRIPTION "Whether the I/O thread is started and has connected successfully to the master." - ::= { replStatus 7 } + ::= { replSlaveStatusEntry 8 } replSlaveSQLRunning OBJECT-TYPE SYNTAX TruthValue @@ -115,7 +186,7 @@ replSlaveSQLRunning OBJECT-TYPE STATUS current DESCRIPTION "Whether the SQL thread is started." - ::= { replStatus 8 } + ::= { replSlaveStatusEntry 9 } replLastSQLErrno OBJECT-TYPE SYNTAX Integer32 @@ -124,7 +195,7 @@ replLastSQLErrno OBJECT-TYPE DESCRIPTION "The error code of the last error that caused the SQL thread to stop." - ::= { replStatus 9 } + ::= { replSlaveStatusEntry 10 } SQLErrorString ::= TEXTUAL-CONVENTION DISPLAY-HINT "1024t" @@ -139,7 +210,7 @@ replLastSQLError OBJECT-TYPE DESCRIPTION "The error message describing the last error that caused the SQL thread to stop." - ::= { replStatus 10 } + ::= { replSlaveStatusEntry 11 } replLastIOErrno OBJECT-TYPE SYNTAX Integer32 @@ -148,7 +219,7 @@ replLastIOErrno OBJECT-TYPE DESCRIPTION "The error code of the last error that caused the IO thread to stop." - ::= { replStatus 11 } + ::= { replSlaveStatusEntry 12 } replLastIOError OBJECT-TYPE SYNTAX SQLErrorString @@ -157,7 +228,7 @@ replLastIOError OBJECT-TYPE DESCRIPTION "The error message describing the last error that caused the IO thread to stop." - ::= { replStatus 12 } + ::= { replSlaveStatusEntry 13 } replExecMasterLogPos OBJECT-TYPE SYNTAX Counter32 @@ -168,7 +239,7 @@ replExecMasterLogPos OBJECT-TYPE which the SQL thread has read and executed, marking the start of the next transaction or event to be processed." - ::= { replStatus 13 } + ::= { replSlaveStatusEntry 14 } replRelayLogSpace OBJECT-TYPE SYNTAX Counter64 @@ -177,7 +248,7 @@ replRelayLogSpace OBJECT-TYPE DESCRIPTION "The total combined size of all existing relay log files." - ::= { replStatus 14 } + ::= { replSlaveStatusEntry 15 } replSecondsBehindMaster OBJECT-TYPE SYNTAX TimeStamp @@ -188,7 +259,7 @@ replSecondsBehindMaster OBJECT-TYPE is. Basically, it reflects the time difference in seconds between the slave SQL thread and the slave I/O thread." - ::= { replStatus 15 } + ::= { replSlaveStatusEntry 16 } replMasterHost OBJECT-TYPE SYNTAX DisplayString @@ -196,7 +267,7 @@ replMasterHost OBJECT-TYPE STATUS current DESCRIPTION "The master host that the slave is connected to." - ::= { replConfig 1 } + ::= { replSlaveStatusEntry 17 } replMasterUser OBJECT-TYPE SYNTAX DisplayString @@ -205,7 +276,7 @@ replMasterUser OBJECT-TYPE DESCRIPTION "The user name of the account used to connect to the master." - ::= { replConfig 2 } + ::= { replSlaveStatusEntry 18 } replMasterPort OBJECT-TYPE SYNTAX Integer32 @@ -213,7 +284,7 @@ replMasterPort OBJECT-TYPE STATUS current DESCRIPTION "The port used to connect to the master." - ::= { replConfig 3 } + ::= { replSlaveStatusEntry 19 } replConnectRetry OBJECT-TYPE SYNTAX TimeStamp @@ -221,7 +292,7 @@ replConnectRetry OBJECT-TYPE STATUS current DESCRIPTION "The number of seconds between connect retries." - ::= { replConfig 4 } + ::= { replSlaveStatusEntry 20 } replReplicateDoDB OBJECT-TYPE SYNTAX DisplayString @@ -229,7 +300,7 @@ replReplicateDoDB OBJECT-TYPE STATUS current DESCRIPTION "The list of databases to replicate." - ::= { replConfig 5 } + ::= { replSlaveStatusEntry 21 } replReplicateIgnoreDB OBJECT-TYPE SYNTAX DisplayString @@ -237,7 +308,7 @@ replReplicateIgnoreDB OBJECT-TYPE STATUS current DESCRIPTION "The list of databases to exclude from replication." - ::= { replConfig 6 } + ::= { replSlaveStatusEntry 22 } replReplicateDoTable OBJECT-TYPE SYNTAX DisplayString @@ -245,7 +316,7 @@ replReplicateDoTable OBJECT-TYPE STATUS current DESCRIPTION "The list of tables to replicate." - ::= { replConfig 7 } + ::= { replSlaveStatusEntry 23 } replReplicateIgnoreTable OBJECT-TYPE SYNTAX DisplayString @@ -253,7 +324,7 @@ replReplicateIgnoreTable OBJECT-TYPE STATUS current DESCRIPTION "The list of tables to exclude from replication." - ::= { replConfig 8 } + ::= { replSlaveStatusEntry 24 } replReplicateWildDoTable OBJECT-TYPE SYNTAX DisplayString @@ -261,7 +332,7 @@ replReplicateWildDoTable OBJECT-TYPE STATUS current DESCRIPTION "The lists of table name patterns to replicate." - ::= { replConfig 9 } + ::= { replSlaveStatusEntry 25 } replReplicateWildIgnoreTable OBJECT-TYPE SYNTAX DisplayString @@ -269,7 +340,7 @@ replReplicateWildIgnoreTable OBJECT-TYPE STATUS current DESCRIPTION "The lists of table name patterns to exclude from replication." - ::= { replConfig 10 } + ::= { replSlaveStatusEntry 26 } replSkipCounter OBJECT-TYPE SYNTAX Counter32 @@ -278,7 +349,7 @@ replSkipCounter OBJECT-TYPE DESCRIPTION "The current value of the `sql_slave_skip_counter' system variable." - ::= { replConfig 11 } + ::= { replSlaveStatusEntry 27 } replUntilCondition OBJECT-TYPE SYNTAX DisplayString @@ -297,7 +368,7 @@ replUntilCondition OBJECT-TYPE * `Relay' if the slave is reading until a given position in its relay log." - ::= { replConfig 12 } + ::= { replSlaveStatusEntry 28 } replUntilLogFile OBJECT-TYPE SYNTAX DisplayString @@ -305,7 +376,7 @@ replUntilLogFile OBJECT-TYPE STATUS current DESCRIPTION "The log file name at which the SQL thread stops executing." - ::= { replConfig 13 } + ::= { replSlaveStatusEntry 29 } replUntilLogPos OBJECT-TYPE SYNTAX DisplayString @@ -314,7 +385,7 @@ replUntilLogPos OBJECT-TYPE DESCRIPTION "The position in replUntilLogFile at which the SQL thread stops executing." - ::= { replConfig 14 } + ::= { replSlaveStatusEntry 30 } replMasterServerId OBJECT-TYPE SYNTAX Integer32 @@ -322,7 +393,7 @@ replMasterServerId OBJECT-TYPE STATUS current DESCRIPTION "ID of the master server." - ::= { replConfig 15 } + ::= { replSlaveStatusEntry 31 } replMasterSSLAllowed OBJECT-TYPE SYNTAX DisplayString @@ -339,7 +410,7 @@ replMasterSSLAllowed OBJECT-TYPE * `Ignored' if an SSL connection is permitted but the slave server does not have SSL support enabled." - ::= { replConfig 16 } + ::= { replSlaveStatusEntry 32 } replMasterSSLCAFile OBJECT-TYPE SYNTAX DisplayString @@ -347,7 +418,7 @@ replMasterSSLCAFile OBJECT-TYPE STATUS current DESCRIPTION "File name of the Master CA file." - ::= { replConfig 17 } + ::= { replSlaveStatusEntry 33 } replMasterSSLCAPath OBJECT-TYPE SYNTAX DisplayString @@ -355,7 +426,7 @@ replMasterSSLCAPath OBJECT-TYPE STATUS current DESCRIPTION "Path to look for SSL CA files." - ::= { replConfig 18 } + ::= { replSlaveStatusEntry 34 } replMasterSSLCert OBJECT-TYPE SYNTAX DisplayString @@ -363,7 +434,7 @@ replMasterSSLCert OBJECT-TYPE STATUS current DESCRIPTION "File name of the master SSL certificate file." - ::= { replConfig 19 } + ::= { replSlaveStatusEntry 35 } replMasterSSLCipher OBJECT-TYPE SYNTAX DisplayString @@ -371,7 +442,7 @@ replMasterSSLCipher OBJECT-TYPE STATUS current DESCRIPTION "SSL ciphersuites in use." - ::= { replConfig 20 } + ::= { replSlaveStatusEntry 36 } replMasterSSLKey OBJECT-TYPE SYNTAX DisplayString @@ -379,7 +450,7 @@ replMasterSSLKey OBJECT-TYPE STATUS current DESCRIPTION "File name of the master key file." - ::= { replConfig 21 } + ::= { replSlaveStatusEntry 37 } replMasterSSLVerifyServerCert OBJECT-TYPE SYNTAX TruthValue @@ -387,9 +458,208 @@ replMasterSSLVerifyServerCert OBJECT-TYPE STATUS current DESCRIPTION "Whether to verify server SSL certificate." - ::= { replConfig 22 } + ::= { replSlaveStatusEntry 38 } + +-- +-- Table of Replication Slave Servers +-- + +-- replSlaveCount OBJECT-TYPE +-- SYNTAX Counter32 +-- MAX-ACCESS read-only +-- STATUS current +-- DESCRIPTION +-- "Number of active replication slaves." +-- ::= { replSlave 1 } + +-- replSlaveTable OBJECT-TYPE +-- SYNTAX SEQUENCE OF ReplSlaveEntry +-- MAX-ACCESS not-accessible +-- STATUS current +-- DESCRIPTION +-- "A table of active replication slaves." +-- ::= { replSlave 2 } + +-- replSlaveEntry OBJECT-TYPE +-- SYNTAX ReplSlaveEntry +-- MAX-ACCESS not-accessible +-- STATUS current +-- DESCRIPTION +-- "An entry (conceptual row) describing a replication +-- slave server." +-- INDEX { replSlaveIndex } +-- ::= { replSlaveTable 1 } + +-- ReplSlaveEntry ::= SEQUENCE { +-- replSlaveIndex Integer32, +-- replSlaveHost DisplayString, +-- replSlaveUser DisplayString, +-- replSlaveCommand DisplayString, +-- replSlaveState DisplayString, +-- replSlaveTime TimeStamp, +-- replSlaveInfo DisplayString +-- } + +-- replSlaveIndex OBJECT-TYPE +-- SYNTAX Integer32 (0..65535) +-- MAX-ACCESS not-accessible +-- STATUS current +-- DESCRIPTION +-- "A number uniquely identifying each slave server." +-- ::= { replSlaveEntry 1 } + +-- replSlaveHost OBJECT-TYPE +-- SYNTAX DisplayString +-- MAX-ACCESS read-only +-- STATUS current +-- DESCRIPTION +-- "Hostname of the server." +-- ::= { replSlaveEntry 2 } + +-- replSlaveUser OBJECT-TYPE +-- SYNTAX DisplayString +-- MAX-ACCESS read-only +-- STATUS current +-- DESCRIPTION +-- "User name used by that server." +-- ::= { replSlaveEntry 3 } + +-- replSlaveCommand OBJECT-TYPE +-- SYNTAX DisplayString +-- MAX-ACCESS read-only +-- STATUS current +-- DESCRIPTION +-- "Command being run." +-- ::= { replSlaveEntry 4 } + +-- replSlaveState OBJECT-TYPE +-- SYNTAX DisplayString +-- MAX-ACCESS read-only +-- STATUS current +-- DESCRIPTION +-- "State of the connection." +-- ::= { replSlaveEntry 5 } + +-- replSlaveTime OBJECT-TYPE +-- SYNTAX TimeStamp +-- MAX-ACCESS read-only +-- STATUS current +-- DESCRIPTION +-- "Timestamp of the last status change." +-- ::= { replSlaveEntry 6 } + +-- replSlaveInfo OBJECT-TYPE +-- SYNTAX DisplayString +-- MAX-ACCESS read-only +-- STATUS current +-- DESCRIPTION +-- "Additional info about the connection." +-- ::= { replSlaveEntry 7 } + +-- +-- Process List +-- + +processListTable OBJECT-TYPE + SYNTAX SEQUENCE OF ProcessListEntry + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "A table of active threads." + ::= { processList 2 } + +processListEntry OBJECT-TYPE + SYNTAX ProcessListEntry + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "A conceptual row of process list table." + INDEX { processIndex } + ::= { processListTable 1 } + +ProcessListEntry ::= SEQUENCE { + processIndex Integer32, + processID Integer32, + processUser DisplayString, + processHost DisplayString, + processDatabase DisplayString, + processCommand DisplayString, + processTime TimeStamp, + processState DisplayString, + processInfo DisplayString +} + +processIndex OBJECT-TYPE + SYNTAX Integer32 (0..65535) + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "A number uniquely identifying each process." + ::= { processListEntry 1 } + +processID OBJECT-TYPE + SYNTAX Integer32 + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Thread ID." + ::= { processListEntry 2 } +processUser OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Connecting user." + ::= { processListEntry 3 } +processHost OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Remote hostname or IP." + ::= { processListEntry 4 } + +processDatabase OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Database name." + ::= { processListEntry 5 } + +processCommand OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Command being processed." + ::= { processListEntry 6 } + +processTime OBJECT-TYPE + SYNTAX TimeStamp + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Running time of the thread." + ::= { processListEntry 7 } + +processState OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Process state." + ::= { processListEntry 8 } + +processInfo OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Information about the process." + ::= { processListEntry 9 } END -- Local variables: |