Am 24.10.2011 18:27, schrieb Joey L:
> -------- Performance Metrics -------------------------------------------------
> [--] Up for: 10s (2K q [237.300 qps], 591 conn, TX: 947K, RX: 261K)
> [!!] Key buffer size / total MyISAM indexes: 2.0G/12.0G
> [!!] Key buffer hit rate: 89.9% (5K cached / 524 reads)
>
> I just did some adjustments and used mysqltuner.pl ---any advice ??
> I have 22gigs of ram on the server - so if i need to allocate - i can
mysqltuner after 10 seconds is mostly useless
but "variables to adjust: key_buffer_size (> 12.0G)" is mandatory
since you do not benfit as mach as you can if your keys are permanently
loaded from disk
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
