From: Reindl Harald
Date: November 30 2011 10:35am
Subject: Re: Global Variables
List-Archive: http://lists.mysql.com/mysql/226396
Message-Id: <4ED60703.9060809@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig92AEC064FAFC5B47A075D7DC"

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

DO NOT REPLY OFF-LIST

i do not understand what is unclear

you can set variables per sql and my.cnf
most of them, not all

the difference is "set" or "set global"
global is what would be used if the thread does not change it

the same as in php set a value per "php.ini" or ".htaccess"

Am 30.11.2011 11:28, schrieb Stdranwl:
> Thnx... So does it mean that global value is accumulative values and it=
 is the limit/end=20
> of the value which can be assigned.?
>=20
> On Wed, Nov 30, 2011 at 3:53 PM, Reindl Harald <h.reindl@stripped =
<mailto:h.reindl@stripped>> wrote:
>=20
>=20
>=20
>     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 pl=
ease
>     > revert me on the scope and how they works?
>=20
>     a global variable is global and for all threads
>     set without global is only for the current connection
>=20
>=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


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

iEYEARECAAYFAk7WBwMACgkQhmBjz394AnlbzQCfRNJE28KYbPQBQV6BvtJH67x+
/1AAni5C14zBa+RhzQz0vqDWS5fw7z20
=KAAV
-----END PGP SIGNATURE-----

--------------enig92AEC064FAFC5B47A075D7DC--