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