diff options
author | Michael Widenius <monty@askmonty.org> | 2009-10-28 09:52:34 +0200 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2009-10-28 09:52:34 +0200 |
commit | 358327618d5a71138be6ca27a4c8472723b67c45 (patch) | |
tree | c3e3a8863d7b69f2710398758721ffd6e75a02ca /mysql-test/t/count_distinct2.test | |
parent | f3e3fe866bfaa14986db5bb6a10e5c130af69137 (diff) | |
download | mariadb-git-358327618d5a71138be6ca27a4c8472723b67c45.tar.gz |
Speed up of test suite:
- Added --disable_query_log ; begin ; .... commit; --enable_query_log around all while loops that does insert
Diffstat (limited to 'mysql-test/t/count_distinct2.test')
-rw-r--r-- | mysql-test/t/count_distinct2.test | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/mysql-test/t/count_distinct2.test b/mysql-test/t/count_distinct2.test index 8dcb2a70065..95086ad04aa 100644 --- a/mysql-test/t/count_distinct2.test +++ b/mysql-test/t/count_distinct2.test @@ -51,13 +51,15 @@ drop table t1; # test the conversion from tree to MyISAM create table t1 (n int default NULL); let $1=5000; -disable_query_log; +--disable_query_log +begin; while ($1) { eval insert into t1 values($1); dec $1; } -enable_query_log; +commit; +--enable_query_log flush status; select count(distinct n) from t1; @@ -67,13 +69,15 @@ drop table t1; # Test use of MyISAM tmp tables create table t1 (s text); let $1=5000; -disable_query_log; +--disable_query_log +begin; while ($1) { eval insert into t1 values('$1'); dec $1; } -enable_query_log; +commit; +--enable_query_log flush status; select count(distinct s) from t1; show status like 'Created_tmp_disk_tables'; |