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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
