[mysqld] ## ## Set log-bin, log-slave-updates to allow chaining ## server-id = 2 log-bin = /var/log/mysql/mysql-bin.log max_binlog_size = 104857600 ## ## you can focus or ignore on certain updates to replicate ## to conduct queries without affecting the binary log, ## use set_bin_log=0 before your query ## # binlog-do-db = database_name # binlog-ignore-db = database_name # replicate-ignore-db = database_name # replicate-ignore-table = table_name # normal stuff below user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K query_cache_limit = 1048576 query_cache_size = 16777216 query_cache_type = 1 skip-bdb [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0