List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:April 1 2010 10:23am
Subject:Re: MySQLTuner
View as plain text  
>
> - 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

Thread
MySQLTunersangprabv1 Apr
  • Re: MySQLTunerRaj Shekhar1 Apr
    • Re: MySQLTunerJohan De Meersman1 Apr
  • Re: MySQLTunerRob Wultsch4 Apr