求配置my.cnf

硬件：
1U：Intel(R) Xeon(TM) CPU 3.00GHz   
2G内存
硬盘：250G  SCSI


系统： centos 5.3  php5 MySQL5 Apache2 phpMyAdmin ZendOptimizer


现在的配置my.cnf：

1. 
   
2. 
   
3. # The following options will be passed to all MySQL clients
   
4. [client]
   
5. #password        = your_password
   
6. port                = 3306
   
7. socket                = /tmp/mysql.sock
   
8. 
   
9. # Here follows entries for some specific programs
   
10. 
    
11. # The MySQL server
    
12. [mysqld]
    
13. port                = 3306
    
14. socket                = /tmp/mysql.sock
    
15. skip-locking
    
16. max_connections = 1000
    
17. 
    
18. key_buffer_size = 256M
    
19. 
    
20. max_allowed_packet = 4M
    
21. back_log = 384
    
22. 
    
23. table_open_cache = 512
    
24. 
    
25. sort_buffer_size = 4M
    
26. 
    
27. read_buffer_size = 4M
    
28. 
    
29. read_rnd_buffer_size = 8M
    
30. 
    
31. myisam_sort_buffer_size = 64M
    
32. 
    
33. thread_cache_size = 256
    
34. 
    
35. query_cache_size = 32M
    
36. 
    
37. thread_concurrency = 4
    
38. 
    
39. interactive_timeout=10
    
40. wait_timeout = 10
    
41. 
    
42. 
    
43. 
    
44. # Replication Master Server (default)
    
45. # binary logging is required for replication
    
46. log-bin=mysql-bin
    
47. 
    
48. # binary logging format - mixed recommended
    
49. binlog_format=mixed
    
50. 
    
51. # required unique id between 1 and 2^32 - 1
    
52. # defaults to 1 if master-host is not set
    
53. # but will not function as a master if omitted
    
54. server-id        = 1
    
55. 
    
56. [mysqldump]
    
57. quick
    
58. max_allowed_packet = 16M
    
59. 
    
60. [mysql]
    
61. no-auto-rehash
    
62. # Remove the next comment character if you are not familiar with SQL
    
63. #safe-updates
    
64. 
    
65. [myisamchk]
    
66. key_buffer_size = 256M
    
67. sort_buffer_size = 256M
    
68. read_buffer = 2M
    
69. write_buffer = 2M
    
70. 
    
71. [mysqlhotcopy]
    
72. interactive_timeout
    
73. 
    
74. [client]
    
75. default-character-set = gbk
    
76. [mysqld]
    
77. default-character-set = gbk
    

复制代码