分析一下mysql的状态

本帖最后由 hst0012010 于 2011-11-20 16:58:16 编辑

解决方案 »

  1.   

    贴你的
    show  variables
      

  2.   

    auto_increment_increment 1
    auto_increment_offset 1
    automatic_sp_privileges ON
    back_log 50
    basedir D:\PHPnow-1.5.6\MySQL-5.0.90\
    binlog_cache_size 32768
    bulk_insert_buffer_size 5242880
    character_set_client utf8
    character_set_connection utf8
    character_set_database latin1
    character_set_filesystem binary
    character_set_results utf8
    character_set_server latin1
    character_set_system utf8
    character_sets_dir D:\PHPnow-1.5.6\MySQL-5.0.90\share\charsets\
    collation_connection utf8_general_ci
    collation_database latin1_swedish_ci
    collation_server latin1_swedish_ci
    completion_type 0
    concurrent_insert 1
    connect_timeout 10
    datadir D:\PHPnow-1.5.6\MySQL-5.0.90\data\
    date_format %Y-%m-%d
    datetime_format %Y-%m-%d %H:%i:%s
    default_week_format 0
    delay_key_write ON
    delayed_insert_limit 100
    delayed_insert_timeout 300
    delayed_queue_size 1000
    div_precision_increment 4
    keep_files_on_create OFF
    engine_condition_pushdown OFF
    expire_logs_days 0
    flush OFF
    flush_time 1800
    ft_boolean_syntax + -><()~*:""&|
    ft_max_word_len 84
    ft_min_word_len 4
    ft_query_expansion_limit 20
    ft_stopword_file (built-in)
    group_concat_max_len 1024
    have_archive YES
    have_bdb NO
    have_blackhole_engine YES
    have_compress YES
    have_community_features YES
    have_profiling YES
    have_crypt NO
    have_csv NO
    have_dynamic_loading YES
    have_example_engine NO
    have_federated_engine DISABLED
    have_geometry YES
    have_innodb DISABLED
    have_isam NO
    have_merge_engine YES
    have_ndbcluster NO
    have_openssl DISABLED
    have_ssl DISABLED
    have_query_cache YES
    have_raid NO
    have_rtree_keys YES
    have_symlink YES
    hostname Ve830342
    init_connect  
    init_file  
    init_slave  
    innodb_additional_mem_pool_size 5242880
    innodb_autoextend_increment 8
    innodb_buffer_pool_awe_mem_mb 0
    innodb_buffer_pool_size 8388608
    innodb_checksums ON
    innodb_commit_concurrency 0
    innodb_concurrency_tickets 500
    innodb_data_file_path  
    innodb_data_home_dir  
    innodb_adaptive_hash_index ON
    innodb_doublewrite ON
    innodb_fast_shutdown 1
    innodb_file_io_threads 4
    innodb_file_per_table OFF
    innodb_flush_log_at_trx_commit 1
    innodb_flush_method  
    innodb_force_recovery 0
    innodb_lock_wait_timeout 50
    innodb_locks_unsafe_for_binlog OFF
    innodb_log_arch_dir  
    innodb_log_archive OFF
    innodb_log_buffer_size 3145728
    innodb_log_file_size 5242880
    innodb_log_files_in_group 2
    innodb_log_group_home_dir  
    innodb_max_dirty_pages_pct 90
    innodb_max_purge_lag 0
    innodb_mirrored_log_groups 1
    innodb_open_files 300
    innodb_rollback_on_timeout OFF
    innodb_support_xa ON
    innodb_sync_spin_loops 20
    innodb_table_locks ON
    innodb_thread_concurrency 8
    innodb_thread_sleep_delay 10000
    innodb_use_legacy_cardinality_algorithm ON
    interactive_timeout 28800
    join_buffer_size 8388608
    key_buffer_size 12582912
    key_cache_age_threshold 300
    key_cache_block_size 1024
    key_cache_division_limit 100
    language D:\PHPnow-1.5.6\MySQL-5.0.90\share\english\
    large_files_support ON
    large_page_size 0
    large_pages OFF
    lc_time_names en_US
    license GPL
    local_infile ON
    log OFF
    log_bin OFF
    log_bin_trust_function_creators OFF
    log_error D:\PHPnow-1.5.6\MySQL-5.0.90\data\Ve830342.err
    log_queries_not_using_indexes OFF
    log_slave_updates OFF
    log_slow_queries ON
    log_warnings 1
    long_query_time 12
    low_priority_updates OFF
    lower_case_file_system ON
    lower_case_table_names 1
    max_allowed_packet 8388608
    max_binlog_cache_size 4294963200
    max_binlog_size 1073741824
    max_connect_errors 10
    max_connections 120
    max_delayed_threads 20
    max_error_count 64
    max_heap_table_size 18874368
    max_insert_delayed_threads 20
    max_join_size 18446744073709551615
    max_length_for_sort_data 1024
    max_prepared_stmt_count 16382
    max_relay_log_size 0
    max_seeks_for_key 4294967295
    max_sort_length 1024
    max_sp_recursion_depth 0
    max_tmp_tables 32
    max_user_connections 0
    max_write_lock_count 4294967295
    multi_range_count 256
    myisam_data_pointer_size 6
    myisam_max_sort_file_size 2146435072
    myisam_mmap_size 4294967295
    myisam_recover_options OFF
    myisam_repair_threads 1
    myisam_sort_buffer_size 14680064
    myisam_stats_method nulls_unequal
    named_pipe OFF
    net_buffer_length 12288
    net_read_timeout 30
    net_retry_count 10
    net_write_timeout 60
    new OFF
    old_passwords OFF
    open_files_limit 650
    optimizer_prune_level 1
    optimizer_search_depth 62
    pid_file D:\PHPnow-1.5.6\MySQL-5.0.90\data\Ve830342.pid
    plugin_dir  
    port 3306
    preload_buffer_size 32768
    profiling OFF
    profiling_history_size 15
    protocol_version 10
    query_alloc_block_size 8192
    query_cache_limit 8388608
    query_cache_min_res_unit 4096
    query_cache_size 16777216
    query_cache_type ON
    query_cache_wlock_invalidate OFF
    query_prealloc_size 8192
    range_alloc_block_size 4096
    read_buffer_size 7340032
    read_only OFF
    read_rnd_buffer_size 14680064
    relay_log  
    relay_log_index  
    relay_log_info_file relay-log.info
    relay_log_purge ON
    relay_log_space_limit 0
    rpl_recovery_rank 0
    secure_auth OFF
    secure_file_priv  
    shared_memory OFF
    shared_memory_base_name MYSQL
    server_id 1
    skip_external_locking ON
    skip_networking OFF
    skip_show_database OFF
    slave_compressed_protocol OFF
    slave_load_tmpdir C:\WINDOWS\TEMP\
    slave_net_timeout 3600
    slave_skip_errors OFF
    slave_transaction_retries 10
    slow_launch_time 2
    sort_buffer_size 10485760
    sql_big_selects ON
    sql_mode  
    sql_notes ON
    sql_warnings OFF
    ssl_ca  
    ssl_capath  
    ssl_cert  
    ssl_cipher  
    ssl_key  
    storage_engine MyISAM
    sync_binlog 0
    sync_frm ON
    system_time_zone  
    table_cache 260
    table_lock_wait_timeout 50
    table_type MyISAM
    thread_cache_size 8
    thread_stack 184320
    time_format %H:%i:%s
    time_zone SYSTEM
    timed_mutexes OFF
    tmp_table_size 18874368
    tmpdir C:\WINDOWS\TEMP\
    transaction_alloc_block_size 8192
    transaction_prealloc_size 4096
    tx_isolation REPEATABLE-READ
    updatable_views_with_limit YES
    version 5.0.90-community-nt-log
    version_comment MySQL Community Edition (GPL)
    version_compile_machine ia32
    version_compile_os Win32
    wait_timeout 28800
      

  3.   

    不太清楚。
    昨天重启了MSYQL，到现在运行20个小时，数据库数据量流量就4G了，整个数据库也就两三百兆，而且网站人很少，我不知道这是个什么概念，是不是很正常
      

  4.   

    给你推荐一个非常实用的自动采集脚本：MySQL数据库运行状态数据采集的脚本而你这个是整体的平均值，这个脚本只要你自己在crontab设置时间间隔，就自动跑起来，建议5分钟一次的价格...文章中有详细介绍