List:General Discussion« Previous MessageNext Message »
From:Shawn Green (MySQL) Date:October 24 2010 6:41pm
Subject:Re: mysql's system variables
View as plain text  
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-variables.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
Thread
mysql's system variableswroxdb23 Oct
  • Re: mysql's system variablesPrabhat Kumar23 Oct
    • Re: mysql's system variablesClaudio Nanni23 Oct
      • Re: mysql's system variablesSander de Bruijne23 Oct
        • Re: mysql's system variablesJohan De Meersman24 Oct
      • Re: mysql's system variablesMySQL)24 Oct