Re: how long will mysql long_query_time applied ?

在 2015年2月13日星期五 UTC+8上午6:47:14，Denis McMahon写道：
> On Thu, 12 Feb 2015 08:16:11 -0800, lizhiyuan66 wrote:
>
> > But, when i set long_query_time back to 1 from 0.001, i found the slow
> > query printed didn't change
>
> Did you restart mysql after making the second change?
>
> --
> Denis McMahon, denismfmcmahon_at_gmail.com

I may get your point .

I missed one thing, is that my mysql keeped a lot of long connections . The setting was useless for those connections which were already exist .

Even though its Variable Scope include a "GLOBAL", but it still got one "SESSION" . so i guess "SESSION" keeped a copy when it created and keep it in its own zone.

Only new connection can take effect .

Sorry for my poor eng . My eng suck ~ Received on Fri Feb 13 2015 - 04:58:37 CET