only run cron jobs on slaves

[sql.git] / etc / my.cnf

diff --git a/etc/my.cnf b/etc/my.cnf
new file mode 100644 (file)
index 0000000..6df5596
--- /dev/null
+++ b/etc/my.cnf
@@ -0,0 +1,58 @@
+[client]
+socket=/srv/mysql/mysql.sock
+
+[mysql]
+socket=/srv/mysql/mysql.sock
+
+[mysqld]
+datadir=/srv/mysql
+log_slow_queries
+long_query_time=2
+max_connections=5000
+#max_connect_errors=10
+wait_timeout=600
+interactive_timeout=600
+connect_timeout=10
+
+log-bin=sql-bin
+log-bin-index=sql-bin.index
+relay-log=kitchen-sink-relay-bin
+relay-log-index=kitchen-sink-relay-bin.index
+
+skip-locking
+#skip-external-locking
+
+query_cache_limit=1M
+query_cache_size=128M
+query_cache_type=1
+thread_cache_size=8
+table_cache=1024
+key_buffer=400M
+join_buffer=1M
+record_buffer=1M
+max_allowed_packet=16M
+sort_buffer_size=2M
+read_buffer_size=2M
+read_rnd_buffer_size=8M
+tmp_table_size=35M
+thread_concurrency=4
+myisam_sort_buffer_size=8M
+
+innodb_buffer_pool_size=512M
+innodb_additional_mem_pool_size=20M
+innodb_log_file_size=200M
+innodb_log_buffer_size=2M
+#innodb_lock_wait_timeout=50
+
+innodb_file_per_table
+
+old_passwords=1
+server-id=1
+
+skip-bdb
+#skip-networking
+
+[mysqldump]
+quick
+quote-names
+max_allowed_packet      = 16M