以下状态全以红色标记,问题出在哪里;服务器硬件信息:Intel(R) Pentium(R) D CPU 2.80GHz
内存1G
my.cnf配置key_buffer = 168M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 60
myisam-recover = BACKUP
max_connections = 66666600
wait_timeout = 10
max_connect_errors = 100
table_cache = 512
tmp_table_size = 128M
query_cache_limit = 1M
query_cache_size = 160M
query_cache_type = 1
expire_logs_days = 10
max_binlog_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
Slow_queries 5,952
Innodb_buffer_pool_reads 15
Handler_read_rnd 3,478.28 M
Handler_read_rnd_next 1,833 M
Qcache_lowmem_prunes 3,081
Slow_launch_threads 4
Threads_cached 58
Created_tmp_disk_tables 2,936 k
Select_full_join 32 k
Sort_merge_passes 534
Opened_tables 13 k
内存1G
my.cnf配置key_buffer = 168M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 60
myisam-recover = BACKUP
max_connections = 66666600
wait_timeout = 10
max_connect_errors = 100
table_cache = 512
tmp_table_size = 128M
query_cache_limit = 1M
query_cache_size = 160M
query_cache_type = 1
expire_logs_days = 10
max_binlog_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
Slow_queries 5,952
Innodb_buffer_pool_reads 15
Handler_read_rnd 3,478.28 M
Handler_read_rnd_next 1,833 M
Qcache_lowmem_prunes 3,081
Slow_launch_threads 4
Threads_cached 58
Created_tmp_disk_tables 2,936 k
Select_full_join 32 k
Sort_merge_passes 534
Opened_tables 13 k
流量 1 ø 每小时
已接收 1,801 MB 1,443 KB
已发送 2,164 MB 1,734 KB
总计 3,965 MB 3,177 KB连接 ø 每小时 %
最大并发连接数 161 --- ---
已失败 9 0.00 k 0.00%
已取消 115 k 89.85 5.55%
总计 2,070 k 1,619.91 100.00%