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