编译安装完成后，可以在MySQL解压目录的support-files目录中找到如下四个文件：
my-huge.cnf(庞大应用),my-large.cnf(大型应用),my-medium.cnf(中型应用),my-small.cnf(小型应用)
|
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
[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 |
申明：本文由BYRD原创(基于Mysql5.6.16)，未经许可禁止转载！ 文 章 源 自 note.t4x.orgByrd's Blog-https://note.t4x.org/database/choice-mysql-cnf/
申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!
