key_buffer_size > indexes' size?

[jcn50]

Hello all,

First of all: thanks for this great forum!

I was wondering if the key_buffer_size should always be superior to the total size of all indexes?..

For example, let’s say all my indexes takes a 16M space, should I tweak the key_buffer_size to 17M?

Thanks!

[Peter]

It depends on a lot of factors.

If your key buffer is bigger than index it means all your index will fit in key cache, which is good. This is however impossible for large databases.

Plus you need to think about other needs - innodb buffer pool, memory for OS to cache MyISAM table data etc.

If you have memory for all of these sure go ahead and do it.

[allworknoplay]

I wish my indexes only totaled up to 16megs!!!