Reto Baumann wrote:
Is there a way to see if the key buffer size was ever reached?
It's not really an issue. You can determine how frequently it
has the needed index data in memory, to judge the key buffer
efficiency.
Key read requests 3518220013
Key reads 94807
Key reads / Key read requests = Shows percentage of time that
mysql couldn't resolve the key read from the buffer.
In your case, it's 0.003%. So 0.003% of the time, mysql had
to go the disk to read the index! I'd say that your key
buffer is performing well!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
