new "performance test" accuracy
Installation and Configuration
for 16Gig I would go:
key_buffer = 1024M
max_allowed_packet = 32M
thread_stack = 192K
thread_cache_size = 8
table_cache = 1536
table_definition_cache = 1536
open_files_limit = 2048
tmp_table_size = 256M
max_heap_table_size = 256M
thread_concurrency = 8
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 768K
max_connections = 200
innodb_buffer_pool_size = 1024M
innodb_flush_method = O_DIRECTShould be good.
Hope this helps!
