mysql key buffer

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

mysql key buffer

Post 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!
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Re: mysql key buffer

Post 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.
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Re: mysql key buffer

Post 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.
Post Reply