MySQL Forums
Forum List  »  Newbie

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

Written By
Anyway to identify the special key_buffer_size
March 22, 2012 11:09PM

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.