1# mysql-snmp: cacti2MIB.pl 2# 3# This file contains the mapping from MySQL cacti templates to the MIB names, value and 4# and types. This file is used to generate the opennms configuration. 5# 6# (c) Copryright 2009 - Brice Figureau 7# 8# This program is free software: you can redistribute it and/or modify 9# it under the terms of the GNU General Public License as published by 10# the Free Software Foundation, either version 2 of the License, or 11# (at your option) any later version. 12# 13# This program is distributed in the hope that it will be useful, 14# but WITHOUT ANY WARRANTY; without even the implied warranty of 15# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 16# GNU General Public License for more details. 17# 18# You should have received a copy of the GNU General Public License 19# along with this program. If not, see <http://www.gnu.org/licenses/>. 20 21{ name => 'Cacti 2 MIB', 22 short_names => { 23 'Key_read_requests' => {mib => 'myKeyReadRequests', order => 1, type => 'Counter32'}, 24 'Key_reads' => {mib => 'myKeyReads', order => 2, type => 'Counter32'}, 25 'Key_write_requests' => {mib => 'myKeyWriteRequests', order => 3, type => 'Counter32'}, 26 'Key_writes' => {mib => 'myKeyWrites', order => 4, type => 'Counter32'}, 27 'history_list' => {mib => 'myHistoryList', order => 5, type => 'Gauge32'}, 28 'innodb_transactions' => {mib => 'myInnodbTransactions', order => 6, type => 'Counter64'}, 29 'read_views' => {mib => 'myReadViews', order => 7, type => 'Gauge32'}, 30 'current_transactions' => {mib => 'myCurrentTransactions', order => 8, type => 'Gauge32'}, 31 'locked_transactions' => {mib => 'myLockedTransactions', order => 9, type => 'Gauge32'}, 32 'active_transactions' => {mib => 'myActiveTransactions', order => 10, type => 'Gauge32'}, 33 'pool_size' => {mib => 'myPoolSize', order => 11, type => 'Gauge32'}, 34 'free_pages' => {mib => 'myFreePages', order => 12, type => 'Gauge32'}, 35 'database_pages' => {mib => 'myDatabasePages', order => 13, type => 'Gauge32'}, 36 'modified_pages' => {mib => 'myModifiedPages', order => 14, type => 'Gauge32'}, 37 'pages_read' => {mib => 'myPagesRead', order => 15, type => 'Counter32'}, 38 'pages_created' => {mib => 'myPagesCreated', order => 16, type => 'Counter32'}, 39 'pages_written' => {mib => 'myPagesWritten', order => 17, type => 'Counter32'}, 40 'file_fsyncs' => {mib => 'myFileFsyncs', order => 18, type => 'Counter32'}, 41 'file_reads' => {mib => 'myFileReads', order => 19, type => 'Counter32'}, 42 'file_writes' => {mib => 'myFileWrites', order => 20, type => 'Counter32'}, 43 'log_writes' => {mib => 'myLogWrites', order => 21, type => 'Counter32'}, 44 'pending_aio_log_ios' => {mib => 'myPendingAIOLogIOs', order => 22, type => 'Gauge32'}, 45 'pending_aio_sync_ios' => {mib => 'myPendingAIOSyncIOs', order => 23, type => 'Gauge32'}, 46 'pending_buf_pool_flushes' => {mib => 'myPendingBufPoolFlushes', order => 24, type => 'Gauge32'}, 47 'pending_chkp_writes' => {mib => 'myPendingChkpWrites', order => 25, type => 'Gauge32'}, 48 'pending_ibuf_aio_reads' => {mib => 'myPendingIbufAIOReads', order => 26, type => 'Gauge32'}, 49 'pending_log_flushes' => {mib => 'myPendingLogFlushes', order => 27, type => 'Gauge32'}, 50 'pending_log_writes' => {mib => 'myPendingLogWrites', order => 28, type => 'Gauge32'}, 51 'pending_normal_aio_reads' => {mib => 'myPendingNormalAIOReads', order => 29, type => 'Gauge32'}, 52 'pending_normal_aio_writes' => {mib => 'myPendingNormalAIOWrites', order => 30, type => 'Gauge32'}, 53 'ibuf_inserts' => {mib => 'myIbufInserts', order => 31, type => 'Counter32'}, 54 'ibuf_merged' => {mib => 'myIbufMerged', order => 32, type => 'Counter32'}, 55 'ibuf_merges' => {mib => 'myIbufMerges', order => 33, type => 'Counter32'}, 56 'spin_waits' => {mib => 'mySpinWaits', order => 34, type => 'Counter32'}, 57 'spin_rounds' => {mib => 'mySpinRounds', order => 35, type => 'Counter32'}, 58 'os_waits' => {mib => 'myOsWaits', order => 36, type => 'Counter32'}, 59 'rows_inserted' => {mib => 'myRowsInserted', order => 37, type => 'Counter32'}, 60 'rows_updated' => {mib => 'myRowsUpdated', order => 38, type => 'Counter32'}, 61 'rows_deleted' => {mib => 'myRowsDeleted', order => 39, type => 'Counter32'}, 62 'rows_read' => {mib => 'myRowsRead', order => 40, type => 'Counter32'}, 63 'Table_locks_waited' => {mib => 'myTableLocksWaited', order => 41, type => 'Counter32'}, 64 'Table_locks_immediate' => {mib => 'myTableLocksImmediate', order => 42, type => 'Counter32'}, 65 'Slow_queries' => {mib => 'mySlowQueries', order => 43, type => 'Counter32'}, 66 'Open_files' => {mib => 'myOpenFiles', order => 44, type => 'Gauge32'}, 67 'Open_tables' => {mib => 'myOpenTables', order => 45, type => 'Gauge32'}, 68 'Opened_tables' => {mib => 'myOpenedTables', order => 46, type => 'Counter32'}, 69 'innodb_open_files' => {mib => 'myInnodbOpenFiles', order => 47, type => 'Counter32'}, 70 'open_files_limit' => {mib => 'myOpenFilesLimit', order => 48, type => 'Counter32'}, 71 'table_cache' => {mib => 'myTableCache', order => 49, type => 'Counter32'}, 72 'Aborted_clients' => {mib => 'myAbortedClients', order => 50, type => 'Counter32'}, 73 'Aborted_connects' => {mib => 'myAbortedConnects', order => 51, type => 'Counter32'}, 74 'Max_used_connections' => {mib => 'myMaxUsedConnections', order => 52, type => 'Counter32'}, 75 'Slow_launch_threads' => {mib => 'mySlowLaunchThreads', order => 53, type => 'Counter32'}, 76 'Threads_cached' => {mib => 'myThreadsCached', order => 54, type => 'Gauge32'}, 77 'Threads_connected' => {mib => 'myThreadsConnected', order => 55, type => 'Gauge32'}, 78 'Threads_created' => {mib => 'myThreadsCreated', order => 56, type => 'Counter32'}, 79 'Threads_running' => {mib => 'myThreadsRunning', order => 57, type => 'Gauge32'}, 80 'max_connections' => {mib => 'myMaxConnections', order => 58, type => 'Gauge32'}, 81 'thread_cache_size' => {mib => 'myThreadCacheSize', order => 59, type => 'Gauge32'}, 82 'Connections' => {mib => 'myConnections', order => 60, type => 'Counter32'}, 83 'slave_running' => {mib => 'mySlaveRunning', order => 61, type => 'Gauge32'}, 84 'slave_stopped' => {mib => 'mySlaveStopped', order => 62, type => 'Gauge32'}, 85 'Slave_retried_transactions' => {mib => 'mySlaveRetriedTransactions', order => 63, type => 'Counter32'}, 86 'slave_lag' => {mib => 'mySlaveLag', order => 64, type => 'Gauge32'}, 87 'Slave_open_temp_tables' => {mib => 'mySlaveOpenTempTables', order => 65, type => 'Gauge32'}, 88 'Qcache_free_blocks' => {mib => 'myQcacheFreeBlocks', order => 66, type => 'Gauge32'}, 89 'Qcache_free_memory' => {mib => 'myQcacheFreeMemory', order => 67, type => 'Gauge32'}, 90 'Qcache_hits' => {mib => 'myQcacheHits', order => 68, type => 'Counter32'}, 91 'Qcache_inserts' => {mib => 'myQcacheInserts', order => 69, type => 'Counter32'}, 92 'Qcache_lowmem_prunes' => {mib => 'myQcacheLowmemPrunes', order => 70, type => 'Counter32'}, 93 'Qcache_not_cached' => {mib => 'myQcacheNotCached', order => 71, type => 'Counter32'}, 94 'Qcache_queries_in_cache' => {mib => 'myQcacheQueriesInCache', order => 72, type => 'Gauge32'}, 95 'Qcache_total_blocks' => {mib => 'myQcacheTotalBlocks', order => 73, type => 'Gauge32'}, 96 'query_cache_size' => {mib => 'myQueryCacheSize', order => 74, type => 'Counter32'}, 97 'Questions' => {mib => 'myQuestions', order => 75, type => 'Counter32'}, 98 'Com_update' => {mib => 'myComUpdate', order => 76, type => 'Counter32'}, 99 'Com_insert' => {mib => 'myComInsert', order => 77, type => 'Counter32'}, 100 'Com_select' => {mib => 'myComSelect', order => 78, type => 'Counter32'}, 101 'Com_delete' => {mib => 'myComDelete', order => 79, type => 'Counter32'}, 102 'Com_replace' => {mib => 'myComReplace', order => 80, type => 'Counter32'}, 103 'Com_load' => {mib => 'myComLoad', order => 81, type => 'Counter32'}, 104 'Com_update_multi' => {mib => 'myComUpdateMulti', order => 82, type => 'Counter32'}, 105 'Com_insert_select' => {mib => 'myComInsertSelect', order => 83, type => 'Counter32'}, 106 'Com_delete_multi' => {mib => 'myComDeleteMulti', order => 84, type => 'Counter32'}, 107 'Com_replace_select' => {mib => 'myComReplaceSelect', order => 85, type => 'Counter32'}, 108 'Select_full_join' => {mib => 'mySelectFullJoin', order => 86, type => 'Counter32'}, 109 'Select_full_range_join' => {mib => 'mySelectFullRangeJoin', order => 87, type => 'Counter32'}, 110 'Select_range' => {mib => 'mySelectRange', order => 88, type => 'Counter32'}, 111 'Select_range_check' => {mib => 'mySelectRangeCheck', order => 89, type => 'Counter32'}, 112 'Select_scan' => {mib => 'mySelectScan', order => 90, type => 'Counter32'}, 113 'Sort_merge_passes' => {mib => 'mySortMergePasses', order => 91, type => 'Counter32'}, 114 'Sort_range' => {mib => 'mySortRange', order => 92, type => 'Counter32'}, 115 'Sort_rows' => {mib => 'mySortRows', order => 93, type => 'Counter32'}, 116 'Sort_scan' => {mib => 'mySortScan', order => 94, type => 'Counter32'}, 117 'Created_tmp_tables' => {mib => 'myCreatedTmpTables', order => 95, type => 'Counter32'}, 118 'Created_tmp_disk_tables' => {mib => 'myCreatedTmpDiskTables', order => 96, type => 'Counter32'}, 119 'Created_tmp_files' => {mib => 'myCreatedTmpFiles', order => 97, type => 'Counter32'}, 120 'Bytes_sent' => {mib => 'myBytesSent', order => 98, type => 'Counter64'}, 121 'Bytes_received' => {mib => 'myBytesReceived', order => 99, type => 'Counter64'}, 122 'innodb_log_buffer_size' => {mib => 'myInnodbLogBufferSize', order => 100, type => 'Gauge32'}, 123 'unflushed_log' => {mib => 'myUnflushedLog', order => 101, type => 'Gauge32'}, 124 'log_bytes_flushed' => {mib => 'myLogBytesFlushed', order => 102, type => 'Counter64'}, 125 'log_bytes_written' => {mib => 'myLogBytesWritten', order => 103, type => 'Counter64'}, 126 'relay_log_space' => {mib => 'myRelayLogSpace', order => 104, type => 'Counter32'}, 127 'binlog_cache_size' => {mib => 'myBinlogCacheSize', order => 105, type => 'Gauge32'}, 128 'Binlog_cache_disk_use' => {mib => 'myBinlogCacheDiskUse', order => 106, type => 'Counter32'}, 129 'Binlog_cache_use' => {mib => 'myBinlogCacheUse', order => 107, type => 'Counter32'}, 130 'binary_log_space' => {mib => 'myBinaryLogSpace', order => 108, type => 'Counter32'}, 131 'State_closing_tables' => {mib => 'myStateClosingTables', order => 109, type => 'Gauge32'}, 132 'State_copying_to_tmp_table' => {mib => 'myStateCopyingToTmpTable', order => 110, type => 'Gauge32'}, 133 'State_end' => {mib => 'myStateEnd', order => 111, type => 'Gauge32'}, 134 'State_freeing_items' => {mib => 'myStateFreeingItems', order => 112, type => 'Gauge32'}, 135 'State_init' => {mib => 'myStateInit', order => 113, type => 'Gauge32'}, 136 'State_locked' => {mib => 'myStateLocked', order => 114, type => 'Gauge32'}, 137 'State_login' => {mib => 'myStateLogin', order => 115, type => 'Gauge32'}, 138 'State_preparing' => {mib => 'myStatePreparing', order => 116, type => 'Gauge32'}, 139 'State_reading_from_net' => {mib => 'myStateReadingFromNet', order => 117, type => 'Gauge32'}, 140 'State_sending_data' => {mib => 'myStateSendingData', order => 118, type => 'Gauge32'}, 141 'State_sorting_result' => {mib => 'myStateSortingResult', order => 119, type => 'Gauge32'}, 142 'State_statistics' => {mib => 'myStateStatistics', order => 120, type => 'Gauge32'}, 143 'State_updating' => {mib => 'myStateUpdating', order => 121, type => 'Gauge32'}, 144 'State_writing_to_net' => {mib => 'myStateWritingToNet', order => 122, type => 'Gauge32'}, 145 'State_none' => {mib => 'myStateNone', order => 123, type => 'Gauge32'}, 146 'State_other' => {mib => 'myStateOther', order => 124, type => 'Gauge32'}, 147 'additional_pool_alloc' => {mib => 'myAdditionalPoolAlloc', order => 125, type => 'Gauge64'}, 148 'total_mem_alloc' => {mib => 'myTotalMemAlloc', order => 126, type => 'Gauge64'}, 149 'hash_index_cells_total' => {mib => 'myHashIndexCellsTotal', order => 127, type => 'Gauge32'}, 150 'hash_index_cells_used' => {mib => 'myHashIndexCellsUsed', order => 128, type => 'Gauge32'}, 151 'innodb_lock_structs' => {mib => 'myInnoDBLockStructs', order => 129, type => 'Gauge32'}, 152 'innodb_lock_wait_secs' => {mib => 'myInnoDBLockWaitSecs', order => 130, type => 'Gauge32'}, 153 'innodb_tables_in_use' => {mib => 'myInnoDBTablesInUse', order => 131, type => 'Gauge32'}, 154 'innodb_locked_tables' => {mib => 'myInnoDBLockedTables', order => 132, type => 'Gauge32'}, 155 'uncheckpointed_bytes' => {mib => 'myUncheckpointedBytes', order => 133, type => 'Gauge32'}, 156 'ibuf_cell_count' => {mib => 'myIBufCellCount', order => 134, type => 'Gauge32'}, 157 'ibuf_used_cells' => {mib => 'myIBufUsedCells', order => 135, type => 'Gauge32'}, 158 'ibuf_free_cells' => {mib => 'myIBufFreeCells', order => 136, type => 'Gauge32'}, 159 'adaptive_hash_memory' => {mib => 'myAdaptiveHashMemory', order => 137, type => 'Gauge64'}, 160 'page_hash_memory' => {mib => 'myPageHashMemory', order => 138, type => 'Gauge64'}, 161 'dictionary_cache_memory' => {mib => 'myDictionaryCacheMemory', order => 139, type => 'Gauge64'}, 162 'file_system_memory' => {mib => 'myFileSystemMemory', order => 140, type => 'Gauge64'}, 163 'lock_system_memory' => {mib => 'myLockSystemMemory', order => 141, type => 'Gauge64'}, 164 'recovery_system_memory' => {mib => 'myRecoverySystemMemory', order => 142, type => 'Gauge64'}, 165 'thread_hash_memory' => {mib => 'myThreadHashMemory', order => 143, type => 'Gauge64'}, 166 'innodb_sem_waits' => {mib => 'myInnoDBSemWaits', order => 144, type => 'Counter64'}, 167 'innodb_sem_wait_time_ms' => {mib => 'myInnoDBSemWaitTime', order => 145, type => 'Counter64'}, 168 'key_buf_bytes_unflushed' => {mib => 'myKeyBufBytesUnflushed', order => 146, type => 'Gauge64'}, 169 'key_buf_bytes_used' => {mib => 'myKeyBufBytesUsed', order => 147, type => 'Gauge64'}, 170 'key_buffer_size' => {mib => 'myKeyBufferSize', order => 148, type => 'Gauge64'}, 171 'Innodb_row_lock_time' => {mib => 'myInnoDBRowLockTime', order => 149, type => 'Counter64'}, 172 'Innodb_row_lock_waits' => {mib => 'myInnoDBRowLockWaits', order => 150, type => 'Counter64'}, 173 }, 174 startoid => '.1.3.6.1.4.1.20267.200.1', 175} 176