我的my.cnf 和大家分享一下

每个人服务器都做过不同的调整，大家都把一些配置文件贴出来看看吧。

1. [client]
   
2. port            = 3306
   
3. socket          = /tmp/mysql.sock
   
4. [mysqld]
   
5. port            = 3306
   
6. socket          = /tmp/mysql.sock
   
7. skip-locking
   
8. skip-locking
   
9. skip-innodb
   
10. skip-bdb
    
11. skip-name-resolve
    
12. skip-networking
    
13. max_connections=600
    
14. wait_timeout =5
    
15. connect_timeout =10
    
16. back_log = 150
    
17. thread_cache = 64
    
18. thread_cache_size = 128
    
19. long_query_time = 5
    
20. key_buffer = 384M
    
21. max_allowed_packet = 1M
    
22. table_cache = 512
    
23. sort_buffer_size = 2M
    
24. read_buffer_size = 2M
    
25. read_rnd_buffer_size = 8M
    
26. myisam_sort_buffer_size = 64M
    
27. thread_cache_size = 8
    
28. query_cache_size = 32M
    
29. thread_concurrency = 8
    
30. #log-bin
    
31. server-id       = 1
    
32. 
    
33. [mysqldump]
    
34. quick
    
35. max_allowed_packet = 16M
    
36. 
    
37. [mysql]
    
38. no-auto-rehash
    
39. 
    
40. [isamchk]
    
41. key_buffer = 256M
    
42. sort_buffer_size = 256M
    
43. read_buffer = 2M
    
44. write_buffer = 2M
    
45. 
    
46. [myisamchk]
    
47. key_buffer = 256M
    
48. sort_buffer_size = 256M
    
49. read_buffer = 2M
    
50. write_buffer = 2M
    
51. 
    
52. [mysqlhotcopy]
    
53. interactive-timeout
    
54. 
    
55. #########2009.05.30##############
    
56. $

复制代码

谢谢分享           　　　　　　　　　!

共同进步！！！！

真是好人啊！