> - Analyze your SELECT queries to see which tables are used most often and
> increase the key buffer size to hold at least the indexes from those
> table in the memory. (the 80/20 rule might be applicable here)
Additionally, have a look around the documentation for named key buffer
pools, and allocate the most-used indices to a separate pool so they're
always in-memory, even when the default pool is filling up.
Keep in mind, indices will still be faster than a full tablescan, even if
they're read from disk; so it's no disaster to leave some of the lesser-used
ones out of memory.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel