KLOXO数据库优化

找到Mysql的配置文件路径/etc/my.cnf

Mysql下面添加以下参数：

port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache 
= 4 sort_buffer_size = 64K read_buffer_size =
 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K skip-bdb skip-innodb [mysqldump]
 quick max_allowed_packet = 16M [mysql] 
no-auto-rehash #safe-updates [isamchk] key_buffer = 8M sort_buffer_size = 8M [myisamchk] key_buffer = 8M sort_buffer_size
 = 8M [mysqlhotcopy] interactive-timeout

保存之后在重启MYSQL

命令：

/sbin/service mysqld restart