[mysqld] delayed_queue_size=10000 max_connections=64 log_warnings log_slow_queries long_query_time=7 log_long_format skip-bdb # Basic InnoDB settings innodb_file_per_table innodb_open_files=2048 innodb_buffer_pool_size=256M innodb_log_file_size=256M # 11/01/08: O_DIRECT flushing uses O_DIRECT to open the data files so they # bypass the disk cache and fsync() to flush both the data and log files innodb_flush_method=O_DIRECT key_buffer_size = 256M max_allowed_packet = 16M table_cache = 512 sort_buffer_size = 8M join_buffer_size = 8M myisam_sort_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 1M thread_cache = 8 query_cache_size = 16M query_cache_limit = 4M [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 512M sort_buffer_size = 1024M read_buffer = 16M write_buffer = 16M