|
|
发表于 2014-12-9 19:42:22
|
显示全部楼层
本帖最后由 cst4you 于 2014-12-9 19:45 编辑
内存真多, 其实用不完, 这个量级2G内存就够了.
友情送你个卖站之前的配置吧, 主要还是WP还是得靠缓存, 什么都拿内存顶, mysql差不多就行了.
- [mysqld]
- port = 3306
- socket = /tmp/mysql.sock
- interactive_timeout = 30
- wait_timeout = 60
- connect_timeout = 60
- ft_min_word_len=2
- default-storage-engine=MyISAM
- skip-innodb
- ;skip-locking
- skip-name-resolve
- low-priority-updates
- key_buffer_size = 192M
- sort_buffer_size = 6M
- read_buffer_size = 4M
- read_rnd_buffer_size = 4M
- join_buffer_size = 3M
- table_cache = 2560
- table_definition_cache = 512
- max_connections = 500
- max_join_size = 4294967295
- myisam_sort_buffer_size = 4M
- thread_cache = 32
- thread_cache_size = 256
- query_cache_limit= 8M
- query_cache_size = 128M
- query_cache_type = 1
- max_connect_errors= 50
- max_allowed_packet= 16M
- tmp_table_size = 384M
- net_buffer_length = 32768
- slow_query_log = 1
- log-queries-not-using-indexes = 0
- slow_query_log_file = /tmp/slowquery.log
- general_log = 0
- general_log_file = /tmp/mysql.log
- # Try number of CPU's*2 for thread_concurrency
- thread_concurrency = 12
不要问我为什么这么配. 当然这个参数也是针对当时2G内存的机器配的, 你16G的话, 参数意思自己研究修改下吧. |
|
晕死，你又没有当前运行情况的图，就说优化，你知道现在的瓶颈在哪里才能提优化啊。
楼主