编译完成MySQL后关于.cnf的选择说明

Read

编译安装完成后，可以在MySQL解压目录的support-files目录中找到如下四个文件：
my-huge.cnf(庞大应用),my-large.cnf(大型应用),my-medium.cnf(中型应用),my-small.cnf(小型应用)

[root@mysql support-files]# egrep -v "#" my-small.cnf >nomy-small.cnf
[root@mysql support-files]# egrep -v "#" my-medium.cnf >nomy-medium.cnf
[root@mysql support-files]# diff nomy-*
11c11
< key_buffer_size = 16M
---
> key_buffer_size = 16K
13,15c13,14
< table_open_cache = 64
< sort_buffer_size = 512K
< net_buffer_length = 8K
---
> table_open_cache = 4
> sort_buffer_size = 64K
17,18c16,18
< read_rnd_buffer_size = 512K
< myisam_sort_buffer_size = 8M
---
> read_rnd_buffer_size = 256K
> net_buffer_length = 2K
> thread_stack = 128K
19a20
> server-id	= 1
21,23d21
< log-bin=mysql-bin
< 
< binlog_format=mixed
25d22
< server-id	= 1
37,40c34,35
< key_buffer_size = 20M
< sort_buffer_size = 20M
< read_buffer = 2M
< write_buffer = 2M
---
> key_buffer_size = 8M
> sort_buffer_size = 8M