Mysql monitoring checkpoints using Nimsoft

9:05 PM

Compiled in the table below is the list of MySQL probe checkpoints(monitors) using Nimsoft. This will help by acting a reference point as to what we can monitor in terms of what we can use for alerts & what for informational & advisory recommendation and information about MySQL status information useful in the graphs obtained as a result of enabling it in QOS(quality of service) setting in probe.
CHECKPOINTS
DESCRIPTION
ACTIVE
QOS
AvailableAble to make a connectionyesyes
number_of_databasesNumber of databasesnono
bytes_sentThe number of bytes sent from all clientsnono
bytes_receivedThe number of bytes received from all clientsnono
max_per_thread_memoryConfigured max memory per thread buffersnono
max_shared_buffersConfigured max shared buffersnono
tot_memory_configuredTotal memory configuredyesyes
connections_attemptedNumber of connection attemptsyesno
connections_successfulNumber of successful connections madenono
connections_refusedNumber of refused connectionsnono
connection_refusal_ratePercentage of connections refusedyesyes
connections_abortedConnections that were established successfully but got aborted abruptly.nono
connections_countCurrent number of open connectionsyesno
connection_usage_ratePercentage of maximum allowed connections in useyesyes
running_threadsCurrent number of running threadsyesyes
peak_open_connectionsHighest number of concurrent open connections since last restartyesyes
connection_peak_usage_rateHighest percentage of maximum allowed connections since last restartyesyes
myisam_cache_usage_ratePercentage of cache in useyesyes
myisam_read_requestsNumber of key block read requestsnono
myisam_reads_from_diskNumber of key blocks read from disknono
myisam_cache_hit_ratePercentage of reads from cache instead of from disknono
myisam_write_requestsNumber of key block write requestsnono
myisam_writes_to_diskNumber of key block writes to disknono
myisam_total_disk_write_ratioRatio of disk writes to all write requestsnono
innodb_cache_usage_ratePercentage of cache in useyesyes
innodb_cache_hit_ratePercentage of reads from cache instead of from diskyesyes
innodb_cache_write_waits_ratePercentage of write requests which had to waityesyes
innodb_latched_pagesNumber of latched pages in cachenono
table_locks_acquired_immediatelyTable locks acquired immediatelynono
table_lock_waitsTable lock waitsyesyes
table_lock_contention_ratePercentage of lock requests that had to be waitedyesyes
innodb_lock_waitsThe number of row locks currently being waitedyesyes
innodb_avg_wait_timeAverage wait time for a row locknono
innodb_log_waits_ratePercentage of cache writes that had to waityesyes
innodb_total_size_cache_size_rateInnoDB cache size as a percentage of the total size of all log filesnono
thread_cache_number_of_threadsCurrent number of threads cachednono
thread_cache_threads_created_conNumber of threads created to handle connectionsnono
thread_cache_hit_ratePercentage of threads re-used from cacheyesyes
cache_tables_openNumber of open tablesnono
table_cache_ratePercentage of open tables that are in cacheyesyes
table_cache_missesNumber of tables opened not in cachenono
query_cache_usage_ratePercentage of cache in useyesyes
queries_in_cacheThe number of queries registered in the query cachenono
queries_not_cachedThe number of non-cached queries (not cache able, or not cached due to the cache type)nono
queries_inserted_cacheThe number of queries added to the query cachenono
query_cache_hitsThe number of query cache hitsyesyes
queries_pruned_from_cacheNumber of queries that were inserted into the query cache, but subsequently got prunednono
query_cache_pruned_inserts_ratioRatio of pruned queries to total insertedyesyes
query_cache_hit_rateCache hit rateyesyes
temp_tables_createdNumber of temporary tables created in memorynono
temp_tables_created_on_diskNumber of temporary tables created on disknono
temp_tables_disk_total_ratioPercentage of temp tables created on diskyesyes
slow_launch_threadsNumber of slow launch threadsnono
slow_queries_enabledSlow Queries Enablednono
slow_queries_min_timeMin time for a query to be considered slownono
slow_queries_noNumber of slow queriesnono
sort_buffers_rangeNumber of sorts done using rangesyesyes
sort_buffers_scanNumber of sorts that were done by scanning the tableyesyes
sort_buffers_temp_filesTemporary files created because of insufficient sort buffer sizenono
full_table_scan_ratePercentage of rows that were accessed via full table scanyesyes
full_table_scan_selects_requiringNumber of times a full table was read for a SELECTnono
full_table_scan_for_joinsThe number of joins that perform table scans because they do not use indexesyesyes
stmts_allTotal number of statements that all clients have sent to the servernono
stmts_select_percentPercentage of SELECTs out of all statementsnono
stmts_insert_percentPercentage of INSERTs out of all statementsnono
stmts_update_percentPercentage of UPDATEs out of all statementsnono
stmts_delete_percentPercentage of DELETEs out of all statementsnono
stmts_commitsNumber of transaction commitsnono
stmts_rollback_commit_ratioRollback to commit rationono
rep_slave_runningState of Replicationyesno
rep_io_runningWhether the I/O thread is started and has connected successfully to the masteryesno
rep_seconds_behind_masterTime difference in seconds between the slave SQL thread and the slave I/O threadyesno
last_errnoThe error number returned by the most recently executed queryyesno
rep_slave_open_temp_tablesThe number of temporary tables that the Slave SQL thread currently has opennono
rep_master_log_read_positionThe position up to which the I/O thread has read in the current master binary lognono
rep_slave_retried_transactionsThe total number of times since startup that the replication slave SQL thread has retried transactionsyesno
rep_slave_sql_runningWhether the SQL thread is startedyesno
rep_relay_master_log_file_positionThe position of the last event executed by the SQL thread from the master's binary lognono
rep_relay_log_file_positionThe position up to which the SQL thread has read and executed in the current relay lognono
bin_log_transactions_used_cacheTotal number of transactions that used the binary log cachenono
bin_log_transactions_saved_in_temp_fileNumber of transactions that used a temporary filenono
table_size_ratioPercent of free space in a tableyesyes

You Might Also Like

0 comments

Contact Form

Name

Email *

Message *

Translate

Wikipedia

Search results