Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2010, 05:45 AM
sundarmobiles sundarmobiles is offline
 
Join Date: Oct 2007
Posts: 104
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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


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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:22 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03093 seconds
  • Memory Usage 2,171KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete