帮忙看看我现在应该怎么优化---附MYSQL状态图

尤其这个Handler_read_rnd_next，相当大啊。。。。求高手优化方案。

现有MYSQL配置方案：

1. skip-external-locking
   
2. back_log = 384
   
3. table_cache=4096
   
4. key_buffer_size = 512M
   
5. max_allowed_packet = 10M
   
6. table_open_cache = 512
   
7. sort_buffer_size = 12M
   
8. read_buffer_size = 12M
   
9. read_rnd_buffer_size = 12M
   
10. join_buffer_size = 12M
    
11. myisam_sort_buffer_size = 64M
    
12. thread_cache_size = 120
    
13. query_cache_size = 128M
    
14. tmp_table_size = 1200M
    
15. max_connections = 1024
    
16. max_connect_errors = 10000000
    
17. slow_query_log_file = E:\Server_Core\MySQL\slowquery.log
    
18. long_query_time = 5
    
19. # Try number of CPU's*2 for thread_concurrency
    
20. thread_concurrency = 8
    
21. 
    
22. 
    
23. [mysqldump]
    
24. quick
    
25. max_allowed_packet = 16M
    
26. 
    
27. [mysql]
    
28. no-auto-rehash
    
29. # Remove the next comment character if you are not familiar with SQL
    
30. #safe-updates
    
31. 
    
32. [myisamchk]
    
33. key_buffer_size = 512M
    
34. sort_buffer_size = 512M
    
35. read_buffer = 16M
    
36. write_buffer = 16M
    
37. 
    
38. [mysqlhotcopy]
    
39. interactive-timeout
    

复制代码

服务器配置：

换服务器。

Suley 发表于 2010-12-18 23:11
换服务器。

等于没说，把NASA的换来不是无敌？

这个我不太懂啊。。看一下啊