MySQL Forums
Forum List  »  Newbie

Re: Anyway to identify the special key_buffer_size
Posted by: Rick James
Date: March 24, 2012 01:22PM

How much RAM do you have? Remember to leave room for caching of _data_ blocks.

I don't know of a way to dig into the stats for each key_buffer.

I find that manually splitting things leads to more hassles, and often lowered performance.
* Splitting index/data across disk volumes
* Splitting tables across disk volumes
* Assigning tables(etc) to "tablespaces" and the like (this includes key_buffers)
* PARTITION (in some situations)
* Connection pooling

OTOH, some splits do make sense, and do improve performance:
* InnoDB buffer_pools
* Single, large, volume with files spread across them
* RAID striping
* PARTITIONs (in some situations)

Hmmm... What the last set has in common is that "I am not controlling the splits".

Options: ReplyQuote

Written By
Re: Anyway to identify the special key_buffer_size
March 24, 2012 01:22PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.