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:
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN