# The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] bind-address=172.16.2.100 port = 3306 socket = /tmp/mysql.sock skip-locking # Ernie Settings ################ # # Default key_buffer = 8M key_buffer = 32M # # Default query_cache_size = 0 query_cache_size = 32M # # Default innodb_buffer_pool_size = 8M innodb_buffer_pool_size = 32M # # Default comment out log-bin to disable replication #log-bin # # Default myisam_sort_buffer_size = 8M myisam_sort_buffer_size = 64M # # Default read_buffer_size = 128K read_buffer_size = 2M # # Default sort_buffer_size = 2M sort_buffer_size = 2M # # Default table_cache = 64 table_cache = 512 # # Default thread_cache = 0 thread_cache = 8 # Unaltered Defaults max_allowed_packet = 1M read_rnd_buffer_size = 4M thread_concurrency = 8 # Replication ID server-id = 1 [mysqldump] quick max_allowed_packet = 16M [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