May 24, 2012

Comment: MySQL: what read_buffer_size value is optimal ?

… the buffers to 128 kbyte? I put this in my my.cnf: key_buffer_size = 256M sort_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K join_buffer_size = 128K myisam_sort_buffer_size… to the my.cnf): key_buffer_size 268435456 sort_buffer_size 131064 read_buffer_size 126976 read_rnd_buffer_size 126976 join_buffer_size 126976 myisam_sort_buffer_size 131072 The key_buff shows the…

Comment: FreeBSD tests

size=1M \ –max_heap_table_size=64M \ –sort_buffer_size=64K \ –join_buffer_size=1M \ –thread_cache=16 \ –thread_concurrency=16 \ –thread_stack=196K \ –query_cache_size