From: Reindl Harald Date: November 30 2011 10:23am Subject: Re: Global Variables List-Archive: http://lists.mysql.com/mysql/226395 Message-Id: <4ED6041F.4090101@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig76AD4FA6E7A7DCA52BF24C70" --------------enig76AD4FA6E7A7DCA52BF24C70 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 30.11.2011 11:04, schrieb Stdranwl: > Hi > I can see different values when I run show global variables like > ............. && show variables like .........? could any body please > revert me on the scope and how they works? a global variable is global and for all threads set without global is only for the current connection --------------enig76AD4FA6E7A7DCA52BF24C70 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/ iEYEARECAAYFAk7WBB8ACgkQhmBjz394AnniCwCfQ9ytKz38Fy/utqRRHge5LvEG n9MAn0/CBbDZA52lO3MVcBNI8k6FAu/s =iEjT -----END PGP SIGNATURE----- --------------enig76AD4FA6E7A7DCA52BF24C70--