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