Percona Server moved to https://jira.percona.com/projects/PS

Make variables aligned

Bug #688643 reported by Peter Zaitsev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Oleg Tsarev
Percona Server moved to https://jira.percona.com/projects/PS 5.5-20beta

Bug Description

Right now if I have --use_global_long_query_time=1 I see:

| use_global_log_slow_control | none |
| use_global_long_query_time | ON

Whis is confusing in understanding how these variables work together and makes hard to check the status from scripts.
I would suggest enabling use_global_long_query_time would simply add the "time" to use_global_log_slow_control and setting it to 0 would remove that in this case we do not get into situation (and explainiung) what happens if you have global time check enabled in one of them but not other.

Related branches

lp:~percona-dev/percona-server/release-5.1.53-12-slow_extended-fix
Alexey Kopytov (community): Disapprove
Diff: 547 lines (+126/-28)
32 files modified
control_online_alter_index.patch (+1/-1)
microsec_process.patch (+1/-1)
mysql-test/slow_extended.patch/percona_slow_extended-combined-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined.result (+18/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined.test (+6/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined2-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.result (+12/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.test (+4/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.test (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.test (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.result (+9/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.test (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.test (+2/-2)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.test (+2/-2)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.test (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.test (+1/-0)
optimizer_fix.patch (+1/-1)
profiling_slow.patch (+11/-2)
query_cache_enhance.patch (+6/-6)
response-time-distribution.patch (+2/-2)
slow_extended.patch (+23/-9)
suppress_log_warning_1592.patch (+1/-1)
userstat.patch (+1/-1)
lp:~percona-dev/percona-server/5.1.54-2010_12_21-three-fix_bug_688643
Alexey Kopytov (community): Approve
Diff: 406 lines (+67/-54)
9 files modified
control_online_alter_index.patch (+1/-1)
fix-bug671764.patch (+9/-2)
optimizer_fix.patch (+1/-1)
profiling_slow.patch (+4/-4)
query_cache_enhance.patch (+6/-6)
response-time-distribution.patch (+1/-1)
slow_extended.patch (+42/-36)
suppress_log_warning_1592.patch (+1/-1)
userstat.patch (+2/-2)
lp:~percona-dev/percona-server/5.1.54-2010_12_21-one-test_improve
Alexey Kopytov (community): Approve
Diff: 223 lines (+79/-4)
23 files modified
mysql-test/slow_extended.patch/percona_slow_extended-combined-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined.result (+18/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined.test (+6/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined2-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.result (+12/-0)
mysql-test/slow_extended.patch/percona_slow_extended-combined2.test (+4/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_sp_statements-cl.test (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_timestamp_every-cl.test (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.result (+9/-0)
mysql-test/slow_extended.patch/percona_slow_extended-log_slow_verbosity-cl.test (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements-and-use_global_long_query_time.test (+2/-2)
mysql-test/slow_extended.patch/percona_slow_extended-slave_statements.test (+2/-2)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-slow_query_log_microseconds_timestamp-cl.test (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl-master.opt (+1/-0)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.result (+3/-0)
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time-cl.test (+1/-0)
lp:percona-server/release-5.1.54-12
Revision history for this message
Oleg Tsarev (tsarev) wrote :

Peter,

What the version of Percona-Server?

Changed in percona-server:
assignee: nobody → Oleg Tsarev (tsarev)
status: New → In Progress
Vadim Tkachenko (vadim-tk)
Changed in percona-server:
status: In Progress → Confirmed
importance: Undecided → Low
importance: Low → Wishlist
Revision history for this message
Peter Zaitsev (pz-percona) wrote : Re: [Bug 688643] Re: Make variables aligned

Hi,

It is 11.6

On Fri, Dec 10, 2010 at 10:40 AM, Oleg Tsarev <email address hidden>wrote:

> Peter,
>
> What the version of Percona-Server?
>
> ** Changed in: percona-server
> Assignee: (unassigned) => Oleg Tsarev (tsarev)
>
> ** Changed in: percona-server
> Status: New => In Progress
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/688643
>
> Title:
> Make variables aligned
>
> Status in Percona Server with XtraDB:
> In Progress
>
> Bug description:
> Right now if I have --use_global_long_query_time=1 I see:
>
> | use_global_log_slow_control | none
> |
> | use_global_long_query_time | ON
>
> Whis is confusing in understanding how these variables work together and
> makes hard to check the status from scripts.
> I would suggest enabling use_global_long_query_time would simply add the
> "time" to use_global_log_slow_control and setting it to 0 would remove that
> in this case we do not get into situation (and explainiung) what happens
> if you have global time check enabled in one of them but not other.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/percona-server/+bug/688643/+subscribe
>

--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911

Percona Training Workshops
http://www.percona.com/training/

Vadim Tkachenko (vadim-tk)
Changed in percona-server:
milestone: none → 5.5-20beta
importance: Wishlist → Medium
Oleg Tsarev (tsarev)
Changed in percona-server:
status: Confirmed → In Progress
Oleg Tsarev (tsarev)
Changed in percona-server:
status: In Progress → Fix Committed
Vadim Tkachenko (vadim-tk)
Changed in percona-server:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1169

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.