Jump to content

Runtime Info Stats


Guest ReinforcedPanda

Recommended Posts

I was just wondering, are these Runtime stats good?

Aborted_clients 182970


Aborted_connects 7893


Binlog_cache_disk_use 0


Binlog_cache_use 0


Bytes_received 929


Bytes_sent 355402


Com_admin_commands 0


Com_alter_db 0


Com_alter_table 0


Com_analyze 0


Com_backup_table 0


Com_begin 0


Com_call_procedure 0


Com_change_db 0


Com_change_master 0


Com_check 0


Com_checksum 0


Com_commit 0


Com_create_db 0


Com_create_function 0


Com_create_index 0


Com_create_table 0


Com_create_user 0


Com_dealloc_sql 0


Com_delete 0


Com_delete_multi 0


Com_do 0


Com_drop_db 0


Com_drop_function 0


Com_drop_index 0


Com_drop_table 0


Com_drop_user 0


Com_execute_sql 0


Com_flush 0


Com_grant 0


Com_ha_close 0


Com_ha_open 0


Com_ha_read 0


Com_help 0


Com_insert 0


Com_insert_select 0


Com_kill 0


Com_load 0


Com_load_master_data 0


Com_load_master_table 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_rename_table 0


Com_repair 0


Com_replace 0


Com_replace_select 0


Com_reset 0


Com_restore_table 0


Com_revoke 0


Com_revoke_all 0


Com_rollback 0


Com_savepoint 0


Com_select 2


Com_set_option 1


Com_show_binlog_events 0


Com_show_binlogs 0


Com_show_charsets 0


Com_show_collations 0


Com_show_column_types 0


Com_show_create_db 0


Com_show_create_table 0


Com_show_databases 0


Com_show_errors 0


Com_show_fields 0


Com_show_grants 0


Com_show_innodb_status 0


Com_show_keys 0


Com_show_logs 0


Com_show_master_status 0


Com_show_ndb_status 0


Com_show_new_master 0


Com_show_open_tables 0


Com_show_privileges 0


Com_show_processlist 0


Com_show_slave_hosts 0


Com_show_slave_status 0


Com_show_status 1


Com_show_storage_engines 0


Com_show_tables 0


Com_show_triggers 0


Com_show_variables 0


Com_show_warnings 0


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_reset 0


Com_stmt_send_long_data 0


Com_truncate 0


Com_unlock_tables 0


Com_update 1


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 77549589


Created_tmp_disk_tables 0


Created_tmp_files 390581


Created_tmp_tables 1


Delayed_errors 1


Delayed_insert_threads 0


Delayed_writes 7736


Flush_commands 1


Handler_commit 0


Handler_delete 0


Handler_discover 0


Handler_prepare 0


Handler_read_first 1


Handler_read_key 12


Handler_read_next 0


Handler_read_prev 0


Handler_read_rnd 0


Handler_read_rnd_next 1


Handler_rollback 0


Handler_savepoint 0


Handler_savepoint_rollback 0


Handler_update 1


Handler_write 132


Innodb_buffer_pool_pages_data 8149


Innodb_buffer_pool_pages_dirty 0


Innodb_buffer_pool_pages_flushed 8496262


Innodb_buffer_pool_pages_free 0


Innodb_buffer_pool_pages_latched 0


Innodb_buffer_pool_pages_misc 43


Innodb_buffer_pool_pages_total 8192


Innodb_buffer_pool_read_ahead_rnd 69088


Innodb_buffer_pool_read_ahead_seq 26897


Innodb_buffer_pool_read_requests 973149859


Innodb_buffer_pool_reads 12350524


Innodb_buffer_pool_wait_free 0


Innodb_buffer_pool_write_requests 792652700


Innodb_data_fsyncs 11557170


Innodb_data_pending_fsyncs 0


Innodb_data_pending_reads 0


Innodb_data_pending_writes 0


Innodb_data_read 3341340672


Innodb_data_reads 12731941


Innodb_data_writes 12688156


Innodb_data_written 170555904


Innodb_dblwr_pages_written 8496262


Innodb_dblwr_writes 364167


Innodb_log_waits 796


Innodb_log_write_requests 101985116


Innodb_log_writes 5554785


Innodb_os_log_fsyncs 5747428


Innodb_os_log_pending_fsyncs 0


Innodb_os_log_pending_writes 0


Innodb_os_log_written 810849792


Innodb_page_size 16384


Innodb_pages_created 6080921


Innodb_pages_read 16456734


Innodb_pages_written 8496262


Innodb_row_lock_current_waits 0


Innodb_row_lock_time 587701


Innodb_row_lock_time_avg 1163


Innodb_row_lock_time_max 61120


Innodb_row_lock_waits 505


Innodb_rows_deleted 1026978


Innodb_rows_inserted 157389471


Innodb_rows_read 3791087164


Innodb_rows_updated 680089


Key_blocks_not_flushed 0


Key_blocks_unused 57880


Key_blocks_used 57990


Key_read_requests 50537812628


Key_reads 730998123


Key_write_requests 1395512552


Key_writes 73653324


Last_query_cost 0.000000


Max_used_connections 169


Ndb_cluster_node_id 0


Ndb_config_from_host


Ndb_config_from_port 0


Ndb_number_of_data_nodes 0


Not_flushed_delayed_rows 0


Open_files 130


Open_streams 0


Open_tables 64


Opened_tables 1


Prepared_stmt_count 0


Qcache_free_blocks 2119


Qcache_free_memory 6048728


Qcache_hits 960815885


Qcache_inserts 304979951


Qcache_lowmem_prunes 205375456


Qcache_not_cached 71174931


Qcache_queries_in_cache 7213


Qcache_total_blocks 19234


Questions 2142076013


Rpl_status NULL


Select_full_join 0


Select_full_range_join 0


Select_range 1


Select_range_check 0


Select_scan 1


Slave_open_temp_tables 0


Slave_retried_transactions 0


Slave_running OFF


Slow_launch_threads 0


Slow_queries 0


Sort_merge_passes 0


Sort_range 0


Sort_rows 0


Sort_scan 0


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 575520952


Table_locks_waited 490119


Tc_log_max_pages_used 0


Tc_log_page_size 0


Tc_log_page_waits 0


Threads_cached 17


Threads_connected 7


Threads_created 109370


Threads_running 3


Uptime 8502594


Uptime_since_flush_status 5477406



I see the table locks are really high ( has no idea what that means) but I was wondering if someone could tell me if these stats are good or wut they are XD
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...