[mysqld] port=33007 socket=/home/atomic/mysql/srv2/mysql.sock max_connections=20 log-error key_buffer = 8M max_allowed_packet = 1M #table_cache = 125 sort_buffer_size = 8M #net_buffer_length = 8K #read_buffer_size = 16M #read_rnd_buffer_size = 4M #myisam_sort_buffer_size = 32M #myisam_max_sort_file_size = 30G query_cache_size = 32M ft_min_word_len = 3 table_lock_wait_timeout = 86400 join_buffer_size = 8M max_write_lock_count = 2 max_heap_table_size = 32M tmp_table_size = 32M thread_cache = 10 #innodb_data_home_dir = /home/tci/mysql innodb_data_file_path = ibdata1:50M:autoextend innodb_file_per_table innodb_buffer_pool_size = 8M innodb_log_buffer_size = 4M innodb_log_file_size = 32M #innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit = 0 log-bin log-slave-updates replicate-same-server-id=0 master-host = 127.0.0.1 master-user = root master-password = master-port = 33006 server-id = 2 binlog-do-db=TCI replicate-do-table=TCI.Rotation #basedir=/home/atomic/mysql/srv2 datadir=/home/atomic/mysql/srv2 # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid