bend chen
2011-10-26 03:40:58 UTC
bend chen [http://community.zenoss.org/people/bend] created the discussion
"mysql monitor no graph data"
To view the discussion, visit: http://community.zenoss.org/message/62177#62177
--------------------------------------------------------------
HI, zenoss user.
I test zenoss 3.2.0 to monitor mysql .use MySqlMonitor Zenpack.
zenpack --list|grep -i mysql
ZenPacks.community.MySQLSSH (/opt/zenoss/ZenPacks/ZenPacks.community.MySQLSSH-0.4-py2.6.egg)
ZenPacks.zenoss.MySqlMonitor (/opt/zenoss/ZenPacks/ZenPacks.zenoss.MySqlMonitor-2.1.3-py2.6.egg)
I fllowing http://community.zenoss.org/docs/DOC-9849 http://community.zenoss.org/docs/DOC-9849 set my mysql monitor,
and no any error event.
but in "Graphs", any mysql graphs not have data.
Loading Image...
(Loading Image...
)
I run monitor command: check_mysql_stats.py --host 172.18.X.X -p 3306 -u zenoss -w zenoss -g Â
output this:
[***@centos5 libexec]$ ./check_mysql_stats.py --host 172.18.X.X -p 3306 -u zenoss -w zenoss -g
STATUS OK|Aborted_clients=1 Aborted_connects=29 Binlog_cache_disk_use=0 Binlog_cache_use=0 Binlog_stmt_cache_disk_use=0 Binlog_stmt_cache_use=0 Bytes_received=75477698 Bytes_sent=147079990 Com_admin_commands=6020 Com_assign_to_keycache=0 Com_alter_db=0 Com_alter_db_upgrade=0 Com_alter_event=0 Com_alter_function=0 Com_alter_procedure=0 Com_alter_server=0 Com_alter_table=17 Com_alter_tablespace=0 Com_analyze=0 Com_begin=26 Com_binlog=0 Com_call_procedure=0 Com_change_db=4066 Com_change_master=0 Com_check=0 Com_checksum=0 Com_commit=169454 Com_create_db=0 Com_create_event=0 Com_create_function=0 Com_create_index=0 Com_create_procedure=0 Com_create_server=0 Com_create_table=4 Com_create_trigger=0 Com_create_udf=0 Com_create_user=1 Com_create_view=0 Com_dealloc_sql=0 Com_delete=23 Com_delete_multi=0 Com_do=0 Com_drop_db=0 Com_drop_event=0 Com_drop_function=0 Com_drop_index=0 Com_drop_procedure=0 Com_drop_server=0 Com_drop_table=1 Com_drop_trigger=0 Com_drop_user=0 Com_drop_view=0 Com_empty_query=0 Com_execute_sql=0 Com_flush=1 Com_grant=0 Com_ha_close=0 Com_ha_open=0 Com_ha_read=0 Com_help=1 Com_insert=122690 Com_insert_select=0 Com_install_plugin=0 Com_kill=0 Com_load=0 Com_lock_tables=0 Com_optimize=0 Com_preload_keys=0 Com_prepare_sql=0 Com_purge=0 Com_purge_before_date=0 Com_release_savepoint=0 Com_rename_table=0 Com_rename_user=0 Com_repair=0 Com_replace=5294 Com_replace_select=0 Com_reset=0 Com_resignal=0 Com_revoke=0 Com_revoke_all=0 Com_rollback=8 Com_rollback_to_savepoint=0 Com_savepoint=0 Com_select=172366 Com_set_option=344484 Com_signal=0 Com_show_authors=0 Com_show_binlog_events=0 Com_show_binlogs=0 Com_show_charsets=4 Com_show_collations=12 Com_show_contributors=0 Com_show_create_db=0 Com_show_create_event=0 Com_show_create_func=0 Com_show_create_proc=0 Com_show_create_table=300 Com_show_create_trigger=0 Com_show_databases=20 Com_show_engine_logs=0 Com_show_engine_mutex=0 Com_show_engine_status=0 Com_show_events=0 Com_show_errors=0 Com_show_fields=374 Com_show_function_status=0 Com_show_grants=13 Com_show_keys=130 Com_show_master_status=0 Com_show_open_tables=0 Com_show_plugins=0 Com_show_privileges=0 Com_show_procedure_status=0 Com_show_processlist=13 Com_show_profile=0 Com_show_profiles=0 Com_show_relaylog_events=0 Com_show_slave_hosts=0 Com_show_slave_status=0 Com_show_status=453 Com_show_storage_engines=13 Com_show_table_status=49 Com_show_tables=235 Com_show_triggers=0 Com_show_variables=40 Com_show_warnings=908 Com_slave_start=0 Com_slave_stop=0 Com_stmt_close=0 Com_stmt_execute=0 Com_stmt_fetch=0 Com_stmt_prepare=0 Com_stmt_reprepare=0 Com_stmt_reset=0 Com_stmt_send_long_data=0 Com_truncate=1 Com_uninstall_plugin=0 Com_unlock_tables=0 Com_update=3641 Com_update_multi=0 Com_xa_commit=0 Com_xa_end=0 Com_xa_prepare=0 Com_xa_recover=0 Com_xa_rollback=0 Com_xa_start=0 Compression=OFF Connections=174045 Created_tmp_disk_tables=400 Created_tmp_files=5 Created_tmp_tables=1450 Delayed_errors=0 Delayed_insert_threads=0 Delayed_writes=0 Flush_commands=1 Handler_commit=473137 Handler_delete=1116819 Handler_discover=0 Handler_prepare=0 Handler_read_first=86442 Handler_read_key=487413 Handler_read_last=5356 Handler_read_next=3082030 Handler_read_prev=1328568 Handler_read_rnd=21374 Handler_read_rnd_next=1420912 Handler_rollback=36 Handler_savepoint=0 Handler_savepoint_rollback=0 Handler_update=4539 Handler_write=311367 Innodb_buffer_pool_pages_data=8185 Innodb_buffer_pool_pages_dirty=0 Innodb_buffer_pool_pages_flushed=540522 Innodb_buffer_pool_pages_free=1 Innodb_buffer_pool_pages_misc=5 Innodb_buffer_pool_pages_total=8191 Innodb_buffer_pool_read_ahead=3380 Innodb_buffer_pool_read_ahead_evicted=1057 Innodb_buffer_pool_read_requests=16439951 Innodb_buffer_pool_reads=25731 Innodb_buffer_pool_wait_free=0 Innodb_buffer_pool_write_requests=6336371 Innodb_data_fsyncs=177969 Innodb_data_pending_fsyncs=0 Innodb_data_pending_reads=0 Innodb_data_pending_writes=0 Innodb_data_read=479236096 Innodb_data_reads=29127 Innodb_data_writes=434237 Innodb_data_written=693651456 Innodb_dblwr_pages_written=270261 Innodb_dblwr_writes=15178 Innodb_have_atomic_builtins=ON Innodb_log_waits=0 Innodb_log_write_requests=900001 Innodb_log_writes=133067 Innodb_os_log_fsyncs=147411 Innodb_os_log_pending_fsyncs=0 Innodb_os_log_pending_writes=0 Innodb_os_log_written=420284416 Innodb_page_size=16384 Innodb_pages_created=11257 Innodb_pages_read=29116 Innodb_pages_written=270261 Innodb_row_lock_current_waits=0 Innodb_row_lock_time=0 Innodb_row_lock_time_avg=0 Innodb_row_lock_time_max=0 Innodb_row_lock_waits=0 Innodb_rows_deleted=1116819 Innodb_rows_inserted=144144 Innodb_rows_read=5775335 Innodb_rows_updated=4539 Innodb_truncated_status_writes=0 Key_blocks_not_flushed=0 Key_blocks_unused=7245 Key_blocks_used=3 Key_read_requests=5 Key_reads=3 Key_write_requests=1 Key_writes=1 Last_query_cost=0.000000 Max_used_connections=6 Not_flushed_delayed_rows=0 Open_files=48 Open_streams=0 Open_table_definitions=62 Open_tables=62 Opened_files=3897 Opened_table_definitions=101 Opened_tables=127 Performance_schema_cond_classes_lost=0 Performance_schema_cond_instances_lost=0 Performance_schema_file_classes_lost=0 Performance_schema_file_handles_lost=0 Performance_schema_file_instances_lost=0 Performance_schema_locker_lost=0 Performance_schema_mutex_classes_lost=0 Performance_schema_mutex_instances_lost=0 Performance_schema_rwlock_classes_lost=0 Performance_schema_rwlock_instances_lost=0 Performance_schema_table_handles_lost=0 Performance_schema_table_instances_lost=0 Performance_schema_thread_classes_lost=0 Performance_schema_thread_instances_lost=0 Prepared_stmt_count=0 Qcache_free_blocks=0 Qcache_free_memory=0 Qcache_hits=0 Qcache_inserts=0 Qcache_lowmem_prunes=0 Qcache_not_cached=0 Qcache_queries_in_cache=0 Qcache_total_blocks=0 Queries=998680 Questions=998680 Rpl_status=AUTH_MASTER Select_full_join=0 Select_full_range_join=0 Select_range=0 Select_range_check=0 Select_scan=93212 Slave_heartbeat_period=0.000 Slave_open_temp_tables=0 Slave_received_heartbeats=0 Slave_retried_transactions=0 Slave_running=OFF Slow_launch_threads=0 Slow_queries=2 Sort_merge_passes=0 Sort_range=0 Sort_rows=20916 Sort_scan=528 Ssl_accept_renegotiates=0 Ssl_accepts=0 Ssl_callback_cache_hits=0 Ssl_cipher= Ssl_cipher_list= Ssl_client_connects=0 Ssl_connect_renegotiates=0 Ssl_ctx_verify_depth=0 Ssl_ctx_verify_mode=0 Ssl_default_timeout=0 Ssl_finished_accepts=0 Ssl_finished_connects=0 Ssl_session_cache_hits=0 Ssl_session_cache_misses=0 Ssl_session_cache_mode=NONE Ssl_session_cache_overflows=0 Ssl_session_cache_size=0 Ssl_session_cache_timeouts=0 Ssl_sessions_reused=0 Ssl_used_session_cache_entries=0 Ssl_verify_depth=0 Ssl_verify_mode=0 Ssl_version= Table_locks_immediate=303832 Table_locks_waited=0 Tc_log_max_pages_used=0 Tc_log_page_size=0 Tc_log_page_waits=0 Threads_cached=0 Threads_connected=3 Threads_created=174044 Threads_running=1 Uptime=3029527 Uptime_since_flush_status=3029527
I THINK this is right,its have data.
Can you help me fix resolve this question?
Thanks!
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/62177#62177]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"mysql monitor no graph data"
To view the discussion, visit: http://community.zenoss.org/message/62177#62177
--------------------------------------------------------------
HI, zenoss user.
I test zenoss 3.2.0 to monitor mysql .use MySqlMonitor Zenpack.
zenpack --list|grep -i mysql
ZenPacks.community.MySQLSSH (/opt/zenoss/ZenPacks/ZenPacks.community.MySQLSSH-0.4-py2.6.egg)
ZenPacks.zenoss.MySqlMonitor (/opt/zenoss/ZenPacks/ZenPacks.zenoss.MySqlMonitor-2.1.3-py2.6.egg)
I fllowing http://community.zenoss.org/docs/DOC-9849 http://community.zenoss.org/docs/DOC-9849 set my mysql monitor,
and no any error event.
but in "Graphs", any mysql graphs not have data.
Loading Image...
(Loading Image...
)I run monitor command: check_mysql_stats.py --host 172.18.X.X -p 3306 -u zenoss -w zenoss -g Â
output this:
[***@centos5 libexec]$ ./check_mysql_stats.py --host 172.18.X.X -p 3306 -u zenoss -w zenoss -g
STATUS OK|Aborted_clients=1 Aborted_connects=29 Binlog_cache_disk_use=0 Binlog_cache_use=0 Binlog_stmt_cache_disk_use=0 Binlog_stmt_cache_use=0 Bytes_received=75477698 Bytes_sent=147079990 Com_admin_commands=6020 Com_assign_to_keycache=0 Com_alter_db=0 Com_alter_db_upgrade=0 Com_alter_event=0 Com_alter_function=0 Com_alter_procedure=0 Com_alter_server=0 Com_alter_table=17 Com_alter_tablespace=0 Com_analyze=0 Com_begin=26 Com_binlog=0 Com_call_procedure=0 Com_change_db=4066 Com_change_master=0 Com_check=0 Com_checksum=0 Com_commit=169454 Com_create_db=0 Com_create_event=0 Com_create_function=0 Com_create_index=0 Com_create_procedure=0 Com_create_server=0 Com_create_table=4 Com_create_trigger=0 Com_create_udf=0 Com_create_user=1 Com_create_view=0 Com_dealloc_sql=0 Com_delete=23 Com_delete_multi=0 Com_do=0 Com_drop_db=0 Com_drop_event=0 Com_drop_function=0 Com_drop_index=0 Com_drop_procedure=0 Com_drop_server=0 Com_drop_table=1 Com_drop_trigger=0 Com_drop_user=0 Com_drop_view=0 Com_empty_query=0 Com_execute_sql=0 Com_flush=1 Com_grant=0 Com_ha_close=0 Com_ha_open=0 Com_ha_read=0 Com_help=1 Com_insert=122690 Com_insert_select=0 Com_install_plugin=0 Com_kill=0 Com_load=0 Com_lock_tables=0 Com_optimize=0 Com_preload_keys=0 Com_prepare_sql=0 Com_purge=0 Com_purge_before_date=0 Com_release_savepoint=0 Com_rename_table=0 Com_rename_user=0 Com_repair=0 Com_replace=5294 Com_replace_select=0 Com_reset=0 Com_resignal=0 Com_revoke=0 Com_revoke_all=0 Com_rollback=8 Com_rollback_to_savepoint=0 Com_savepoint=0 Com_select=172366 Com_set_option=344484 Com_signal=0 Com_show_authors=0 Com_show_binlog_events=0 Com_show_binlogs=0 Com_show_charsets=4 Com_show_collations=12 Com_show_contributors=0 Com_show_create_db=0 Com_show_create_event=0 Com_show_create_func=0 Com_show_create_proc=0 Com_show_create_table=300 Com_show_create_trigger=0 Com_show_databases=20 Com_show_engine_logs=0 Com_show_engine_mutex=0 Com_show_engine_status=0 Com_show_events=0 Com_show_errors=0 Com_show_fields=374 Com_show_function_status=0 Com_show_grants=13 Com_show_keys=130 Com_show_master_status=0 Com_show_open_tables=0 Com_show_plugins=0 Com_show_privileges=0 Com_show_procedure_status=0 Com_show_processlist=13 Com_show_profile=0 Com_show_profiles=0 Com_show_relaylog_events=0 Com_show_slave_hosts=0 Com_show_slave_status=0 Com_show_status=453 Com_show_storage_engines=13 Com_show_table_status=49 Com_show_tables=235 Com_show_triggers=0 Com_show_variables=40 Com_show_warnings=908 Com_slave_start=0 Com_slave_stop=0 Com_stmt_close=0 Com_stmt_execute=0 Com_stmt_fetch=0 Com_stmt_prepare=0 Com_stmt_reprepare=0 Com_stmt_reset=0 Com_stmt_send_long_data=0 Com_truncate=1 Com_uninstall_plugin=0 Com_unlock_tables=0 Com_update=3641 Com_update_multi=0 Com_xa_commit=0 Com_xa_end=0 Com_xa_prepare=0 Com_xa_recover=0 Com_xa_rollback=0 Com_xa_start=0 Compression=OFF Connections=174045 Created_tmp_disk_tables=400 Created_tmp_files=5 Created_tmp_tables=1450 Delayed_errors=0 Delayed_insert_threads=0 Delayed_writes=0 Flush_commands=1 Handler_commit=473137 Handler_delete=1116819 Handler_discover=0 Handler_prepare=0 Handler_read_first=86442 Handler_read_key=487413 Handler_read_last=5356 Handler_read_next=3082030 Handler_read_prev=1328568 Handler_read_rnd=21374 Handler_read_rnd_next=1420912 Handler_rollback=36 Handler_savepoint=0 Handler_savepoint_rollback=0 Handler_update=4539 Handler_write=311367 Innodb_buffer_pool_pages_data=8185 Innodb_buffer_pool_pages_dirty=0 Innodb_buffer_pool_pages_flushed=540522 Innodb_buffer_pool_pages_free=1 Innodb_buffer_pool_pages_misc=5 Innodb_buffer_pool_pages_total=8191 Innodb_buffer_pool_read_ahead=3380 Innodb_buffer_pool_read_ahead_evicted=1057 Innodb_buffer_pool_read_requests=16439951 Innodb_buffer_pool_reads=25731 Innodb_buffer_pool_wait_free=0 Innodb_buffer_pool_write_requests=6336371 Innodb_data_fsyncs=177969 Innodb_data_pending_fsyncs=0 Innodb_data_pending_reads=0 Innodb_data_pending_writes=0 Innodb_data_read=479236096 Innodb_data_reads=29127 Innodb_data_writes=434237 Innodb_data_written=693651456 Innodb_dblwr_pages_written=270261 Innodb_dblwr_writes=15178 Innodb_have_atomic_builtins=ON Innodb_log_waits=0 Innodb_log_write_requests=900001 Innodb_log_writes=133067 Innodb_os_log_fsyncs=147411 Innodb_os_log_pending_fsyncs=0 Innodb_os_log_pending_writes=0 Innodb_os_log_written=420284416 Innodb_page_size=16384 Innodb_pages_created=11257 Innodb_pages_read=29116 Innodb_pages_written=270261 Innodb_row_lock_current_waits=0 Innodb_row_lock_time=0 Innodb_row_lock_time_avg=0 Innodb_row_lock_time_max=0 Innodb_row_lock_waits=0 Innodb_rows_deleted=1116819 Innodb_rows_inserted=144144 Innodb_rows_read=5775335 Innodb_rows_updated=4539 Innodb_truncated_status_writes=0 Key_blocks_not_flushed=0 Key_blocks_unused=7245 Key_blocks_used=3 Key_read_requests=5 Key_reads=3 Key_write_requests=1 Key_writes=1 Last_query_cost=0.000000 Max_used_connections=6 Not_flushed_delayed_rows=0 Open_files=48 Open_streams=0 Open_table_definitions=62 Open_tables=62 Opened_files=3897 Opened_table_definitions=101 Opened_tables=127 Performance_schema_cond_classes_lost=0 Performance_schema_cond_instances_lost=0 Performance_schema_file_classes_lost=0 Performance_schema_file_handles_lost=0 Performance_schema_file_instances_lost=0 Performance_schema_locker_lost=0 Performance_schema_mutex_classes_lost=0 Performance_schema_mutex_instances_lost=0 Performance_schema_rwlock_classes_lost=0 Performance_schema_rwlock_instances_lost=0 Performance_schema_table_handles_lost=0 Performance_schema_table_instances_lost=0 Performance_schema_thread_classes_lost=0 Performance_schema_thread_instances_lost=0 Prepared_stmt_count=0 Qcache_free_blocks=0 Qcache_free_memory=0 Qcache_hits=0 Qcache_inserts=0 Qcache_lowmem_prunes=0 Qcache_not_cached=0 Qcache_queries_in_cache=0 Qcache_total_blocks=0 Queries=998680 Questions=998680 Rpl_status=AUTH_MASTER Select_full_join=0 Select_full_range_join=0 Select_range=0 Select_range_check=0 Select_scan=93212 Slave_heartbeat_period=0.000 Slave_open_temp_tables=0 Slave_received_heartbeats=0 Slave_retried_transactions=0 Slave_running=OFF Slow_launch_threads=0 Slow_queries=2 Sort_merge_passes=0 Sort_range=0 Sort_rows=20916 Sort_scan=528 Ssl_accept_renegotiates=0 Ssl_accepts=0 Ssl_callback_cache_hits=0 Ssl_cipher= Ssl_cipher_list= Ssl_client_connects=0 Ssl_connect_renegotiates=0 Ssl_ctx_verify_depth=0 Ssl_ctx_verify_mode=0 Ssl_default_timeout=0 Ssl_finished_accepts=0 Ssl_finished_connects=0 Ssl_session_cache_hits=0 Ssl_session_cache_misses=0 Ssl_session_cache_mode=NONE Ssl_session_cache_overflows=0 Ssl_session_cache_size=0 Ssl_session_cache_timeouts=0 Ssl_sessions_reused=0 Ssl_used_session_cache_entries=0 Ssl_verify_depth=0 Ssl_verify_mode=0 Ssl_version= Table_locks_immediate=303832 Table_locks_waited=0 Tc_log_max_pages_used=0 Tc_log_page_size=0 Tc_log_page_waits=0 Threads_cached=0 Threads_connected=3 Threads_created=174044 Threads_running=1 Uptime=3029527 Uptime_since_flush_status=3029527
I THINK this is right,its have data.
Can you help me fix resolve this question?
Thanks!
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/62177#62177]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]