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!
mysql key buffer
Moderator: General Moderators
Re: mysql key buffer
It was a 50:50 chanceGeXus 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?
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.
No, "localhost" and "remote" are mutually exclusive.2. I can't view logs because im not connected as localhost, is there a way to remotely connect via localhost?
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
Ah right in mysql docs 
Thanks!
Thanks!
volka wrote:It was a 50:50 chanceGeXus 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?
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.No, "localhost" and "remote" are mutually exclusive.2. I can't view logs because im not connected as localhost, is there a way to remotely connect via localhost?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.