安装好Kloxo后，在CentOS中内存占用量会达到150M左右，对于小内存的VPS,比如256M左右的，一旦到访问高峰期，内存有可能会突破256M而导致内存溢出。

刚安装好Kloxo后，MySQL进程占用了大约20M的内存，我们可以修改etc/my.cnf文件来降低MySQL的内存占用量。
打开etc/my.cnf，在[mysqld]的后面加上如下代码：

skip-external-locking
skip-slave-start
skip-bdb
skip-innodb
skip-name-resolve

# Global mem settings
key_buffer = 24M

max_connections = 200

# Per client mem settings

sort_buffer_size = 4M
read_buffer_size = 4M
binlog_cache_size = 2M

max_allowed_packet = 12M
thread_stack = 128K

table_cache = 128
thread_cache = 256
thread_concurrency = 4

myisam_sort_buffer_size = 1M
tmp_table_size = 12M
max_heap_table_size = 12M

wait_timeout = 200
interactive_timeout = 300
max_connect_errors = 10000

query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 16M

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

然后执行service mysqld restart重启MySQL。

文章的脚注信息由WordPress的wp-posturl插件自动生成

转载请注明：VPS面板知识 » kloxo优化-Mysql优化