discuz mysql资源占用过高导致拒绝服务，帮我优化一下配置文件！help me

论坛每天3100左右帖子，IP10000， pv 11万左右，，mysql 启动占用很是好内存，然后慢慢升高，导致不能服务了，，

1. [mysqld]
   
2. datadir=/var/lib/mysql
   
3. socket=/var/lib/mysql/mysql.sock
   
4. user=mysql
   
5. 
   
6. skip-locking
   
7. key_buffer = 256M
   
8. max_allowed_packet = 1M
   
9. table_cache = 256
   
10. sort_buffer_size = 1M
    
11. read_buffer_size = 1M
    
12. read_rnd_buffer_size = 4M
    
13. myisam_sort_buffer_size = 64M
    
14. thread_cache_size = 8
    
15. query_cache_size= 16M
    
16. # Try number of CPU's*2 for thread_concurrency
    
17. wait_timeout = 10
    
18. interactive_timeout = 10
    
19. max_connections = 900
    
20. max_connect_errors = 10000000
    
21. #thread_concurrency = 8
    
22. 
    
23. 
    
24. # Default to using old password format for compatibility with mysql 3.x
    
25. # clients (those using the mysqlclient10 compatibility package).
    
26. old_passwords=1
    
27. 
    
28. [mysqld_safe]
    
29. log-error=/var/log/mysqld.log
    
30. pid-file=/var/run/mysqld/mysqld.pid
    
31. 
    
32. [mysqldump]
    
33. quick
    
34. max_allowed_packet = 16M
    
35. 
    
36. [mysql]
    
37. no-auto-rehash
    
38. # Remove the next comment character if you are not familiar with SQL
    
39. #safe-updates
    
40. 
    
41. [isamchk]
    
42. key_buffer = 128M
    
43. sort_buffer_size = 128M
    
44. read_buffer = 2M
    
45. write_buffer = 2M
    
46. 
    
47. [myisamchk]
    
48. key_buffer = 128M
    
49. sort_buffer_size = 128M
    
50. read_buffer = 2M
    
51. write_buffer = 2M
    
52. 
    
53. [mysqlhotcopy]
    
54. interactive-timeout

复制代码

进来羡慕一下，，，，，，1w ip。。

期待解决办法。。













u88调侃杂谈

可惜都没人来回复解决方案啊