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

Merge lp:~percona-dev/percona-server/release-5.1.46-11-test-global_long_query_time into lp:percona-server/release-5.1.47-11

  1. release-5.1.46-11-test-global_long_query_time
  2. Merge into release-5.1.47-11
Proposed by Oleg Tsarev
Status: Merged
Approved by: Vadim Tkachenko
Approved revision: no longer in the source branch.
Merged at revision: 12
Proposed branch: lp:~percona-dev/percona-server/release-5.1.46-11-test-global_long_query_time
Merge into: lp:percona-server/release-5.1.47-11
Diff against target: 59 lines (+44/-0)
3 files modified
mysql-test/percona_slow_query_log-long_query_time-master.opt (+1/-0)
mysql-test/percona_slow_query_log-long_query_time.result (+24/-0)
mysql-test/percona_slow_query_log-long_query_time.test (+19/-0)
To merge this branch: bzr merge lp:~percona-dev/percona-server/release-5.1.46-11-test-global_long_query_time
Reviewer Review Type Date Requested Status
Vadim Tkachenko Approve
Review via email: mp+26218@code.launchpad.net

Description of the change

Add test for use_global_long_query_time

To post a comment you must log in.
Revision history for this message
Vadim Tkachenko (vadim-tk) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'mysql-test/percona_slow_query_log-long_query_time-master.opt'
2--- mysql-test/percona_slow_query_log-long_query_time-master.opt 1970-01-01 00:00:00 +0000
3+++ mysql-test/percona_slow_query_log-long_query_time-master.opt 2010-05-27 17:47:58 +0000
4@@ -0,0 +1,1 @@
5+--slow-query-log-file=percona_slow_query_log.log --long-query-time=2
6\ No newline at end of file
7
8=== added file 'mysql-test/percona_slow_query_log-long_query_time.result'
9--- mysql-test/percona_slow_query_log-long_query_time.result 1970-01-01 00:00:00 +0000
10+++ mysql-test/percona_slow_query_log-long_query_time.result 2010-05-27 17:47:58 +0000
11@@ -0,0 +1,24 @@
12+SELECT sleep(1);
13+sleep(1)
14+0
15+SELECT sleep(3);
16+sleep(3)
17+0
18+SELECT sleep(5);
19+sleep(5)
20+0
21+set global long_query_time=4;
22+set global use_global_long_query_time=1;
23+SELECT sleep(1);
24+sleep(1)
25+0
26+SELECT sleep(3);
27+sleep(3)
28+0
29+SELECT sleep(5);
30+sleep(5)
31+0
32+set global long_query_time=2;
33+set global use_global_long_query_time=0;
34+cat var/mysqld.1/data/percona_slow_query_log.log | grep Query_time | wc -l
35+3
36
37=== added file 'mysql-test/percona_slow_query_log-long_query_time.test'
38--- mysql-test/percona_slow_query_log-long_query_time.test 1970-01-01 00:00:00 +0000
39+++ mysql-test/percona_slow_query_log-long_query_time.test 2010-05-27 17:47:58 +0000
40@@ -0,0 +1,19 @@
41+source include/have_innodb.inc;
42+
43+SELECT sleep(1);
44+SELECT sleep(3);
45+SELECT sleep(5);
46+
47+set global long_query_time=4;
48+set global use_global_long_query_time=1;
49+
50+SELECT sleep(1);
51+SELECT sleep(3);
52+SELECT sleep(5);
53+
54+set global long_query_time=2;
55+set global use_global_long_query_time=0;
56+
57+let $cmd = cat var/mysqld.1/data/percona_slow_query_log.log | grep Query_time | wc -l;
58+echo $cmd;
59+exec $cmd;

Subscribers

People subscribed via source and target branches

to all changes: