From: Reindl Harald
Date: May 5 2011 6:46pm
Subject: Re: Input needed...
List-Archive: http://lists.mysql.com/mysql/224955
Message-Id: <4DC2F085.2050507@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigE300D265076886D429E7DD9B"

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

please post your my.cnf settings becuase stats are useless without
knowing the configuration and without knowing your hardware (memory!)
nobody can say what buffers are making sense

i would use "mysqltuner.pl" because  it shows in the most cases good advi=
ses

Am 05.05.2011 20:42, schrieb J M:
> Hi,
>=20
>   I have this stats:  I have tuned some of it but I was wondering if so=
meone
> can give inputs regarding it:
>=20
> *
> __ Key ________________________________________________________________=
_
> Buffer used    54.63M of 384.00M  %Used:  14.23
>   Current     123.21M            %Usage:  32.09
> Write hit      99.97%
> Read hit      100.00%
>=20
> __ Questions __________________________________________________________=
_
> Total          87.40M    18.4/s
>   QC Hits      50.63M    10.7/s  %Total:  57.93
>   DMS          24.04M     5.1/s           27.50
>   Com_          8.52M     1.8/s            9.75
>   COM_QUIT      4.24M     0.9/s            4.85
>   -Unknown     28.31k     0.0/s            0.03
> Slow 10 s       9.21k     0.0/s            0.01  %DMS:   0.04  Log: OFF=

> DMS            24.04M     5.1/s           27.50
>   SELECT       21.98M     4.6/s           25.14         91.41
>   UPDATE        1.74M     0.4/s            1.99          7.24
>   INSERT      211.35k     0.0/s            0.24          0.88
>   DELETE      111.77k     0.0/s            0.13          0.46
>   REPLACE           0       0/s            0.00          0.00
> Com_            8.52M     1.8/s            9.75
>   set_option    4.26M     0.9/s            4.87
>   change_db     4.22M     0.9/s            4.83
>   show_table_   9.33k     0.0/s            0.01
>=20
> __ SELECT and Sort ____________________________________________________=
_
> Scan          838.37k     0.2/s %SELECT:   3.81
> Range           2.12M     0.4/s            9.64
> Full join         988     0.0/s            0.00
> Range check         0       0/s            0.00
> Full rng join       0       0/s            0.00
> Sort scan       3.71M     0.8/s
> Sort range      3.63M     0.8/s
> Sort mrg pass  82.85k     0.0/s
>=20
> __ Query Cache ________________________________________________________=
_
> Memory usage    3.75M of  32.00M  %Used:  11.72
> Block Fragmnt  28.39%
> Hits           50.63M    10.7/s
> Inserts        16.38M     3.4/s
> Insrt:Prune   14.39:1     3.2/s
> Hit:Insert     3.09:1
>=20
> __ Table Locks ________________________________________________________=
_
> Waited         53.43k     0.0/s  %Total:   0.17
> Immediate      31.57M     6.6/s
>=20
> __ Tables _____________________________________________________________=
_
> Open              512 of  512    %Cache: 100.00
> Opened          3.02k     0.0/s
>=20
> __ Connections ________________________________________________________=
_
> Max used          145 of  802      %Max:  18.08
> Total           4.24M     0.9/s
>=20
> __ Created Temp _______________________________________________________=
_
> Disk table      3.61M     0.8/s
> Table           3.72M     0.8/s    Size:  16.0M
> File          165.71k     0.0/s
>=20
> __ Threads ____________________________________________________________=
_
> Running            69 of   71
> Cached              0 of    8      %Hit:  99.02
> Created        41.74k     0.0/s
> Slow                0       0/s
>=20
> __ Aborted ____________________________________________________________=
_
> Clients         6.48k     0.0/s
> Connects       25.00k     0.0/s
>=20
> __ Bytes ______________________________________________________________=
_
> Sent            1.18T  247.9k/s
> Received       15.27G    3.2k/s*
>=20

--=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


--------------enigE300D265076886D429E7DD9B
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/

iEYEARECAAYFAk3C8IUACgkQhmBjz394AnkimwCfaRaAYfXXO9R7Cini3fXt52P1
1AcAninnxWuiZXGq/dOQEXZPj4qOgMPd
=QdXp
-----END PGP SIGNATURE-----

--------------enigE300D265076886D429E7DD9B--