key_buffer = 384M max_allowed_packet = 4M table_cache = 1024 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 128M thread_cache = 20 thread_stack = 126976 max_connections = 100 join_buffer_size = 2M max_heap_table_size = 128M tmp_table_size = 128M read_rnd_buffer_size = 2M thread_cache_size = 20 query_cache_type = 1 query_cache_size = 256M query_cache_limit = 2M skip-innodb #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # _log_file_size 는 buffer pool size 의 25% 정도로 설정한다. #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_lock_wait_timeout = 50