Mysql 的my.cnf 针对不同门类数据库应用的推荐配置项的具体参数对比

Mysql 的my.cnf 针对不同类型数据库应用的推荐配置项的具体参数对比
Text Compare
Produced: 2012-7-12 15:12:07
   
Mode:  All, With Context, Ignoring Unimportant  
Left file:  my-small.cnf  (小型应用)
Right file: my-medium.cnf  （中型应用）
   [client] [client]   port            = 3306 port            = 3306socket          = /tmp/mysql.sock socket          = /tmp/mysql.sock            [mysqld] [mysqld]port            = 3306 port            = 3306socket          = /tmp/mysql.sock socket          = /tmp/mysql.sockskip-locking skip-lockingkey_buffer_size = 256M<>key_buffer_size = 384Mmax_allowed_packet = 1M=max_allowed_packet = 1Mtable_open_cache = 256<>table_open_cache = 512sort_buffer_size = 1M sort_buffer_size = 2Mread_buffer_size = 1M read_buffer_size = 2Mread_rnd_buffer_size = 4M read_rnd_buffer_size = 8Mmyisam_sort_buffer_size = 64M=myisam_sort_buffer_size = 64Mthread_cache_size = 8 thread_cache_size = 8query_cache_size= 16M<>query_cache_size = 32M = thread_concurrency = 8 thread_concurrency = 8      log-bin=mysql-bin log-bin=mysql-bin      binlog_format=mixed+-  =          server-id       = 1 server-id       = 1         [mysqldump] [mysqldump]quick quickmax_allowed_packet = 16M max_allowed_packet = 16M   [mysql] [mysql]no-auto-rehash no-auto-rehash         [myisamchk] [myisamchk]key_buffer_size = 128M<>key_buffer_size = 256Msort_buffer_size = 128M sort_buffer_size = 256Mread_buffer = 2M=read_buffer = 2Mwrite_buffer = 2M write_buffer = 2M   [mysqlhotcopy] [mysqlhotcopy]interactive-timeout interactive-timeout