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 <paul.dub...@oracle.com>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.dub...@oracle.com> > wrote: > > > > 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 please > > > 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 > www.mysql.com > >
