[client] port = 3306 socket = /opt/local/var/run/mysql5/mysqld.sock #socket = /tmp/mysql.sock default-character-set = utf8 [mysql] default-character-set = utf8 no-auto-rehash [mysqladmin] default-character-set = utf8 [mysqlcheck] default-character-set = utf8 [mysqldump] default-character-set = utf8 quick max_allowed_packet = 16M [mysqlimport] default-character-set = utf8 [mysqlshow] default-character-set = utf8 [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld] character-set-server = utf8 default-character-set = utf8 port = 3306 socket = /opt/local/var/run/mysql5/mysqld.sock skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M skip-networking slow_query_log = 1 slow_query_log_file = /var/log/mysql-slow.log log-error = /var/log/mysql.log thread_cache_size = 16 query_cache_size = 32M max_connections = 50 expire_logs_days = 5 innodb_data_home_dir = /opt/local/var/db/mysql5/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /opt/local/var/db/mysql5/ innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50