From: Reindl Harald
Date: October 24 2011 4:35pm
Subject: Re: large temp files created by mysql
List-Archive: http://lists.mysql.com/mysql/226171
Message-Id: <4EA593DF.1010902@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig5DB21DEE4B6A0FF9EEA6AA2C"

--------------enig5DB21DEE4B6A0FF9EEA6AA2C
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



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


--------------enig5DB21DEE4B6A0FF9EEA6AA2C
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6lk+AACgkQhmBjz394AnmsZQCfYwypQl9rzYxj3lwwJGsynFdh
z5wAn1l5H+NU3H5haelwRLcIM7Es1haO
=qtfe
-----END PGP SIGNATURE-----

--------------enig5DB21DEE4B6A0FF9EEA6AA2C--