summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts/inc/partition_varchar.inc
diff options
context:
space:
mode:
authorMichael Widenius <monty@askmonty.org>2009-10-28 09:52:34 +0200
committerMichael Widenius <monty@askmonty.org>2009-10-28 09:52:34 +0200
commit358327618d5a71138be6ca27a4c8472723b67c45 (patch)
treec3e3a8863d7b69f2710398758721ffd6e75a02ca /mysql-test/suite/parts/inc/partition_varchar.inc
parentf3e3fe866bfaa14986db5bb6a10e5c130af69137 (diff)
downloadmariadb-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/suite/parts/inc/partition_varchar.inc')
-rw-r--r--mysql-test/suite/parts/inc/partition_varchar.inc15
1 files changed, 12 insertions, 3 deletions
diff --git a/mysql-test/suite/parts/inc/partition_varchar.inc b/mysql-test/suite/parts/inc/partition_varchar.inc
index f1412d3aae5..33c61034a52 100644
--- a/mysql-test/suite/parts/inc/partition_varchar.inc
+++ b/mysql-test/suite/parts/inc/partition_varchar.inc
@@ -21,13 +21,16 @@ show create table t2;
let $count=26;
let $letter=0;
--echo $count inserts;
-#--disable_query_log
+--disable_query_log
+begin;
while ($count)
{
eval insert into t2 values (repeat(char(ascii('a')+$letter),$count*$count));
dec $count;
inc $letter;
}
+commit;
+--enable_query_log
select count(*) from t2;
select * from t2;
drop table t2;
@@ -46,13 +49,16 @@ show create table t3;
let $count=26;
let $letter=0;
--echo $count inserts;
-#--disable_query_log
+--disable_query_log
+begin;
while ($count)
{
eval insert into t3 values (repeat(char(ascii('a')+$letter),$count+54));
dec $count;
inc $letter;
}
+commit;
+--enable_query_log
select count(*) from t3;
select * from t3;
drop table t3;
@@ -70,13 +76,16 @@ show create table t4;
let $count=26;
let $letter=0;
--echo $count inserts;
-#--disable_query_log
+--disable_query_log
+begin;
while ($count)
{
eval insert into t4 values (repeat(char(ascii('a')+$letter),$count+54));
dec $count;
inc $letter;
}
+commit;
+--enable_query_log
select count(*) from t4;
select * from t4;
drop table t4;