- Original Message -
> From: "Stdranwl"
>
> So then no use of setting 3G sort buffer in my.cnf untill system will
> take a rebot?
> I was in the impression that 10M will be used and it will be
> scratched to 3G whenever required as same is set globally?
No, you've got it the wrong way ro
So then no use of setting 3G sort buffer in my.cnf untill system will take
a rebot?
I was in the impression that 10M will be used and it will be scratched to
3G whenever required as same is set globally?
On Wed, Nov 30, 2011 at 10:22 PM, Paul DuBois wrote:
> The session value (10M in your case) w
Ok it is fine . but I just wanted to to know on following:
Let say sort_buffer_size is set 10 M and Globally it is set 3G so how it
will be used?
On Wed, Nov 30, 2011 at 8:47 PM, Paul DuBois wrote:
>
> On Nov 30, 2011, at 4:04 AM, Stdranwl wrote:
>
> > Hi
> > I can see different values when
> > DO NOT REPLY OFF-LIST
>
> Also, do not shout :-)
Ugh point taken, but why are you still replying to him off-list? Keep
inboxes clean! ;)
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
- Original Message -
> From: "Reindl Harald"
>
> DO NOT REPLY OFF-LIST
Also, do not shout :-)
> the difference is "set" or "set global"
Same for show, and 'show variables' is implicitly the same as the clearer 'show
session variables'.
> global is what would be used if the thread doe
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.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 please
> revert me on the scope and how they works?
a global variable is global and for all threads
set without global i
