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
signature.asc
Description: OpenPGP digital signature
