[client] port = 3306 socket=/var/lib/mysql/mysql.sock default-character-set = utf8 # Here follows entries for some specific programs # The MySQL server [mysqld] character-set-server = utf8 collation_server = utf8_general_ci innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table innodb_log_file_size=64M innodb_buffer_pool_size=64M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql port = 3306 skip-external-locking skip-name-resolve key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 max-connections = 64 #log = /tmp/mysql.log #log-bin server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M