From: Reindl Harald
Date: April 9 2012 11:17am
Subject: Re: Remote mysql too slow
List-Archive: http://lists.mysql.com/mysql/227150
Message-Id: <4F82C563.1070306@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigC56553E710DCD91C7BEB5C38"

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



Am 09.04.2012 13:05, schrieb J. Bakshi:
> I have reset these two now
>=20
> ` ` ` `=20
> key_buffer_size=3D200M
> innodb_buffer_pool_size=3D4G

[!!] InnoDB data size / buffer pool: 3.6G/8.0M

there did go something terrible wrong
what is the mysqld log saying at startup?
waht about post your complete my.cnf?

however, you will never get the same perfor,ance as
with a local mysqld if there are many small queries
because all of the queries must go over the wire and
answers back

i notice a hughe performance difference in the mailbackend
if i move the mailserver on the other vmware-host as the
web-backend is running even of gigabit ethernet





--------------enigC56553E710DCD91C7BEB5C38
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.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk+CxWMACgkQhmBjz394AnmTRACffPEJhZQb7azzSt7kIGkOwuS/
pf8An25fSGPKpHV2Ie8hBX+R8rPic0Kp
=HfS5
-----END PGP SIGNATURE-----

--------------enigC56553E710DCD91C7BEB5C38--