ReinforcedPanda Posted May 2, 2008 Posted May 2, 2008 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
AndyF Posted May 2, 2008 Posted May 2, 2008 Moving topic to "Server Management, Resources and Optimization" :)
ReinforcedPanda Posted May 3, 2008 Posted May 3, 2008 Thank ya kindly, I didn't know where to put this :P
Recommended Posts
Archived
This topic is now archived and is closed to further replies.