4 messages in com.mysql.lists.mysqlpowers of two in my.cnf ?
FromSent OnAttachments
matthew mcglynn01 Apr 1999 21:29 
Michael Widenius02 Apr 1999 03:07 
jkr...@murl.com02 Apr 1999 08:49 
Sasha Pachev02 Apr 1999 09:17 
Subject:powers of two in my.cnf ?
From:matthew mcglynn (mcgl@netjet.com)
Date:04/01/1999 09:29:03 PM
List:com.mysql.lists.mysql

This is probably a really dumb question...

Every example of buffer settings I've seen has used powers of two. For example, from the sample configuration file: set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = max_allowed_packet=16M set-variable = keybuffer=16M

Similarly, the default table_cache is 64, and when people ask on this list about running out of file descriptors, the response is usually "set table_cache to 32".

My dumb question is: do these have to all be powers of two ?!

If for my application, a table_cache of 128 is insufficient, can I bump it to 150 or do I need to go all the way to 256 ?