Hello,
what system variables of mysqld can be changed on fly?
thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--000e0ce005e61c2ab50493484862
Content-Type: text/plain; charset=ISO-8859-1
Here you get all details:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html
All the Dynamic variable can be change on fly eg.
wait_timeout
..
On Sat, Oct 23, 2010 at 6:07 PM, wroxdb
> Hello,
>
> what system variables of mysqld can be changed on fly?
>
> thanks.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
--000e0ce005e61c2ab50493484862--
--20cf301d41c05b322404934b7a8c
Content-Type: text/plain; charset=ISO-8859-1
Just a little note:
sometimes, if you are in command line session, you will not see the change
of the dynamic variable unless you logout and in again,
so in case you change the value of a dynamic variable but still the "show
variables" shows you the old value, dont panic!
exit mysql client and enter again.
Aloha!
Claudio
2010/10/23 Prabhat Kumar
> Here you get all details:
>
> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html
>
> All the Dynamic variable can be change on fly eg.
> wait_timeout<
> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysvar_wait_timeout
> >
> .
>
>
> On Sat, Oct 23, 2010 at 6:07 PM, wroxdb
>
> > Hello,
> >
> > what system variables of mysqld can be changed on fly?
> >
> > thanks.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
> >
> >
>
>
> --
> Best Regards,
>
> Prabhat Kumar
> MySQL DBA
>
> My Blog: http://adminlinux.blogspot.com
> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>
--
Claudio
--20cf301d41c05b322404934b7a8c--
> exit mysql client and enter again.
Instead of exit client and enter again, just type \r (reconnect)
and you have a new session.
On 10/23/2010 06:44 PM, Claudio Nanni wrote:
> Just a little note:
>
> sometimes, if you are in command line session, you will not see the change
> of the dynamic variable unless you logout and in again,
> so in case you change the value of a dynamic variable but still the "show
> variables" shows you the old value, dont panic!
> exit mysql client and enter again.
>
> Aloha!
>
> Claudio
>
>
>
> 2010/10/23 Prabhat Kumar
>
>> Here you get all details:
>>
>> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html
>>
>> All the Dynamic variable can be change on fly eg.
>> wait_timeout<
>> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysvar_wait_timeout
>> .
>>
>>
>> On Sat, Oct 23, 2010 at 6:07 PM, wroxdb
>>
>>> Hello,
>>>
>>> what system variables of mysqld can be changed on fly?
>>>
>>> thanks.
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:
>>> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>>>
>>>
>>
>> --
>> Best Regards,
>>
>> Prabhat Kumar
>> MySQL DBA
>>
>> My Blog: http://adminlinux.blogspot.com
>> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--002215047c9bb9828804935aedf0
Content-Type: text/plain; charset=ISO-8859-1
Changes to global variables will indeed not affect the instantiated local
session variables. You can, however, also explicitly change those by using
"set local *variable*" - that should eliminate the need for most reconnects.
On Sat, Oct 23, 2010 at 7:19 PM, Sander de Bruijne
>
> > exit mysql client and enter again.
>
> Instead of exit client and enter again, just type \r (reconnect)
> and you have a new session.
>
>
>
> On 10/23/2010 06:44 PM, Claudio Nanni wrote:
>
>> Just a little note:
>>
>> sometimes, if you are in command line session, you will not see the change
>> of the dynamic variable unless you logout and in again,
>> so in case you change the value of a dynamic variable but still the "show
>> variables" shows you the old value, dont panic!
>> exit mysql client and enter again.
>>
>> Aloha!
>>
>> Claudio
>>
>>
>>
>> 2010/10/23 Prabhat Kumar
>>
>> Here you get all details:
>>>
>>> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html
>>>
>>> All the Dynamic variable can be change on fly eg.
>>> wait_timeout<
>>>
>>> http://dev.mysql.com/doc/refman/5.0/en/server-system-variabl es.html#sysvar_wait_timeout
>>> .
>>>
>>>
>>> On Sat, Oct 23, 2010 at 6:07 PM, wroxdb
>>>
>>> Hello,
>>>>
>>>> what system variables of mysqld can be changed on fly?
>>>>
>>>> thanks.
>>>>
>>>> --
>>>> MySQL General Mailing List
>>>> For list archives: http://lists.mysql.com/mysql
>>>> To unsubscribe:
>>>> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>>>>
>>>>
>>>>
>>> --
>>> Best Regards,
>>>
>>> Prabhat Kumar
>>> MySQL DBA
>>>
>>> My Blog: http://adminlinux.blogspot.com
>>> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>>>
>>>
>>
>>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamp@tuxera.be
>
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--002215047c9bb9828804935aedf0--
On 10/23/2010 12:44 PM, Claudio Nanni wrote:
> Just a little note:
>
> sometimes, if you are in command line session, you will not see the change
> of the dynamic variable unless you logout and in again,
> so in case you change the value of a dynamic variable but still the "show
> variables" shows you the old value, dont panic!
> exit mysql client and enter again.
>
It also makes a difference which version of SHOW VARIABLES you are
using: SHOW GLOBAL VARIABLES or SHOW SESSION VARIABLES
Changes to global settings only apply to NEW sessions. Existing sessions
can modify their personal settings without affecting the global defaults.
Please read this if you are still confused:
http://dev.mysql.com/doc/refman/5.1/en/using-system-variable s.html
http://dev.mysql.com/doc/refman/5.1/en/show-variables.html
http://dev.mysql.com/doc/refman/5.1/en/set-option.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org