worcester:/ux0/mysql # diff -u my.cnf my-innodb-heavy-4G.cnf | sed -e '/^.*#/d' --- my.cnf Wed Jul 11 11:06:25 2007 +++ my-innodb-heavy-4G.cnf Mon Jul 9 14:19:25 2007 @@ -65,7 +65,7 @@ -max_connections = 150 +max_connections = 100 @@ -92,7 +92,7 @@ -max_allowed_packet = 32M +max_allowed_packet = 16M @@ -102,7 +102,7 @@ -binlog_cache_size = 16M +binlog_cache_size = 1M @@ -151,7 +151,7 @@ -query_cache_limit = 4M +query_cache_limit = 2M @@ -167,7 +167,7 @@ -default_table_type = INNODB +default_table_type = MYISAM @@ -189,8 +189,7 @@ -log-bin = /ux0/mysql/mysql-bin.log -binlog_format = MIXED +log-bin=mysql-bin @@ -243,7 +242,6 @@ server-id = 1 -expire_logs_days = 5 @@ -283,16 +281,15 @@ - @@ -367,10 +364,6 @@ -innodb_data_home_dir = /ux0/mysql/innodb - @@ -396,6 +389,10 @@ innodb_data_file_path = ibdata1:10M:autoextend + @@ -437,7 +434,7 @@ -innodb_log_file_size = 512M +innodb_log_file_size = 256M @@ -446,8 +443,7 @@ -innodb_log_group_home_dir = /ux0/mysql/innodb -innodb_log_arch_dir = /ux0/mysql/innodb @@ -458,7 +454,7 @@ @@ -475,7 +471,7 @@ quick -max_allowed_packet = 64M +max_allowed_packet = 16M [mysql] no-auto-rehash