MySql数据库（环境）的配置方法

参考地址：http://www.cnblogs.com/bookwed/p/5896619.html

#MySql的配置文件差别：

[root@VM_37_112_centos support-files]# dir
binary-configure   my-huge.cnf             mysql-log-rotate
config.huge.ini    my-innodb-heavy-4G.cnf  mysql.server
config.medium.ini  my-large.cnf            mysqld_multi.server
config.small.ini      my-medium.cnf           ndb-config-2-node.ini
magic                   my-small.cnf

LARGE
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8




MEDIUM
# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M




SMALL~
# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K