Skip navigation links

MySQL Forums :: Newbie :: Anyway to identify the special key_buffer_size


Advanced Search

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


Subject Written By Posted
Anyway to identify the special key_buffer_size Money Talks 03/22/2012 11:09PM
Re: Anyway to identify the special key_buffer_size Rick James 03/24/2012 01:22PM
Re: Anyway to identify the special key_buffer_size Money Talks 03/26/2012 02:20AM


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.