HoneySoftware Home Page

HoneyMonitor - Audit System Specifications

Used Variables


The Audit System included in HoneyMonitor, allows you monitoring your MySQL® Servers and Tuning their performances.

Here's the list of raw and derived variables we use to create our Performance Reports. You can use these variables to create your Customized Report as well.

Conventions used in the column names.

  • Columns whose name start with "g_" contain special values, used internally by our scripts and not related to the Server Performance.
  • Columns whose name start with "s_" contain raw status variables except for variables in the form "s_COM...._per_Second" that are derived variables even if their names start with "s_".
  • Variables whose name start with "v_" are raw system variables.
  • The other variables are derived variables (ratios).

Information included in this document are based onHoneyMonitor vesion: 1.0.15.

 

Contents:

  1. Special Columns
  2. Status Columns
  3. System Columns
  4. Ratio Columns

 
Special Columns
g_id An autoincremental field for the table.
g_timestamp A Timestamp column .
g_server_id Always 1. Column isn't used yet
g_dpm Always 0. Column isn't used yet.

 

Status Columns
s_ABORTED_CLIENTS
s_ABORTED_CONNECTS
s_BINLOG_CACHE_DISK_USE
s_BINLOG_CACHE_USE
s_BYTES_RECEIVED
s_BYTES_SENT
s_COM_ADMIN_COMMANDS
s_COM_ASSIGN_TO_KEYCACHE
s_COM_ALTER_DB
s_COM_ALTER_DB_UPGRADE
s_COM_ALTER_EVENT
s_COM_ALTER_FUNCTION
s_COM_ALTER_PROCEDURE
s_COM_ALTER_SERVER
s_COM_ALTER_TABLE
s_COM_ALTER_TABLESPACE
s_COM_ANALYZE
s_COM_BACKUP_TABLE
s_COM_BEGIN
s_COM_BINLOG
s_COM_CALL_PROCEDURE
s_COM_CHANGE_DB
s_COM_CHANGE_MASTER
s_COM_CHECK
s_COM_CHECKSUM
s_COM_COMMIT
s_COM_CREATE_DB
s_COM_CREATE_EVENT
s_COM_CREATE_FUNCTION
s_COM_CREATE_INDEX
s_COM_CREATE_PROCEDURE
s_COM_CREATE_SERVER
s_COM_CREATE_TABLE
s_COM_CREATE_TRIGGER
s_COM_CREATE_UDF
s_COM_CREATE_USER
s_COM_CREATE_VIEW
s_COM_DEALLOC_SQL
s_COM_DELETE
s_COM_DELETE_MULTI
s_COM_DO
s_COM_DROP_DB
s_COM_DROP_EVENT
s_COM_DROP_FUNCTION
s_COM_DROP_INDEX
s_COM_DROP_PROCEDURE
s_COM_DROP_SERVER
s_COM_DROP_TABLE
s_COM_DROP_TRIGGER
s_COM_DROP_USER
s_COM_DROP_VIEW
s_COM_EMPTY_QUERY
s_COM_EXECUTE_SQL
s_COM_FLUSH
s_COM_GRANT
s_COM_HA_CLOSE
s_COM_HA_OPEN
s_COM_HA_READ
s_COM_HELP
s_COM_INSERT
s_COM_INSERT_SELECT
s_COM_INSTALL_PLUGIN
s_COM_KILL
s_COM_LOAD
s_COM_LOAD_MASTER_DATA
s_COM_LOAD_MASTER_TABLE
s_COM_LOCK_TABLES
s_COM_OPTIMIZE
s_COM_PRELOAD_KEYS
s_COM_PREPARE_SQL
s_COM_PURGE
s_COM_PURGE_BEFORE_DATE
s_COM_RELEASE_SAVEPOINT
s_COM_RENAME_TABLE
s_COM_RENAME_USER
s_COM_REPAIR
s_COM_REPLACE
s_COM_REPLACE_SELECT
s_COM_RESET
s_COM_RESTORE_TABLE
s_COM_REVOKE
s_COM_REVOKE_ALL
s_COM_ROLLBACK
s_COM_ROLLBACK_TO_SAVEPOINT
s_COM_SAVEPOINT
s_COM_SELECT
s_COM_SET_OPTION
s_COM_SHOW_AUTHORS
s_COM_SHOW_BINLOG_EVENTS
s_COM_SHOW_BINLOGS
s_COM_SHOW_CHARSETS
s_COM_SHOW_COLLATIONS
s_COM_SHOW_COLUMN_TYPES
s_COM_SHOW_CONTRIBUTORS
s_COM_SHOW_CREATE_DB
s_COM_SHOW_CREATE_EVENT
s_COM_SHOW_CREATE_FUNC
s_COM_SHOW_CREATE_PROC
s_COM_SHOW_CREATE_TABLE
s_COM_SHOW_CREATE_TRIGGER
s_COM_SHOW_DATABASES
s_COM_SHOW_ENGINE_LOGS
s_COM_SHOW_ENGINE_MUTEX
s_COM_SHOW_ENGINE_STATUS
s_COM_SHOW_EVENTS
s_COM_SHOW_ERRORS
s_COM_SHOW_FIELDS
s_COM_SHOW_FUNCTION_STATUS
s_COM_SHOW_GRANTS
s_COM_SHOW_KEYS
s_COM_SHOW_MASTER_STATUS
s_COM_SHOW_NEW_MASTER
s_COM_SHOW_OPEN_TABLES
s_COM_SHOW_PLUGINS
s_COM_SHOW_PRIVILEGES
s_COM_SHOW_PROCEDURE_STATUS
s_COM_SHOW_PROCESSLIST
s_COM_SHOW_PROFILE
s_COM_SHOW_PROFILES
s_COM_SHOW_SLAVE_HOSTS
s_COM_SHOW_SLAVE_STATUS
s_COM_SHOW_STATUS
s_COM_SHOW_STORAGE_ENGINES
s_COM_SHOW_TABLE_STATUS
s_COM_SHOW_TABLES
s_COM_SHOW_TRIGGERS
s_COM_SHOW_VARIABLES
s_COM_SHOW_WARNINGS
s_COM_SLAVE_START
s_COM_SLAVE_STOP
s_COM_STMT_CLOSE
s_COM_STMT_EXECUTE
s_COM_STMT_FETCH
s_COM_STMT_PREPARE
s_COM_STMT_REPREPARE
s_COM_STMT_RESET
s_COM_STMT_SEND_LONG_DATA
s_COM_TRUNCATE
s_COM_UNINSTALL_PLUGIN
s_COM_UNLOCK_TABLES
s_COM_UPDATE
s_COM_UPDATE_MULTI
s_COM_XA_COMMIT
s_COM_XA_END
s_COM_XA_PREPARE
s_COM_XA_RECOVER
s_COM_XA_ROLLBACK
s_COM_XA_START
s_COMPRESSION
s_CONNECTIONS
s_CREATED_TMP_DISK_TABLES
s_CREATED_TMP_FILES
s_CREATED_TMP_TABLES
s_DELAYED_ERRORS
s_DELAYED_INSERT_THREADS
s_DELAYED_WRITES
s_FLUSH_COMMANDS
s_HANDLER_COMMIT
s_HANDLER_DELETE
s_HANDLER_DISCOVER
s_HANDLER_PREPARE
s_HANDLER_READ_FIRST
s_HANDLER_READ_KEY
s_HANDLER_READ_NEXT
s_HANDLER_READ_PREV
s_HANDLER_READ_RND
s_HANDLER_READ_RND_NEXT
s_HANDLER_ROLLBACK
s_HANDLER_SAVEPOINT
s_HANDLER_SAVEPOINT_ROLLBACK
s_HANDLER_UPDATE
s_HANDLER_WRITE
s_INNODB_BUFFER_POOL_PAGES_DATA
s_INNODB_BUFFER_POOL_PAGES_DIRTY
s_INNODB_BUFFER_POOL_PAGES_FLUSHED
s_INNODB_BUFFER_POOL_PAGES_FREE
s_INNODB_BUFFER_POOL_PAGES_MISC
s_INNODB_BUFFER_POOL_PAGES_TOTAL
s_INNODB_BUFFER_POOL_READ_AHEAD_RND
s_INNODB_BUFFER_POOL_READ_AHEAD_SEQ
s_INNODB_BUFFER_POOL_READ_REQUESTS
s_INNODB_BUFFER_POOL_READS
s_INNODB_BUFFER_POOL_WAIT_FREE
s_INNODB_BUFFER_POOL_WRITE_REQUESTS
s_INNODB_DATA_FSYNCS
s_INNODB_DATA_PENDING_FSYNCS
s_INNODB_DATA_PENDING_READS
s_INNODB_DATA_PENDING_WRITES
s_INNODB_DATA_READ
s_INNODB_DATA_READS
s_INNODB_DATA_WRITES
s_INNODB_DATA_WRITTEN
s_INNODB_DBLWR_PAGES_WRITTEN
s_INNODB_DBLWR_WRITES
s_INNODB_LOG_WAITS
s_INNODB_LOG_WRITE_REQUESTS
s_INNODB_LOG_WRITES
s_INNODB_OS_LOG_FSYNCS
s_INNODB_OS_LOG_PENDING_FSYNCS
s_INNODB_OS_LOG_PENDING_WRITES
s_INNODB_OS_LOG_WRITTEN
s_INNODB_PAGE_SIZE
s_INNODB_PAGES_CREATED
s_INNODB_PAGES_READ
s_INNODB_PAGES_WRITTEN
s_INNODB_ROW_LOCK_CURRENT_WAITS
s_INNODB_ROW_LOCK_TIME
s_INNODB_ROW_LOCK_TIME_AVG
s_INNODB_ROW_LOCK_TIME_MAX
s_INNODB_ROW_LOCK_WAITS
s_INNODB_ROWS_DELETED
s_INNODB_ROWS_INSERTED
s_INNODB_ROWS_READ
s_INNODB_ROWS_UPDATED
s_KEY_BLOCKS_NOT_FLUSHED
s_KEY_BLOCKS_UNUSED
s_KEY_BLOCKS_USED
s_KEY_READ_REQUESTS
s_KEY_READS
s_KEY_WRITE_REQUESTS
s_KEY_WRITES
s_LAST_QUERY_COST
s_MAX_USED_CONNECTIONS
s_NOT_FLUSHED_DELAYED_ROWS
s_OPEN_FILES
s_OPEN_STREAMS
s_OPEN_TABLE_DEFINITIONS
s_OPEN_TABLES
s_OPENED_FILES
s_OPENED_TABLE_DEFINITIONS
s_OPENED_TABLES
s_PREPARED_STMT_COUNT
s_QCACHE_FREE_BLOCKS
s_QCACHE_FREE_MEMORY
s_QCACHE_HITS
s_QCACHE_INSERTS
s_QCACHE_LOWMEM_PRUNES
s_QCACHE_NOT_CACHED
s_QCACHE_QUERIES_IN_CACHE
s_QCACHE_TOTAL_BLOCKS
s_QUESTIONS
s_RPL_STATUS
s_SELECT_FULL_JOIN
s_SELECT_FULL_RANGE_JOIN
s_SELECT_RANGE
s_SELECT_RANGE_CHECK
s_SELECT_SCAN
s_SLAVE_OPEN_TEMP_TABLES
s_SLAVE_RETRIED_TRANSACTIONS
s_SLAVE_RUNNING
s_SLOW_LAUNCH_THREADS
s_SLOW_QUERIES
s_SORT_MERGE_PASSES
s_SORT_RANGE
s_SORT_ROWS
s_SORT_SCAN
s_SSL_ACCEPT_RENEGOTIATES
s_SSL_ACCEPTS
s_SSL_CALLBACK_CACHE_HITS
s_SSL_CIPHER
s_SSL_CIPHER_LIST
s_SSL_CLIENT_CONNECTS
s_SSL_CONNECT_RENEGOTIATES
s_SSL_CTX_VERIFY_DEPTH
s_SSL_CTX_VERIFY_MODE
s_SSL_DEFAULT_TIMEOUT
s_SSL_FINISHED_ACCEPTS
s_SSL_FINISHED_CONNECTS
s_SSL_SESSION_CACHE_HITS
s_SSL_SESSION_CACHE_MISSES
s_SSL_SESSION_CACHE_MODE
s_SSL_SESSION_CACHE_OVERFLOWS
s_SSL_SESSION_CACHE_SIZE
s_SSL_SESSION_CACHE_TIMEOUTS
s_SSL_SESSIONS_REUSED
s_SSL_USED_SESSION_CACHE_ENTRIES
s_SSL_VERIFY_DEPTH
s_SSL_VERIFY_MODE
s_SSL_VERSION
s_TABLE_LOCKS_IMMEDIATE
s_TABLE_LOCKS_WAITED
s_TC_LOG_MAX_PAGES_USED
s_TC_LOG_PAGE_SIZE
s_TC_LOG_PAGE_WAITS
s_THREADS_CACHED
s_THREADS_CONNECTED
s_THREADS_CREATED
s_THREADS_RUNNING
s_UPTIME

 

System Columns
v_BACK_LOG
v_CHARACTER_SETS_DIR
v_FT_MAX_WORD_LEN
v_FT_MIN_WORD_LEN
v_FT_QUERY_EXPANSION_LIMIT
v_FT_STOPWORD_FILE
v_INIT_FILE
v_LANGUAGE
v_LARGE_FILES_SUPPORT
v_LARGE_PAGE_SIZE
v_LARGE_PAGES
v_LOG_BIN
v_LOG_ERROR
v_LOWER_CASE_FILE_SYSTEM
v_LOWER_CASE_TABLE_NAMES
v_MYISAM_RECOVER_OPTIONS
v_NAMED_PIPE
v_OPEN_FILES_LIMIT
v_PID_FILE
v_PLUGIN_DIR
v_PORT
v_PROTOCOL_VERSION
v_SHARED_MEMORY
v_SHARED_MEMORY_BASE_NAME
v_SKIP_EXTERNAL_LOCKING
v_SKIP_NETWORKING
v_SKIP_SHOW_DATABASE
v_THREAD_STACK
v_LOG_SLAVE_UPDATES
v_RELAY_LOG
v_RELAY_LOG_INDEX
v_RELAY_LOG_INFO_FILE
v_RELAY_LOG_SPACE_LIMIT
v_SLAVE_LOAD_TMPDIR
v_SLAVE_SKIP_ERRORS
v_LICENSE
v_MAX_ERROR_COUNT
v_HAVE_CRYPT
v_NET_BUFFER_LENGTH
v_MYISAM_REPAIR_THREADS
v_AUTOMATIC_SP_PRIVILEGES
v_OPTIMIZER_PRUNE_LEVEL
v_CHARACTER_SET_CONNECTION
v_LOG_BIN_TRUST_FUNCTION_CREATORS
v_OLD_PASSWORDS
v_FT_BOOLEAN_SYNTAX
v_SQL_BIG_SELECTS
v_HAVE_OPENSSL
v_CHARACTER_SET_RESULTS
v_LOG_BIN_TRUST_ROUTINE_CREATORS
v_MAX_RELAY_LOG_SIZE
v_SORT_BUFFER_SIZE
v_BINLOG_CACHE_SIZE
v_IDENTITY
v_COLLATION_DATABASE
v_UPDATABLE_VIEWS_WITH_LIMIT
v_COMPLETION_TYPE
v_SLOW_LAUNCH_TIME
v_CONNECT_TIMEOUT
v_INNODB_LOCK_WAIT_TIMEOUT
v_HAVE_RTREE_KEYS
v_SQL_SAFE_UPDATES
v_SQL_MAX_JOIN_SIZE
v_SQL_QUOTE_SHOW_CREATE
v_DELAYED_QUEUE_SIZE
v_SQL_LOG_UPDATE
v_DELAYED_INSERT_TIMEOUT
v_WAIT_TIMEOUT
v_FLUSH_TIME
v_TABLE_LOCK_WAIT_TIMEOUT
v_INTERACTIVE_TIMEOUT
v_QUERY_PREALLOC_SIZE
v_PSEUDO_THREAD_ID
v_REPORT_HOST
v_CHARACTER_SET_DATABASE
v_SSL_KEY
v_QUERY_CACHE_WLOCK_INVALIDATE
v_SSL_CIPHER
v_FLUSH
v_HAVE_GEOMETRY
v_JOIN_BUFFER_SIZE
v_INSERT_ID
v_MAX_BINLOG_SIZE
v_RELAY_LOG_PURGE
v_INIT_SLAVE
v_LOG_WARNINGS
v_MAX_CONNECT_ERRORS
v_GROUP_CONCAT_MAX_LEN
v_SLAVE_EXEC_MODE
v_INNODB_LOG_BUFFER_SIZE
v_MAX_CONNECTIONS
v_INNODB_LOCKS_UNSAFE_FOR_BINLOG
v_SQL_MODE
v_INNODB_MAX_PURGE_LAG
v_TIMED_MUTEXES
v_TRANSACTION_PREALLOC_SIZE
v_MAX_SEEKS_FOR_KEY
v_VERSION_COMPILE_OS
v_MAX_PREPARED_STMT_COUNT
v_SQL_NOTES
v_EVENT_SCHEDULER
v_LOW_PRIORITY_UPDATES
v_LOG_QUERIES_NOT_USING_INDEXES
v_REPORT_PASSWORD
v_DELAYED_INSERT_LIMIT
v_MAX_INSERT_DELAYED_THREADS
v_CHARACTER_SET_SERVER
v_HAVE_COMPRESS
v_MAX_LENGTH_FOR_SORT_DATA
v_TRANSACTION_ALLOC_BLOCK_SIZE
v_MAX_HEAP_TABLE_SIZE
v_THREAD_CACHE_SIZE
v_READ_RND_BUFFER_SIZE
v_INNODB_DOUBLEWRITE
v_KEY_CACHE_AGE_THRESHOLD
v_BIG_TABLES
v_NET_RETRY_COUNT
v_DEFAULT_WEEK_FORMAT
v_REPORT_USER
v_LOG_OUTPUT
v_OLD_ALTER_TABLE
v_MYISAM_USE_MMAP
v_LONG_QUERY_TIME
v_INNODB_CHECKSUMS
v_MAX_DELAYED_THREADS
v_HAVE_SYMLINK
v_MAX_USER_CONNECTIONS
v_TIME_ZONE
v_HAVE_INNODB
v_INNODB_TABLE_LOCKS
v_READ_BUFFER_SIZE
v_INNODB_AUTOEXTEND_INCREMENT
v_MYISAM_MAX_SORT_FILE_SIZE
v_MYISAM_DATA_POINTER_SIZE
v_NET_WRITE_TIMEOUT
v_INNODB_THREAD_SLEEP_DELAY
v_WARNING_COUNT
v_SQL_AUTO_IS_NULL
v_MIN_EXAMINED_ROW_LIMIT
v_INNODB_BUFFER_POOL_SIZE
v_QUERY_CACHE_LIMIT
v_LOCAL_INFILE
v_VERSION_COMMENT
v_GENERAL_LOG
v_QUERY_CACHE_SIZE
v_TABLE_TYPE
v_CHARACTER_SET_CLIENT
v_QUERY_CACHE_MIN_RES_UNIT
v_BINLOG_FORMAT
v_SQL_WARNINGS
v_MYISAM_SORT_BUFFER_SIZE
v_INNODB_ROLLBACK_ON_TIMEOUT
v_SSL_CERT
v_TIMESTAMP
v_SYNC_FRM
v_INNODB_ADDITIONAL_MEM_POOL_SIZE
v_QUERY_ALLOC_BLOCK_SIZE
v_DATETIME_FORMAT
v_QUERY_CACHE_TYPE
v_INNODB_FLUSH_LOG_AT_TRX_COMMIT
v_SQL_LOW_PRIORITY_UPDATES
v_INNODB_FILE_IO_THREADS
v_THREAD_HANDLING
v_SQL_SELECT_LIMIT
v_NET_READ_TIMEOUT
v_DATE_FORMAT
v_COLLATION_SERVER
v_READ_ONLY
v_MYISAM_STATS_METHOD
v_RAND_SEED1
v_SYSTEM_TIME_ZONE
v_INNODB_DATA_FILE_PATH
v_NEW
v_MAX_WRITE_LOCK_COUNT
v_HOSTNAME
v_INIT_CONNECT
v_HAVE_CSV
v_CHARACTER_SET_SYSTEM
v_SERVER_ID
v_KEY_CACHE_DIVISION_LIMIT
v_MAX_ALLOWED_PACKET
v_GENERAL_LOG_FILE
v_AUTOCOMMIT
v_BULK_INSERT_BUFFER_SIZE
v_RPL_RECOVERY_RANK
v_AUTO_INCREMENT_INCREMENT
v_VERSION_COMPILE_MACHINE
v_TMPDIR
v_TABLE_DEFINITION_CACHE
v_EXPIRE_LOGS_DAYS
v_BASEDIR
v_HAVE_PARTITIONING
v_CHARACTER_SET_FILESYSTEM
v_FOREIGN_KEY_CHECKS
v_SECURE_AUTH
v_TMP_TABLE_SIZE
v_ENGINE_CONDITION_PUSHDOWN
v_INNODB_AUTOINC_LOCK_MODE
v_LAST_INSERT_ID
v_INNODB_COMMIT_CONCURRENCY
v_SQL_BIG_TABLES
v_INNODB_MIRRORED_LOG_GROUPS
v_SLAVE_COMPRESSED_PROTOCOL
v_UNIQUE_CHECKS
v_MAX_SP_RECURSION_DEPTH
v_VERSION
v_SLAVE_TRANSACTION_RETRIES
v_INNODB_SUPPORT_XA
v_DELAY_KEY_WRITE
v_INNODB_SYNC_SPIN_LOOPS
v_CONCURRENT_INSERT
v_COLLATION_CONNECTION
v_KEEP_FILES_ON_CREATE
v_HAVE_QUERY_CACHE
v_SSL_CAPATH
v_INNODB_ADAPTIVE_HASH_INDEX
v_TABLE_OPEN_CACHE
v_SECURE_FILE_PRIV
v_HAVE_COMMUNITY_FEATURES
v_DIV_PRECISION_INCREMENT
v_REPORT_PORT
v_DATADIR
v_SQL_BUFFER_RESULT
v_INNODB_DATA_HOME_DIR
v_KEY_CACHE_BLOCK_SIZE
v_SQL_LOG_BIN
v_LC_TIME_NAMES
v_SQL_SLAVE_SKIP_COUNTER
v_PRELOAD_BUFFER_SIZE
v_TIME_FORMAT
v_LOG
v_INNODB_FORCE_RECOVERY
v_TX_ISOLATION
v_INNODB_LOG_FILES_IN_GROUP
v_SLOW_QUERY_LOG_FILE
v_ERROR_COUNT
v_LOG_SLOW_QUERIES
v_HAVE_DYNAMIC_LOADING
v_MAX_TMP_TABLES
v_SYNC_BINLOG
v_SQL_LOG_OFF
v_AUTO_INCREMENT_OFFSET
v_INNODB_FILE_PER_TABLE
v_INNODB_OPEN_FILES
v_MULTI_RANGE_COUNT
v_OLD
v_SLOW_QUERY_LOG
v_INNODB_MAX_DIRTY_PAGES_PCT
v_INNODB_FLUSH_METHOD
v_OPTIMIZER_SEARCH_DEPTH
v_RANGE_ALLOC_BLOCK_SIZE
v_KEY_BUFFER_SIZE
v_STORAGE_ENGINE
v_HAVE_NDBCLUSTER
v_HAVE_SSL
v_INNODB_LOG_FILE_SIZE
v_INNODB_CONCURRENCY_TICKETS
v_INNODB_LOG_GROUP_HOME_DIR
v_MAX_JOIN_SIZE
v_INNODB_FAST_SHUTDOWN
v_MAX_SORT_LENGTH
v_SSL_CA
v_RAND_SEED2
v_INNODB_THREAD_CONCURRENCY
v_MAX_BINLOG_CACHE_SIZE
v_SLAVE_NET_TIMEOUT

 

Ratio Columns
Falcon_Cache_Hit_Ratio
Maria_Page_Cache_Hit_Ratio
Maria_Page_Cache-Size_Pseudo_Efficiency
Maria_Key_Buffer_Blocks_Numb
Max_Maria_Page_Cache_Used
Current_Maria_Page_Cache_Usage
Maria_Page_Cache_Write_Ratio
InnoDB_Rows_Read_per_Second
InnoDB_Rows_Inserted_per_Second
InnoDB_Rows_Updated_per_Second
InnoDB_Rows_Deleted_per_Second
InnoDB_Pages_Created_per_Second
InnoDB_Pages_Read_per_Second
InnoDB_Pages_Written_per_Second
InnoDB_Data_Reads_per_Second
InnoDB_Data_Writes_per_Second
InnoDB_Data_Fsyncs_per_Second
InnoDB_Data_Pending_Reads_per_Second
InnoDB_Data_Pending_Writes_per_Second
InnoDB_Data_Pending_Fsyncs_per_Second
InnoDB_Buffer_Pool_Read_Requests_per_Second
InnoDB_Buffer_Pool_Reads_per_Second
InnoDB_Buffer_Pool_Read_Ahaed_Rnd_per_Second
InnoDB_Buffer_Pool_Read_Ahaed_Seq_per_Second
InnoDB_Buffer_Pool_Write_Requests_per_Second
InnoDB_Buffer_Pool_Pages_Flushed_per_Second
InnoDB_Row_Lock_Waits_per_Second
InnoDB_Buffer_Pool_Hit_Ratio
InnoDB_Page_Cache_Free
InnoDB_Page_Cache_Usage
InnoDB_Buffer_Pool_Pages_Free
InnoDB_Buffer_Pool_Pages_Free_per_Total
InnoDB_Buffer_Pool_Pages_Data
InnoDB_Buffer_Pool_Pages_Data_per_Total
InnoDB_Buffer_Pool_Pages_Dirty
InnoDB_Buffer_Pool_Pages_Dirty_per_Data
InnoDB_Buffer_Pool_Pages_Clean
InnoDB_Buffer_Pool_Pages_Clean_per_Data
InnoDB_Buffer_Pool_Pages_Misc
InnoDB_Buffer_Pool_Pages_Misc_per_Total
InnoDB_Buffer_Pool_Pages_Latched
InnoDB_Buffer_Pool_Pages_Latched_per_Total
MyISAM_Key_Buffer_Hit_Ratio
MyISAM_Lock_Contention
MyISAM_Cache-Size_Pseudo_Efficiency
Key_Buffer_Blocks_Numb
Max_MyISAM_Key_Buffer_Used
Current_MyISAM_Key_Buffer_Usage
MyISAM_Key_Write_Ratio
Aborted_Clients_per_Second
Aborted_Clients_per_Connection
Aborted_Connects_per_Second
Aborted_Connects_per_Connection
Bytes_Received_per_Second
Bytes_Received_per_Connection
Bytes_Sent_per_Second
Bytes_Sent_per_Connection
Sort_Scan_per_Second
Sort_Range_per_Second
Sort_Merge-Passes_per_Second
Sort_Rows_per_Second
Select_Scan_per_Second
Select_Scan_per_Select
Select_Range_per_Second
Select_Range_per_Select
Select_Full-Join_per_Second
Select_Full-Join_per_Select
Select_Range-Check_per_Second
Select_Range-Check_per_Select
Select_Full-Range-Join_per_Second
Select_Full-Range-Join_per_Select
Slow_Queries_per_Second
Slow_Threads_per_Second
Query_Cache_Hit_Ratio
Query_Cache_Hits_per_Query_Cache_Inserts
Query_Cache_Low-Memory_Prunes_per_Second
Query_Cache_Utilization
Query_Cache_Memory_Fragmentation
Query_Cache_Inserts_per_Query_Cache_Low-Memory_Prunes
Temporary_Table_Ratio
Temporary_In-Memory_Table_per_Second
Temporary_Disk_Table_per_Second
Temporary_Files_per_Second
Read_Write_Ratio
Average_Table_Scan_Hit_Ratio
s_COM_ADMIN_COMMANDS_per_Second
s_COM_ALTER_DB_per_Second
s_COM_ALTER_EVENT_per_Second
s_COM_ALTER_TABLE_per_Second
s_COM_ANALYZE_per_Second
s_COM_BEGIN_per_Second
s_COM_CALL_PROCEDURE_per_Second
s_COM_CHANGE_DB_per_Second
s_COM_CHANGE_MASTER_per_Second
s_COM_CHECK_per_Second
s_COM_CHECKSUM_per_Second
s_COM_COMMIT_per_Second
s_COM_CREATE_DB_per_Second
s_COM_CREATE_EVENT_per_Second
s_COM_CREATE_FUNCTION_per_Second
s_COM_CREATE_INDEX_per_Second
s_COM_CREATE_TABLE_per_Second
s_COM_CREATE_USER_per_Second
s_COM_DEALLOC_SQL_per_Second
s_COM_DELETE_per_Second
s_COM_DELETE_MULTI_per_Second
s_COM_DO_per_Second
s_COM_DROP_DB_per_Second
s_COM_DROP_EVENT_per_Second
s_COM_DROP_FUNCTION_per_Second
s_COM_DROP_INDEX_per_Second
s_COM_DROP_TABLE_per_Second
s_COM_DROP_USER_per_Second
s_COM_EXECUTE_SQL_per_Second
s_COM_FLUSH_per_Second
s_COM_GRANT_per_Second
s_COM_HA_CLOSE_per_Second
s_COM_HA_OPEN_per_Second
s_COM_HA_READ_per_Second
s_COM_HELP_per_Second
s_COM_INSERT_per_Second
s_COM_INSERT_SELECT_per_Second
s_COM_KILL_per_Second
s_COM_LOAD_per_Second
s_COM_LOCK_TABLES_per_Second
s_COM_OPTIMIZE_per_Second
s_COM_PRELOAD_KEYS_per_Second
s_COM_PREPARE_SQL_per_Second
s_COM_PURGE_per_Second
s_COM_PURGE_BEFORE_DATE_per_Second
s_COM_RENAME_TABLE_per_Second
s_COM_REPAIR_per_Second
s_COM_REPLACE_per_Second
s_COM_REPLACE_SELECT_per_Second
s_COM_RESET_per_Second
s_COM_REVOKE_per_Second
s_COM_REVOKE_ALL_per_Second
s_COM_ROLLBACK_per_Second
s_COM_SAVEPOINT_per_Second
s_COM_SELECT_per_Second
s_COM_SET_OPTION_per_Second
s_COM_SHOW_BINLOG_EVENTS_per_Second
s_COM_SHOW_BINLOGS_per_Second
s_COM_SHOW_CHARSETS_per_Second
s_COM_SHOW_COLLATIONS_per_Second
s_COM_SHOW_COLUMN_TYPES_per_Second
s_COM_SHOW_CREATE_DB_per_Second
s_COM_SHOW_CREATE_EVENT_per_Second
s_COM_SHOW_CREATE_TABLE_per_Second
s_COM_SHOW_DATABASES_per_Second
s_COM_SHOW_ENGINE_LOGS_per_Second
s_COM_SHOW_ENGINE_MUTEX_per_Second
s_COM_SHOW_ENGINE_STATUS_per_Second
s_COM_SHOW_ERRORS_per_Second
s_COM_SHOW_EVENTS_per_Second
s_COM_SHOW_FIELDS_per_Second
s_COM_SHOW_GRANTS_per_Second
s_COM_SHOW_KEYS_per_Second
s_COM_SHOW_MASTER_STATUS_per_Second
s_COM_SHOW_NEW_MASTER_per_Second
s_COM_SHOW_OPEN_TABLES_per_Second
s_COM_SHOW_PLUGINS_per_Second
s_COM_SHOW_PRIVILEGES_per_Second
s_COM_SHOW_PROCESSLIST_per_Second
s_COM_SHOW_SLAVE_HOSTS_per_Second
s_COM_SHOW_SLAVE_STATUS_per_Second
s_COM_SHOW_STATUS_per_Second
s_COM_SHOW_STORAGE_ENGINES_per_Second
s_COM_SHOW_TABLES_per_Second
s_COM_SHOW_TRIGGERS_per_Second
s_COM_SHOW_VARIABLES_per_Second
s_COM_SHOW_WARNINGS_per_Second
s_COM_SLAVE_START_per_Second
s_COM_SLAVE_STOP_per_Second
s_COM_STMT_CLOSE_per_Second
s_COM_STMT_EXECUTE_per_Second
s_COM_STMT_FETCH_per_Second
s_COM_STMT_PREPARE_per_Second
s_COM_STMT_RESET_per_Second
s_COM_STMT_SEND_LONG_DATA_per_Second
s_COM_TRUNCATE_per_Second
s_COM_UNLOCK_TABLES_per_Second
s_COM_UPDATE_per_Second
s_COM_UPDATE_MULTI_per_Second
s_COM_XA_COMMIT_per_Second
s_COM_XA_END_per_Second
s_COM_XA_PREPARE_per_Second
s_COM_XA_RECOVER_per_Second
s_COM_XA_ROLLBACK_per_Second
s_COM_XA_START_per_Second
s_FLUSH_COMMANDS_per_Second
s_PREPARED_STMT_COUNT_per_Second
Maximum_Connection_Utilization
Connection_Utilization
Connection_Attempts_per_Second
Threads_per_Second
Thread_Cache_Miss_Rate
Thread_Cache_Efficiency
Thread_Cache_Utilization
Opened_Tables_per_Second
Tables_Cache_Utilization
XACommits_per_Second
XARollbacks_per_XACommit
Average_XA_Transaction_Size
Inserts_per_XACommit
Commits_per_Second
Rollbacks_per_Commit
Average_Transaction_Size
Inserts_per_Commit
Question_per_Second
Queries_per_Second
Selects_per_Second
Inserts_per_Second
Updates_per_Second
Deletes_per_Second
Replaces_per_Second
Question_per_Connection
Queries_per_Connection
Selects_per_Connection
Inserts_per_Connection
Updates_per_Connection
Deletes_per_Connection
Replaces_per_Connection
Binlog_Cache_Contention
 

HoneySoftware HoneyMonitor is protected by Copyright law and international treaties. The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use. Please refer to HoneySoftware End User License Agreement for further details. Unauthorized use, reproduction or distribution of this program, or any portion of it, may result in severe civil and criminal penalties, and will be prosecuted to the maximum extent possible under the law.

Copyright © 2007 - 2008 HoneySoftware - All rights reserved. HoneySoftware, the HoneySoftware logos, HoneyMonitor and the HoneyMonitor logo may be registered trademarks of HoneySoftware in Italy and other countries. MySQL is registered trademark of MySQL AB in the United States, in Europe and other countries.

www.honeysoftware.com