duncanh

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