List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:June 27 2013 7:22pm
Subject:Re: NOW() is stuck...
View as plain text  
Hi,

On 06/27/2013 08:19 PM, Andy Wallace wrote:
> Benjamin -
> Unfortunately:
>
> mysql> show global variables like 'timestamp';
> +---------------+------------+
> | Variable_name | Value      |
> +---------------+------------+
> | timestamp     | 1372238834 |
> +---------------+------------+
> 1 row in set (0.00 sec)
>
> And:
>
> mysql> set global timestamp = 0;
> ERROR 1228 (HY000): Variable 'timestamp' is a SESSION variable and 
> can't be used with SET GLOBAL
>
Then, as Benjamin said, you have found the bug.

'GLOBAL timestamp' should not exist

http://bugs.mysql.com/bug.php?id=49686

Your GLOBAL (ghost) instance of this variable sets the SESSION one at 
every client connection.

But you are sort of trapped because there is no syntax to manipulate 
that GLOBAL instance.


Also, sadly the manual page does not explain what happens if you set it 
to DEFAULT: 
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html


Cheers

-- 
Claudio


Thread
NOW() is stuck...Andy Wallace26 Jun
  • RE: NOW() is stuck...Rick James26 Jun
  • Re: NOW() is stuck...John Meyer26 Jun
    • Re: NOW() is stuck...Eric Bergen27 Jun
      • Re: NOW() is stuck...Andy Wallace27 Jun
        • Re: NOW() is stuck...Nick Khamis27 Jun
          • Re: NOW() is stuck...Andy Wallace27 Jun
  • Re: NOW() is stuck...Benjamin Stillman27 Jun
    • Re: NOW() is stuck...Andy Wallace27 Jun
      • Re: NOW() is stuck...Benjamin Stillman27 Jun
        • Re: NOW() is stuck...Andy Wallace27 Jun
          • Re: NOW() is stuck...Eric Bergen27 Jun
            • Re: NOW() is stuck...Andy Wallace27 Jun
          • Re: NOW() is stuck...Claudio Nanni27 Jun
            • Re: NOW() is stuck...Andy Wallace27 Jun
          • Re: NOW() is stuck...walter harms28 Jun
            • Re: NOW() is stuck...Andy Wallace28 Jun
              • Re: NOW() is stuck...Claudio Nanni28 Jun
Re: NOW() is stuck...Johan De Meersman27 Jun