>>>>> "Steven" == Steven Roussey <sroussey@stripped> writes:
Steven> | Key_blocks_used | 15641 |
Steven> | Key_read_requests | 5281821 |
Steven> | Key_reads | 23716 |
Note that when tables are closed (because they don't fit the table
cache or someone does a 'flush tables'),
the key cache will of course be flushed for all entries belonging to
Steven> I upped the key_buffer to 12MB and after a couple of hours, I have the
Steven> above. Should be keep increasing the key_buffer? It seems to me that we
Steven> could increase it to 80MB and it would still all be used! I don't think we
Steven> have the memory to try that however... Also the ratio you mentioned dropped
Steven> changed to about 226. This may be worse due the fact that the server has not
Steven> been running as long this time, but I don't know...
The above doesn't look that bad. Just keep an eye on it from time to
time that the ratio doesn't change too much ...