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 c
>
> - 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
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%
[!!] Table cache hit rate: 5%
And mysqltuner recommends to adjust these
Hi list,
I have problem with mysqltuner result. My server has 1 2.2G quadcore
proccessor, 16GB RAM and with this my.cnf configuration:
# * Fine Tuning
#
key_buffer = 8G
max_allowed_packet = 2G
thread_stack= 4M
thread_cache_size = 256
key_buffer_size
