summaryrefslogtreecommitdiff
path: root/mysql-test/suite/percona/slow_extended.patch/percona_slow_extended-microseconds_in_slow_extended.test
blob: 4b437b21e4ca16325a2335bdaa482d329b465e5c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
source include/have_xtradb.inc;

SET GLOBAL SLOW_QUERY_LOG=ON;

SELECT sleep(2);

set global slow_query_log_timestamp_precision='microsecond';

SELECT sleep(2);

set global slow_query_log_timestamp_precision='second';

SET GLOBAL SLOW_QUERY_LOG=OFF;

FLUSH LOGS;
--let grep_file = $MYSQLTEST_VARDIR/mysqld.1/data/percona_slow_query_log-microseconds_in_slow_query_log.log
--let grep_pattern = # Time: [0-9]+[ ]+[0-9]+:[0-9]+:[0-9]+.[0-9]+
--source grep.inc

--let grep_file = $MYSQLTEST_VARDIR/mysqld.1/data/percona_slow_query_log-microseconds_in_slow_query_log.log 
--let grep_pattern =  # Time: [0-9]+[ ]+[0-9]+:[0-9]+:[0-9]+
--source grep.inc