lp:~laurynas-biveinis/percona-server/slow-log-fixes-5.1
- Get this branch:
- bzr branch lp:~laurynas-biveinis/percona-server/slow-log-fixes-5.1
Branch merges
- Stewart Smith (community): Approve
-
Diff: 20056 lines (+9597/-9871)52 files modifiedPercona-Server/mysql-test/include/log_cleanup.inc (+1/-0)
Percona-Server/mysql-test/include/log_start.inc (+3/-8)
Percona-Server/mysql-test/include/log_stop.inc (+2/-2)
Percona-Server/mysql-test/include/percona_slow_extended_error_on_quit.inc (+0/-50)
Percona-Server/mysql-test/include/percona_slow_log_verbosity_grep.inc (+26/-0)
Percona-Server/mysql-test/r/percona_bug643149.result (+2/-2)
Percona-Server/mysql-test/r/percona_log_slow_admin_statements.result (+15/-6)
Percona-Server/mysql-test/r/percona_log_slow_filter.result (+0/-15)
Percona-Server/mysql-test/r/percona_log_slow_innodb.result (+42/-0)
Percona-Server/mysql-test/r/percona_log_slow_query_plan.result (+202/-0)
Percona-Server/mysql-test/r/percona_log_slow_query_plan_qc.result (+35/-0)
Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result (+6/-1)
Percona-Server/mysql-test/r/percona_log_slow_slave_statements.result (+16/-36)
Percona-Server/mysql-test/r/percona_log_slow_sp_statements.result (+20/-19)
Percona-Server/mysql-test/r/percona_log_slow_timestamp_every.result (+13/-39)
Percona-Server/mysql-test/r/percona_log_slow_verbosity.result (+111/-16)
Percona-Server/mysql-test/r/percona_long_query_time.result (+2/-0)
Percona-Server/mysql-test/r/percona_mysqldumpslow.result (+8100/-9094)
Percona-Server/mysql-test/r/percona_slow_extended_error_on_quit.result (+20/-168)
Percona-Server/mysql-test/r/percona_slow_extended_log_error.result (+14/-0)
Percona-Server/mysql-test/r/percona_slow_query_log_microseconds_timestamp.result (+17/-17)
Percona-Server/mysql-test/r/percona_use_global_log_slow_control.result (+2/-0)
Percona-Server/mysql-test/r/percona_use_global_long_query_time.result (+2/-0)
Percona-Server/mysql-test/t/disabled.def (+1/-0)
Percona-Server/mysql-test/t/percona_log_slow_admin_statements.test (+41/-2)
Percona-Server/mysql-test/t/percona_log_slow_filter.test (+0/-26)
Percona-Server/mysql-test/t/percona_log_slow_innodb.test (+82/-0)
Percona-Server/mysql-test/t/percona_log_slow_query_plan.test (+302/-0)
Percona-Server/mysql-test/t/percona_log_slow_query_plan_qc.test (+71/-0)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-innodb-slave.opt (+0/-1)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-innodb.test (+16/-16)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-slave.opt (+0/-1)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements.test (+50/-101)
Percona-Server/mysql-test/t/percona_log_slow_sp_statements.test (+34/-20)
Percona-Server/mysql-test/t/percona_log_slow_timestamp_every.test (+17/-29)
Percona-Server/mysql-test/t/percona_log_slow_verbosity.test (+75/-19)
Percona-Server/mysql-test/t/percona_long_query_time.test (+4/-0)
Percona-Server/mysql-test/t/percona_min_examined_row_limit.test (+1/-0)
Percona-Server/mysql-test/t/percona_mysqldumpslow.test (+59/-24)
Percona-Server/mysql-test/t/percona_slow_extended_error_on_quit.test (+58/-74)
Percona-Server/mysql-test/t/percona_slow_extended_log_error.test (+31/-0)
Percona-Server/mysql-test/t/percona_slow_query_log_microseconds_timestamp.test (+36/-24)
Percona-Server/mysql-test/t/percona_use_global_log_slow_control.test (+4/-1)
Percona-Server/mysql-test/t/percona_use_global_long_query_time.test (+5/-0)
Percona-Server/scripts/mysqldumpslow.sh (+3/-3)
Percona-Server/sql/event_scheduler.cc (+0/-1)
Percona-Server/sql/log.cc (+48/-22)
Percona-Server/sql/log_event.cc (+5/-9)
Percona-Server/sql/slave.cc (+1/-2)
Percona-Server/sql/sql_class.h (+0/-13)
Percona-Server/sql/sql_connect.cc (+0/-9)
Percona-Server/sql/sql_parse.cc (+2/-1)
Related bugs
Related blueprints
Branch information
- Owner:
- Laurynas Biveinis
- Status:
- Merged
Recent revisions
- 511. By Laurynas Biveinis
-
Multiple extended slow query log fixes.
Fix bug 887928 (Time in slow query log displayed incorrectly when
slow_query_log_microsecond s_timestamp enabled) by using a correct
format specifier for microsecond output and tightening regexps in
percona_slow_query_ log_microsecond s_timestamp test. Also adjust the
testcase not to use query_exec_time and thus not limit it to debug
builds only.Fix bug 730173 (InnoDB and query plan information are logged when not
enabled) and bug 1089961 (Slow query log query plan extensions not
tested in MTR) by checking the verbosity flag in more places in
MYSQL_QUERY_LOG::write. Add new testcases percona_ log_slow_ query_plan
and percona_log_slow_ query_plan_ qc and remove percona_ log_slow_ filter
as it's fully subsumed in the new testcases. Adjust mysqldumpslow
script to filter out the optional information correctly. Re-record
percona_bug643149, percona_slow_extended_ error_on_ quit, and
percona_mysqldumpslow tests. Fix bug 1091712 (Get rid of thd->write_
to_slow_ log) by removing it and
moving the rate filtering logic from handle_one_connection( ) to
log_slow_statement( ). At the same time set thd->enable_ slow_log to
TRUE instead of opt_log_slow_slave_ statements in
Query_log_event:: do_apply_ event() and init_slave_thread() as the check
at print_slow_log() is sufficient for slave statement filtering.Fix bug 1088954 (Data type conversion bugs in slow query log output
formatting code) by using %d not %u for last_errno output and
pre-formatting ulonglong values with sprintf.Fix testcase-only bugs:
Fix bug 909376 (percona_
slow_extended_ error_on_ quit test unstable) by
rewriting the testcase.Fix bug 1088867 (The effect of log_slow_verbosity is untested in MTR)
by replacing percona_log_slow_ verbosity with a new extensive test,
together with include/percona_ slow_log_ verbosity_ grep.inc helper. Fix bug 1092142 (log_slow_
admin_statement s untested in MTR) by
replacing the current percona_log_slow_ admin_statement s non-test with
a new actual testcase.Fix bug 1089031 (Slow query log XtraDB extensions not tested in MTR)
by adding a new testcase percona_log_slow_ innodb. Also, simplify
percona_log_slow_ slave_statement s-innodb testcase by removing slave
option file, needless master/slave switches, and needless query/result
log disablings, and replace server restart with a slave SQL thread
restart.Fix bug 1096895 (percona_
log_slow_ slave_statement s test needlessly
complicated) by rewriting the testcase to remove needless SQL thread
restarts, very verbose variable settings, slave option file, and other
non-test things.Fix bug 1096899 (percona_
log_slow_ sp_statements testcase multiple
issues) by rewriting the testcase to not use query_exec_time session
variable, not limiting it to debug builds only, and adding a test for
the negative case.Fix bug 1090874 (log_slow_
timestamp_ every /
slow_query_log_timestamp_ always testing issues) by rewriting
percona_log_slow_ timestamp_ every testcase not to depend on the
subsequent queries getting identical timestamps and not use
query_exec_time session variable, thus not limiting it to debug builds
only.Fix bug 1096904 (Extended slow query log last_errno value not tested
in MTR) by adding a new testcase percona_slow_extended_ log_error. Attempt to fix bug 1098436 (Unstable test percona_
mysqldumpslow) by
slow-logging only relevant statements (i.e. the ones with injected
query execution time) to remove statements with varying execution time
from the output. Set min_examined_row_limit to zero for the
testcase. Additionally adjust include/log_start. inc not to delete the
slow query log file to support logging restarts to the same file.
Remove useless Perl code. Remove useless "FLUSH LOGS" from
include/log_stop. inc. Append .slog to all log files in
include/log_start. inc and provide new include file
include/log_cleanup. inc that removes *.slog from the log directory.
Set log_output to FILE in log_start.inc and restore its old value in
log_stop.inc.Address bug 1098857 by disabling percona_
slow_extended_ error_on_ quit
and moving out session disconnects out of slow query log in
percona_mysqldumpslow. Adjust percona_
long_query_ time, percona_ use_global_ log_slow_ control
and percona_use_global_ long_query_ time test cases to set
min_examined_row_limit to 0. - 505. By <email address hidden>
-
Merge lp:~laurynas-biveinis/percona-server/xtradb-multiple-bmp-files-51
Branch metadata
- Branch format:
- Branch format 7
- Repository format:
- Bazaar repository format 2a (needs bzr 1.16 or later)
- Stacked on:
- lp:percona-server/5.5