From: Reindl Harald
Date: April 25 2011 2:29pm
Subject: Re: Memory Usage.
List-Archive: http://lists.mysql.com/mysql/224856
Message-Id: <4DB58567.6000200@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig63787842790B003DB64585DB"

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


Am 25.04.2011 16:24, schrieb Andr=E9s Tello:
> How can I know how memory is being used by Mysql?
>=20
> I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and=
 even
> that I have tables over 40GB...
>=20
> Thanks! xD

depends on storage-engine (myisam or innodb), buffer-sizes, size
of the query-cache, size of keys - the target is not to use the
full memory, the target is use available momory wise

search for "mysqltuner.pl"

very interesting is the memory per connection (depends on many buffer-par=
ams)
becuase with a little mistake the possible max usage can easily be some
hundret GB!

[--] Up for: 17d 21h 53m 13s (39M q [25.329 qps], 132K conn, TX: 60B, RX:=
 19B)
[--] Reads / Writes: 67% / 33%
[--] Total buffers: 6.1G global + 1.2M per thread (500 max threads)
[OK] Maximum possible memory usage: 6.7G (66% of installed RAM)
[OK] Slow queries: 0% (13/39M)
[OK] Highest usage of available connections: 72% (362/500)
[OK] Key buffer size / total MyISAM indexes: 128.0M/74.1M
[OK] Key buffer hit rate: 97.6% (109M cached / 2M reads)
[OK] Query cache efficiency: 73.8% (23M cached / 32M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (247 temp sorts / 731K sorts)
[OK] Temporary tables created on disk: 0% (1K on disk / 1M total)
[OK] Thread cache hit rate: 99% (362 created / 132K connections)
[!!] Table cache hit rate: 8% (131 open / 1K opened)
[OK] Open file limit used: 0% (67/30K)
[OK] Table locks acquired immediately: 99% (18M immediate / 18M locks)
[!!] InnoDB data size / buffer pool: 16.6G/5.0G

--=20

Mit besten Gr=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm


--------------enig63787842790B003DB64585DB
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 Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk21hWcACgkQhmBjz394AnmOpQCeL6F2pwujBSRU5Ml2Y/cD/Gk8
KhAAn27/hyCAX95t1n/kR+QVUzBfWF0K
=H6KD
-----END PGP SIGNATURE-----

--------------enig63787842790B003DB64585DB--