[client] port = 3306 socket = /home/mysql/data/mysql.sock [mysqld] user = mysql #bind-address = 127.0.0.1 socket = /home/mysql/data/mysql.sock port = 3306 server-id = 1 skip-locking skip-networking skip-name-resolve skip-external-locking local-infile = 0 key_buffer_size = 64M sort_buffer_size = 4M read_buffer_size = 1M read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M max_allowed_packet = 2G net_buffer_length = 8K thread_stack = 128K thread_cache = 8 table_cache = 256 query_cache_type = 1 query_cache_size = 32M query_cache_limit = 1M thread_concurrency = 2 innodb_buffer_pool_size = 32M innodb_additional_mem_pool_size = 4M innodb_data_home_dir = /home/mysql/data/ innodb_log_arch_dir = /home/mysql/data/ innodb_log_group_home_dir = /home/mysql/data/ innodb_data_file_path = innodb1:250M:autoextend innodb_log_file_size = 8M innodb_log_buffer_size = 8M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 2G [mysql] #no-auto-rehash #safe-updates [isamchk] key_buffer_size = 64M sort_buffer_size = 4M read_buffer_size = 1M write_buffer_size = 1M [myisamchk] key_buffer_size = 64M sort_buffer_size = 4M read_buffer_size = 1M write_buffer_size = 1M [mysqlhotcopy] interactive-timeout