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


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

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

SELECT sleep(2);

set global slow_query_log_microseconds_timestamp=ON;

SELECT sleep(2);

set global slow_query_log_microseconds_timestamp=OFF;

let $MYSQLD_DATADIR= `select @@datadir`;
let $cmd = cat $MYSQLD_DATADIR/percona_slow_query_log-microseconds_in_slow_query_log.log | grep -E -c '# Time: [0-9]+[ ]+[0-9]+:[0-\9]+:[0-9]+.[0-9]+';
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
exec echo "$cmd";
exec $cmd;

let $cmd = cat $MYSQLD_DATADIR/percona_slow_query_log-microseconds_in_slow_query_log.log | grep -E -c '# Time: [0-9]+[ ]+[0-9]+:[0-\9]+:[0-9]+';
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
exec echo "$cmd";
exec $cmd;