So then no use of setting 3G sort buffer in my.cnf untill system will take
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 <paul.dubois@stripped>wrote:
> The session value (10M in your case) will be used for queries issued in
> that session.
> On Nov 30, 2011, at 9:38 AM, Stdranwl wrote:
> > 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 <paul.dubois@stripped>
> > On Nov 30, 2011, at 4:04 AM, Stdranwl wrote:
> > > Hi
> > > I can see different values when I run show global variables like
> > > ............. && show variables like .........? could any body
> > > revert me on the scope and how they works?
> > These sections of the MySQL manual may be of interest:
> > http://dev.mysql.com/doc/refman/5.5/en/using-system-variables.html
> > http://dev.mysql.com/doc/refman/5.5/en/show-variables.html
> > http://dev.mysql.com/doc/refman/5.5/en/set-option.html
> > Individual variable descriptions are here:
> > http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html
> > "Dynamic" means a variable can be set at runtime with SET.
> > --
> > Paul DuBois
> > Oracle Corporation / MySQL Documentation Team
> > Madison, Wisconsin, USA
> > www.mysql.com
> Paul DuBois
> Oracle Corporation / MySQL Documentation Team
> Madison, Wisconsin, USA