I am running a fairly large Innodb database on mysql 5.x and would like to know what would be the best variables to monitor (for Nagios)- for instance: threads connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow queries etc....
Aborted_clients Aborted_connects Binlog_cache_disk_use Binlog_cache_use Bytes_received Bytes_sent Com_admin_commands Com_alter_db Com_alter_table Com_analyze Com_backup_table Com_begin Com_change_db Com_change_master Com_check Com_checksum Com_commit Com_create_db Com_create_function Com_create_index Com_create_table Com_dealloc_sql Com_delete Com_delete_multi Com_do Com_drop_db Com_drop_function Com_drop_index Com_drop_table Com_drop_user Com_execute_sql Com_flush Com_grant Com_ha_close Com_ha_open Com_ha_read Com_help Com_insert Com_insert_select Com_kill Com_load Com_load_master_data Com_load_master_table Com_lock_tables Com_optimize Com_preload_keys Com_prepare_sql Com_purge Com_purge_before_date Com_rename_table Com_repair Com_replace Com_replace_select Com_reset Com_restore_table Com_revoke Com_revoke_all Com_rollback Com_savepoint Com_select Com_set_option Com_show_binlog_events Com_show_binlogs Com_show_charsets Com_show_collations Com_show_column_types Com_show_create_db Com_show_create_table Com_show_databases Com_show_errors Com_show_fields Com_show_grants Com_show_innodb_status Com_show_keys Com_show_logs Com_show_master_status Com_show_ndb_status Com_show_new_master Com_show_open_tables Com_show_privileges Com_show_processlist Com_show_slave_hosts Com_show_slave_status Com_show_status Com_show_storage_engines Com_show_tables Com_show_triggers Com_show_variables Com_show_warnings Com_slave_start Com_slave_stop Com_stmt_close Com_stmt_execute Com_stmt_fetch Com_stmt_prepare Com_stmt_reset Com_stmt_send_long_data Com_truncate Com_unlock_tables Com_update Com_update_multi Com_xa_commit Com_xa_end Com_xa_prepare Com_xa_recover Com_xa_rollback Com_xa_start Compression Connections Created_tmp_disk_tables Created_tmp_files Created_tmp_tables Delayed_errors Delayed_insert_threads Delayed_writes Flush_commands Handler_commit Handler_delete Handler_discover Handler_prepare Handler_read_first Handler_read_key Handler_read_next Handler_read_prev Handler_read_rnd Handler_read_rnd_next Handler_rollback Handler_savepoint Handler_savepoint_rollback Handler_update Handler_write Innodb_buffer_pool_pages_data Innodb_buffer_pool_pages_dirty Innodb_buffer_pool_pages_flushed Innodb_buffer_pool_pages_free Innodb_buffer_pool_pages_latched Innodb_buffer_pool_pages_misc Innodb_buffer_pool_pages_total Innodb_buffer_pool_read_ahead_rnd Innodb_buffer_pool_read_ahead_seq Innodb_buffer_pool_read_requests Innodb_buffer_pool_reads Innodb_buffer_pool_wait_free Innodb_buffer_pool_write_requests Innodb_data_fsyncs Innodb_data_pending_fsyncs Innodb_data_pending_reads Innodb_data_pending_writes Innodb_data_read Innodb_data_reads Innodb_data_writes Innodb_data_written Innodb_dblwr_pages_written Innodb_dblwr_writes Innodb_log_waits Innodb_log_write_requests Innodb_log_writes Innodb_os_log_fsyncs Innodb_os_log_pending_fsyncs Innodb_os_log_pending_writes Innodb_os_log_written Innodb_page_size Innodb_pages_created Innodb_pages_read Innodb_pages_written Innodb_row_lock_current_waits Innodb_row_lock_time Innodb_row_lock_time_avg Innodb_row_lock_time_max Innodb_row_lock_waits Innodb_rows_deleted Innodb_rows_inserted Innodb_rows_read Innodb_rows_updated Key_blocks_not_flushed Key_blocks_unused Key_blocks_used Key_read_requests Key_reads Key_write_requests Key_writes Last_query_cost Max_used_connections Not_flushed_delayed_rows Open_files Open_streams Open_tables Opened_tables Qcache_free_blocks Qcache_free_memory Qcache_hits Qcache_inserts Qcache_lowmem_prunes Qcache_not_cached Qcache_queries_in_cache Qcache_total_blocks Questions Rpl_status Select_full_join Select_full_range_join Select_range Select_range_check Select_scan Slave_open_temp_tables Slave_retried_transactions Slave_running Slow_launch_threads Slow_queries Sort_merge_passes Sort_range Sort_rows Sort_scan Ssl_accept_renegotiates Ssl_accepts Ssl_callback_cache_hits Ssl_cipher Ssl_cipher_list Ssl_client_connects Ssl_connect_renegotiates Ssl_ctx_verify_depth Ssl_ctx_verify_mode Ssl_default_timeout Ssl_finished_accepts Ssl_finished_connects Ssl_session_cache_hits Ssl_session_cache_misses Ssl_session_cache_mode Ssl_session_cache_overflows Ssl_session_cache_size Ssl_session_cache_timeouts Ssl_sessions_reused Ssl_used_session_cache_entries Ssl_verify_depth Ssl_verify_mode Ssl_version Table_locks_immediate Table_locks_waited Tc_log_max_pages_used Tc_log_page_size Tc_log_page_waits Threads_cached Threads_connected Threads_created Threads_running Uptime John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475
