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


Advanced Search

Anyway to identify the special key_buffer_size
Posted by: Money Talks ()
Date: March 22, 2012 11:09PM

Hi all,

I set 3 key_buffer_size, one is the default and the other 2 for different table index. In my point, I want to keep a large myisam index into the buffer, which size is up to 3G.

The problem is, Is their anyway to watch the STATUS for those key_buffer_sizes ?

the SHOW STATUS like 'KEY%' is only showed the default one. How about the others?

thks, any help are appreciate.

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.