Anyway to identify the special key_buffer_size
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.
Subject
Written By
Posted
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.