Page 1 of 1

mysql key buffer

Posted: Fri Mar 16, 2007 3:42 pm
by GeXus
I just instead mysql administrator and there are two questions i have..

1. My key efficiency is at 100%, which I believe means i need to increase my key buffer size, is that correct?

2. I can't view logs because im not connected as localhost, is there a way to remotely connect via localhost?

thanks!

Re: mysql key buffer

Posted: Sat Mar 17, 2007 6:50 am
by volka
GeXus wrote:I just instead mysql administrator and there are two questions i have..

1. My key efficiency is at 100%, which I believe means i need to increase my key buffer size, is that correct?
It was a 50:50 chance ;)
http://dev.mysql.com/doc/administrator/en/mysql-administrator-health-memory-health.html wrote:Key Efficiency: [...]
The higher the hit rate the more effective your key buffer is. A low hit rate can indicate that you need to increase the size of your keycache.
2. I can't view logs because im not connected as localhost, is there a way to remotely connect via localhost?
No, "localhost" and "remote" are mutually exclusive.
http://dev.mysql.com/doc/administrator/en/mysql-administrator-server-logs-introduction.html wrote:You can only view log files that are stored on the machine where MySQL Administrator is running, you cannot view log files on a remote machine.

Re: mysql key buffer

Posted: Sat Mar 17, 2007 2:10 pm
by GeXus
Ah right in mysql docs ;-)

Thanks!

volka wrote:
GeXus wrote:I just instead mysql administrator and there are two questions i have..

1. My key efficiency is at 100%, which I believe means i need to increase my key buffer size, is that correct?
It was a 50:50 chance ;)
http://dev.mysql.com/doc/administrator/en/mysql-administrator-health-memory-health.html wrote:Key Efficiency: [...]
The higher the hit rate the more effective your key buffer is. A low hit rate can indicate that you need to increase the size of your keycache.
2. I can't view logs because im not connected as localhost, is there a way to remotely connect via localhost?
No, "localhost" and "remote" are mutually exclusive.
http://dev.mysql.com/doc/administrator/en/mysql-administrator-server-logs-introduction.html wrote:You can only view log files that are stored on the machine where MySQL Administrator is running, you cannot view log files on a remote machine.