1# restart
2SET GLOBAL debug="+d,seed_slow_log_random";
3SET GLOBAL long_query_time=0;
4SET GLOBAL log_slow_rate_type='session';
5SET GLOBAL log_slow_rate_limit=3;
6[log_start.inc] percona.slow_extended.log_slow_rate_limit_1
7SELECT 'connection_one';
8connection_one
9connection_one
10SELECT 'connection_two';
11connection_two
12connection_two
13SELECT 'connection_three';
14connection_three
15connection_three
16SELECT 'connection_one';
17connection_one
18connection_one
19SELECT 'connection_two';
20connection_two
21connection_two
22SELECT 'connection_three';
23connection_three
24connection_three
25[log_stop.inc] percona.slow_extended.log_slow_rate_limit_1
26[log_grep.inc] file: percona.slow_extended.log_slow_rate_limit_1 pattern:
27[log_grep.inc] sum:  2
28[log_grep.inc] zero: 2
29# restart
30SET GLOBAL debug="+d,seed_slow_log_random";
31SET GLOBAL log_slow_rate_type='query';
32SET GLOBAL log_slow_rate_limit=2;
33[log_start.inc] percona.slow_extended.log_slow_rate_limit_2
34SELECT 'connection_one';
35connection_one
36connection_one
37SELECT 'connection_two';
38connection_two
39connection_two
40SELECT 'connection_three';
41connection_three
42connection_three
43SELECT 'connection_one';
44connection_one
45connection_one
46SELECT 'connection_two';
47connection_two
48connection_two
49SELECT 'connection_three';
50connection_three
51connection_three
52[log_stop.inc] percona.slow_extended.log_slow_rate_limit_2
53[log_grep.inc] file: percona.slow_extended.log_slow_rate_limit_2 pattern:
54[log_grep.inc] sum:  0
55[log_grep.inc] zero: 3
56