linwuliao

1. [client]
   
2. port            = 3306
   
3. socket          = /tmp/mysql.sock
   
4. [mysqld]
   
5. port            = 3306
   
6. socket          = /tmp/mysql.sock
   
7. skip-external-locking
   
8. back_log = 50
   
9. max_connections = 300
   
10. max_connect_errors = 10
    
11. table_open_cache = 1024
    
12. max_allowed_packet = 16M
    
13. binlog_cache_size = 1M
    
14. max_heap_table_size = 64M
    
15. read_buffer_size = 2M
    
16. read_rnd_buffer_size = 8M
    
17. sort_buffer_size = 2M
    
18. join_buffer_size = 2M
    
19. thread_cache_size = 8
    
20. thread_concurrency = 8
    
21. query_cache_size = 64M
    
22. query_cache_limit = 1M
    
23. ft_min_word_len = 4
    
24. default-storage-engine = MYISAM
    
25. thread_stack = 192K
    
26. transaction_isolation = REPEATABLE-READ
    
27. tmp_table_size = 64M
    
28. #log-bin=mysql-bin
    
29. #binlog_format=mixed
    
30. #server-id = 1
    
31. key_buffer_size = 32M
    
32. bulk_insert_buffer_size = 64M
    
33. myisam_sort_buffer_size = 128M
    
34. myisam_max_sort_file_size = 5G
    
35. myisam_repair_threads = 1
    
36. myisam_recover
    
37. innodb_additional_mem_pool_size = 16M
    
38. innodb_buffer_pool_size = 2G
    
39. innodb_data_file_path = ibdata1:10M:autoextend
    
40. innodb_file_io_threads = 4
    
41. innodb_thread_concurrency = 16
    
42. innodb_flush_log_at_trx_commit = 1
    
43. innodb_log_buffer_size = 8M
    
44. innodb_log_file_size = 256M
    
45. innodb_log_files_in_group = 3
    
46. innodb_max_dirty_pages_pct = 90
    
47. innodb_lock_wait_timeout = 120
    
48. [mysqldump]
    
49. quick
    
50. max_allowed_packet = 16M
    
51. [mysql]
    
52. no-auto-rehash
    
53. [myisamchk]
    
54. key_buffer_size = 256M
    
55. sort_buffer_size = 256M
    
56. read_buffer = 8M
    
57. write_buffer = 8M
    
58. [mysqlhotcopy]
    
59. interactive-timeout
    
60. [mysqld_safe]
    
61. open-files-limit = 8192

復制代碼

用這個配置文件