MySQL Forums
Forum List  »  Install & Repo

Mysql Tuning (Hitrate - keybuffer)
Posted by: Ronan O'Connor
Date: August 06, 2004 04:18AM

Our database machine (Redhat 7, Mysql3.23, 1G Ram) has started to hit very high loads over the past week or so. Using the Mysql administrator tool, and checking the memory health, I see the "hitrate" for the key_buffer (key efficiency) is at 100%. I've increased the size of the key_buffer_size variable, but no change. Any ideas?

On average there are about 120 simultaneous connections, The server has about 15 databases with about 50 tables altogether, of which only about 6 tables are heavily used. Any other tuning tips?



Options: ReplyQuote

Written By
Mysql Tuning (Hitrate - keybuffer)
August 06, 2004 04:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.