any one can pls check my mysql status is this correct or anything wrong in tat aborted clients more than 18614 wats this mean
Quote:
Variable_name Value
Aborted_clients 18614
Aborted_connects 133576
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 2993465031
Bytes_sent 1917030676
Com_admin_commands 3513968
Com_alter_db 18
Com_alter_table 7105
Com_analyze 60
Com_backup_table 0
Com_begin 279649
Com_change_db 31083020
Com_change_master 0
Com_check 1654
Com_checksum 0
Com_commit 251587
Com_create_db 1226
Com_create_function 0
Com_create_index 2220
Com_create_table 105824
Com_create_user 5
Com_dealloc_sql 65059
Com_delete 9017400
Com_delete_multi 60832
Com_do 0
Com_drop_db 136
Com_drop_function 0
Com_drop_index 0
Com_drop_table 17339
Com_drop_user 0
Com_execute_sql 69000
Com_flush 628403
Com_grant 358
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 4
Com_insert 23086697
Com_insert_select 80800
Com_kill 2
Com_load 375
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 117368
Com_optimize 16010
Com_preload_keys 0
Com_prepare_sql 65843
Com_purge 0
Com_purge_before_date 0
Com_rename_table 119
Com_repair 10
Com_replace 645729
Com_replace_select 45
Com_reset 0
Com_restore_table 0
Com_revoke 142
Com_revoke_all 0
Com_rollback 113
Com_savepoint 0
Com_select 227251848
Com_set_option 24809885
Com_show_binlog_events 0
Com_show_binlogs 635
Com_show_charsets 780
Com_show_collations 1139
Com_show_column_types 0
Com_show_create_db 168
Com_show_create_table 2211793
Com_show_databases 1822
Com_show_errors 0
Com_show_fields 2730525
Com_show_grants 426
Com_show_innodb_status 0
Com_show_keys 49208
Com_show_logs 0
Com_show_master_status 691
Com_show_ndb_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 41
Com_show_slave_hosts 0
Com_show_slave_status 691
Com_show_status 7873
Com_show_storage_engines 130
Com_show_tables 2429993
Com_show_triggers 2145686
Com_show_variables 15805
Com_show_warnings 1385
Com_slave_start 0
Com_slave_stop 0
Com_stmt_close 65067
Com_stmt_execute 69008
Com_stmt_fetch 0
Com_stmt_prepare 65851
Com_stmt_reset 0
Com_stmt_send_long_data 0
Com_truncate 17200
Com_unlock_tables 120583
Com_update 36603286
Com_update_multi 46826
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 25710925
Created_tmp_disk_tables 11801335
Created_tmp_files 115026
Created_tmp_tables 27795926
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 3729
Flush_commands 1
Handler_commit 2816828
Handler_delete 10089616
Handler_discover 0
Handler_prepare 0
Handler_read_first 31660118
Handler_read_key 3592626061
Handler_read_next 383554005
Handler_read_prev 1164982558
Handler_read_rnd 1657751809
Handler_read_rnd_next 2961609619
Handler_rollback 27374
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 1603327326
Handler_write 1281996434
Innodb_buffer_pool_pages_data 4083
Innodb_buffer_pool_pages_dirty 25
Innodb_buffer_pool_pages_flushed 3816692
Innodb_buffer_pool_pages_free 1
Innodb_buffer_pool_pages_latched 0
Innodb_buffer_pool_pages_misc 12
Innodb_buffer_pool_pages_total 4096
Innodb_buffer_pool_read_ahead_rnd 260570
Innodb_buffer_pool_read_ahead_seq 1915635
Innodb_buffer_pool_read_requests 3630929407
Innodb_buffer_pool_reads 10472521
Innodb_buffer_pool_wait_free 0
Innodb_buffer_pool_write_requests 23424727
Innodb_data_fsyncs 2053704
Innodb_data_pending_fsyncs 1
Innodb_data_pending_reads 0
Innodb_data_pending_writes 0
Innodb_data_read 676335616
Innodb_data_reads 13809824
Innodb_data_writes 4567094
Innodb_data_written 2991289344
Innodb_dblwr_pages_written 3816692
Innodb_dblwr_writes 372127
Innodb_log_waits 0
Innodb_log_write_requests 4125750
Innodb_log_writes 1079311
Innodb_os_log_fsyncs 1296237
Innodb_os_log_pending_fsyncs 1
Innodb_os_log_pending_writes 0
Innodb_os_log_written 2368729088
Innodb_page_size 16384
Innodb_pages_created 51381
Innodb_pages_read 145006930
Innodb_pages_written 3816692
Innodb_row_lock_current_waits 0
Innodb_row_lock_time 124294
Innodb_row_lock_time_avg 241
Innodb_row_lock_time_max 7724
Innodb_row_lock_waits 515
Innodb_rows_deleted 461629
Innodb_rows_inserted 1239781
Innodb_rows_read 1682044587
Innodb_rows_updated 1199712
Key_blocks_not_flushed 35
Key_blocks_unused 312783
Key_blocks_used 348900
Key_read_requests 17135587703
Key_reads 33855206
Key_write_requests 461686625
Key_writes 86593462
Last_query_cost 0.000000
Max_used_connections 451
Not_flushed_delayed_rows 0
Open_files 24353
Open_streams 0
Open_tables 16384
Opened_tables 7507596
Prepared_stmt_count 0
Qcache_free_blocks 4632
Qcache_free_memory 13414384
Qcache_hits 379592578
Qcache_inserts 204903513
Qcache_lowmem_prunes 125417412
Qcache_not_cached 23051146
Qcache_queries_in_cache 13148
Qcache_total_blocks 37024
Questions 772591219
Rpl_status NULL
Select_full_join 5971395
Select_full_range_join 32244
Select_range 17797532
Select_range_check 80916
Select_scan 48765808
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 19100
Sort_merge_passes 64951
Sort_range 15658638
Sort_rows 509405594
Sort_scan 23219134
Table_locks_immediate 365691095
Table_locks_waited 68601
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 47
Threads_connected 128
Threads_created 1628
Threads_running 6
Uptime 2352997
Uptime_since_flush_status 2352997
|
10-27-2010, 05:45 AM
MySQL Status
Linear Mode
