wrong value for log_slow_verbosity
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Oleg Tsarev |
Bug Description
In 11.7
mysql> select @@log_slow_
+------
| @@log_slow_
+------
| microtime |
+------
1 row in set (0.00 sec)
This is when starting server with
log_slow_
The log file in this case is reporting some strange mix:
# Time: 101216 19:08:01
# User@Host: root[root] @ localhost []
# Thread_id: 4 Schema: Last_errno: 0 Killed: 0
# Query_time: 50.000274 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 Rows_read: 1
# Bytes_sent: 64 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
SET timestamp=
select sleep(50);
It is not just standard mysql slow log format but it is not the full format (error code, innodb stats etc) either.
Related branches
- Alexey Kopytov (community): Disapprove
-
Diff: 547 lines (+126/-28)32 files modifiedcontrol_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)
- Alexey Kopytov (community): Approve
-
Diff: 287 lines (+50/-50)2 files modifiedresponse-time-distribution.patch (+1/-1)
slow_extended.patch (+49/-49)
- Alexey Kopytov (community): Approve
-
Diff: 223 lines (+79/-4)23 files modifiedmysql-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)
Changed in percona-server: | |
assignee: | nobody → Oleg Tsarev (tsarev) |
importance: | Undecided → High |
Changed in percona-server: | |
status: | New → Confirmed |
Changed in percona-server: | |
status: | Confirmed → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → Fix Released |
Oleg,
Based on our conversation today as I understand it is actually 2 different
bugs (please feel free to fork it)
1) when use_global_ long_query_ time is entered on its own line in my.cnf it file_per_ table). But what is worse it did not complain about the
is recognized as the second line for it is a parameter for it. It did not
allow such syntax (which I think is should as many boolean variables like
innodb_
incorrect option.
2) There is a problem with "microtime" reporting non standard things in slow
query log. The goal is for log time by default to be absolutely same as in
mysql 5.1 which would allow to use tools only supporting such log files with
Percona.
On Thu, Dec 16, 2010 at 11:45 AM, Oleg Tsarev <email address hidden>wrote:
> ** Changed in: percona-server /bugs.launchpad .net/bugs/ 691234 verbosity; ------- ------- --+ verbosity | ------- ------- --+ ------- ------- --+ verbosity= "full" 1292526481; /bugs.launchpad .net/percona- server/ +bug/691234/ +subscribe
> Status: New => Confirmed
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https:/
>
> Title:
> wrong value for log_slow_verbosity
>
> Status in Percona Server with XtraDB:
> Confirmed
>
> Bug description:
> In 11.7
>
> mysql> select @@log_slow_
> +------
> | @@log_slow_
> +------
> | microtime |
> +------
> 1 row in set (0.00 sec)
>
>
>
> This is when starting server with
> log_slow_
>
> The log file in this case is reporting some strange mix:
>
> # Time: 101216 19:08:01
> # User@Host: root[root] @ localhost []
> # Thread_id: 4 Schema: Last_errno: 0 Killed: 0
> # Query_time: 50.000274 Lock_time: 0.000000 Rows_sent: 1 Rows_examined:
> 0 Rows_affected: 0 Rows_read: 1
> # Bytes_sent: 64 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
> SET timestamp=
> select sleep(50);
>
>
> It is not just standard mysql slow log format but it is not the full format
> (error code, innodb stats etc) either.
>
> To unsubscribe from this bug, go to:
> https:/
>
--
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 www.percona. com/training/
http://