这个Mysql怎么优化

vvx.cc

1. # mysql conf /etc/my.cnf
   
2. 
   
3. [client]
   
4. port                = 3306
   
5. socket                = /tmp/mysql.sock
   
6. [mysqld]
   
7. port                = 3306
   
8. socket                = /tmp/mysql.sock
   
9. skip-external-locking
   
10. key_buffer_size = 128M
    
11. max_allowed_packet = 1M
    
12. table_open_cache = 256
    
13. sort_buffer_size = 1M
    
14. read_buffer_size = 1M
    
15. read_rnd_buffer_size = 2M
    
16. myisam_sort_buffer_size = 8M
    
17. thread_cache_size = 8
    
18. query_cache_size= 16M
    
19. thread_concurrency = 8
    
20. max_connections = 300
    
21. wait_timeout = 30
    
22. interactive_timeout = 30
    
23. max_connect_errors = 9
    
24. long_query_time = 1
    
25. tmp_table_size = 16M
    
26. #log-bin=mysql-bin
    
27. #binlog_format=mixed
    
28. #server-id        = 1
    
29. [mysqldump]
    
30. quick
    
31. max_allowed_packet = 8M
    
32. [mysql]
    
33. no-auto-rehash
    
34. [myisamchk]
    
35. key_buffer_size = 12M
    
36. sort_buffer_size = 1M
    
37. read_buffer = 1M
    
38. write_buffer = 1M
    
39. [mysqlhotcopy]
    
40. interactive-timeout

复制代码

vip1

帮定

vvx.cc

skip-locking
skip-bdb
skip-innodb
这3个不管用，放上去就无法启动mysql

znithy

原帖由 vvx.cc 于 2011-6-28 21:50 发表
skip-locking
skip-bdb
skip-innodb
这3个不管用，放上去就无法启动mysql

换成如下就行了：
loose-skip-innodb
skip-external-locking

vvx.cc

loose-skip-innodb
skip-external-locking
这两个换上去，只能减去100M

webproxy

100M还少

wdlth

你是要优化性能还是内存？

lyylts

innodb都舍弃了，还用mysql干啥..

citydog

原帖由 webproxy 于 2011-6-28 22:33 发表
100M还少