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 > of the value which can be assigned.? > > On Wed, Nov 30, 2011 at 3:53 PM, Reindl Harald <h.rei...@thelounge.net > <mailto:h.rei...@thelounge.net>> wrote: > > > > 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 > > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 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
signature.asc
Description: OpenPGP digital signature