Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted May 2, 200816 yr 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
Archived
This topic is now archived and is closed to further replies.