PS now has option to log statements in stored routine but uses bad log format
Bug #1419230 reported by
Swany
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.6 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
# User@Host: flexviews[
# Schema: flexviews Last_errno: 1051 Killed: 0
# Query_time: 0.000045 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 4 Rows_affected: 0
# Bytes_sent: 0
# Stored routine: flexviews.
Above is slow query log output from new feature. Notice the "Stored routine" key is missing an underscore and instead uses space.
Related branches
lp:~laurynas-biveinis/percona-server/bug1419230-5.5
- Laurynas Biveinis (community): Approve
-
Diff: 61 lines (+7/-7)3 files modifiedmysql-test/r/percona_log_slow_sp_statements.result (+3/-3)
mysql-test/t/percona_log_slow_sp_statements.test (+3/-3)
sql/log.cc (+1/-1)
lp:~laurynas-biveinis/percona-server/bug1419230-5.6
- Laurynas Biveinis (community): Approve
-
Diff: 61 lines (+7/-7)3 files modifiedmysql-test/r/percona_log_slow_sp_statements.result (+3/-3)
mysql-test/t/percona_log_slow_sp_statements.test (+3/-3)
sql/log.cc (+1/-1)
tags: | added: low-hanging-fruit slow-extended |
To post a comment you must log in.
Verified with PS 5.6.22. Need to decide, is it okay with space or there should be _ .
root@desktop: /var/lib/ mysql# cat desktop- slow-log. 000013 1423466512; /var/lib/ mysql#
/usr/sbin/mysqld, Version: 5.6.22-71.0-log (Percona Server (GPL), Release 71.0, Revision 726). started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
# Time: 150209 12:51:52
# User@Host: root[root] @ localhost [] Id: 37
# Schema: nil Last_errno: 0 Killed: 0
# Query_time: 13.517232 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 8388608 Rows_affected: 4194304
# Bytes_sent: 0
# Stored routine: nil.nil_test
use nil;
SET timestamp=
INSERT INTo test SELECT * from test;
root@desktop: