aboutsummaryrefslogtreecommitdiff
path: root/src/MYSQL-STAT-MIB.txt
diff options
context:
space:
mode:
Diffstat (limited to 'src/MYSQL-STAT-MIB.txt')
-rw-r--r--src/MYSQL-STAT-MIB.txt352
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:

Return to:

Send suggestions and report system problems to the System administrator.