[mysql] no-auto-rehash default-character-set=utf8 [client] port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs ####################################### The MySQL server #[mysql_cluster] #ndb-connectstring=192.168.1.112 # the IP of the MANAGMENT (THIRD) SERVER [mysqld] #ndbcluster #ndb-connectstring=192.168.1.112 # the IP of the MANAGMENT (THIRD) SERVER default-storage-engine=innodb binlog_format=row log_error=host25.err log-bin=binlog lower_case_table_names =1 max_connections=1024 port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 16M read_buffer_size = 8M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 16M thread_cache_size =30 thread_stack=192k query_cache_size= 0M tmp_table_size=80M thread_concurrency = 8 default-character-set=utf8 log-warnings = 2 innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 20M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_file_io_threads=4 innodb_thread_concurrency=16 skip-slave-start server-id = 3 log-slave-updates relay-log=localhost-relay-bin #innodb_flush_logs_at_trx_commit = 1 sync-binlog = 1 #innodb_safe_binlog innodb_data_home_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysql auto_increment_increment = 10 auto_increment_offset = 3 default-character-set=utf8 replicate_ignore_db=pdnstest collation-server=utf8_bin default-collation=utf8_bin ############################################################### [mysqldump] quick max_allowed_packet = 16M default-character-set=utf8 [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout