MySQL Status

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sundarmobiles
    Member
    • Sep 2007
    • 82
    • 3.7.x

    MySQL Status

    any one can pls check my mysql status is this correct or anything wrong in tat aborted clients more than 18614 wats this mean


    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

  • ENF
    Senior Member
    • Apr 2002
    • 2677
    • 3.8.11

    #2
    Aborted Clients:



    It's the number of aborted client connections.

    It's just a counter and increments each time a connection is aborted.

    Your MySQL Server uptime is about 27 days; thus making that into about 689 aborted clients per day. Depending on how busy your site is, that could be normal.
    To be updated...

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...