On Wed, Mar 31, 2010 at 9:47 PM, sangprabv wrote:
> Hi,
> I run mysqltuner this morning and I got these warning:
> [!!] Key buffer size / total MyISAM indexes: 12.0G/23.2G
> [!!] Key buffer hit rate: 76.9%
> [!!] Query cache efficiency: 0.0%
> [!!] Temporary tables created on disk: 27%
> [!!] Ta
>
> - 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, a
In infinite wisdom sangprabv wrote:
> My physical RAM is only 16Gb. I am afraid it will freezed the server
> if I set key_buffer_size (> 23.2G). Any suggestion to optimize it?
> Thanks for any response.
>
IIRC, on Linux, Mysql will scale back the settings it sees that you are
trying to alloca
