~percona-dev/percona-server/release-5.1.47-12-slow_create-table_test-fix

« back to all changes in this revision

Viewing changes to mysql-test/percona_slow_query_log-microseconds_in_slow_query_log.test

  • Committer: Oleg Tsarev
  • Date: 2010-06-02 02:44:06 UTC
  • mfrom: (20.3.4 ps_test3)
  • Revision ID: oleg.tsarev@percona.com-20100602024406-hi3suwuvu918hsgb
support feature microseconds in slow query log

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
source include/have_innodb.inc;
 
2
 
 
3
SELECT sleep(2);
 
4
 
 
5
set global microseconds_in_slow_query_log=1;
 
6
 
 
7
SELECT sleep(2);
 
8
 
 
9
set global microseconds_in_slow_query_log=0;
 
10
 
 
11
let $cmd = cat var/mysqld.1/data/percona_slow_query_log-microseconds_in_slow_query_log.log | grep -E '# Time: [0-9]+ [0-9]+:[0-\9]+:[0-9]+.[0-9]+' | wc -l;
 
12
echo $cmd;
 
13
exec $cmd;
 
14
 
 
15
let $cmd = cat var/mysqld.1/data/percona_slow_query_log-microseconds_in_slow_query_log.log | grep -E '# Time: [0-9]+ [0-9]+:[0-\9]+:[0-9]+' | wc -l;
 
16
echo $cmd;
 
17
exec $cmd;