mysql-test/suite/percona/percona_slow_query_log-long_query_time.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

source include/not_windows.inc;
source include/have_innodb.inc;

SELECT sleep(1);
SELECT sleep(6);
SELECT sleep(10);

set long_query_time=8;

SELECT sleep(1);
SELECT sleep(6);
SELECT sleep(12);

let $MYSQLD_DATADIR= `select @@datadir`;
let $cmd = cat $MYSQLD_DATADIR/percona_slow_query_log-long_query_time.log | grep -c Query_time;
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
exec echo '$cmd';
exec $cmd;