日IP 8W+ PV70W+ 求针对DZ论坛MySQL数据库优化

CentOS
CPU Intel 5410 四核×2
内存 4G×2


cat /etc/my.cnf

1. [mysqld]
   
2. user=mysql
   
3. pid-file=/var/run/mysqld/mysqld.pid
   
4. socket=/var/lib/mysql/mysql.sock
   
5. port=3306
   
6. datadir=/data0/db_mysql
   
7. 
   
8. long_query_time=2
   
9. log-queries-not-using-indexes
   
10. 
    
11. skip-bdb
    
12. skip-innodb
    
13. skip-locking
    
14. skip-external-locking
    
15. old_passwords=1
    
16. bind-address=xxxxxxxxxxx
    
17. 
    
18. # key_buffer + (sort_buffer + read_buffer ) * max_connection
    
19. # key_buffer=512M | 1024M | 1536M | 2048M
    
20. key_buffer=768M
    
21. sort_buffer_size=8M
    
22. read_buffer_size=8M
    
23. read_rnd_buffer_size=8M
    
24. join_buffer_size=64M
    
25. myisam_sort_buffer_size=256M
    
26. 
    
27. wait_timeout=5
    
28. connect_timeout=10
    
29. interactive_timeout=30
    
30. max_connections=200
    
31. max_connect_errors=10000
    
32. 
    
33. max_allowed_packet=16M
    
34. table_cache=2048
    
35. open_files_limit=5120
    
36. tmp_table_size=768M
    
37. max_heap_table_size=768M
    
38. thread_stack=256K
    
39. thread_cache_size=512
    
40. 
    
41. thread_concurrency=16
    
42. concurrent_insert=2
    
43. low_priority_updates=1
    
44. 
    
45. query_cache_size=128M
    
46. query_cache_limit=16M
    
47. query_cache_type=1
    
48. 
    
49. [mysql.server]
    
50. user=mysql
    
51. basedir=/var/lib
    
52. 
    
53. [mysql]
    
54. #no-auto-rehash
    
55. # Remove the next comment character if you are not familiar with SQL
    
56. #safe-updates
    
57. 
    
58. [mysqldump]
    
59. quick
    
60. quote-names
    
61. max_allowed_packet=16M
    
62. 
    
63. [isamchk]
    
64. key_buffer=256M
    
65. sort_buffer_size=256M
    
66. read_buffer=2M
    
67. write_buffer=2M
    
68. 
    
69. [myisamchk]
    
70. key_buffer=256M
    
71. sort_buffer_size=256M
    
72. read_buffer=2M
    
73. write_buffer=2M
    

复制代码

......

啥意思？？？没看明白。。。