summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <andrey@lmy004.>2006-05-23 10:49:09 +0200
committerunknown <andrey@lmy004.>2006-05-23 10:49:09 +0200
commitda73495f09c1987e06426c80b2ea473ec7eda8e5 (patch)
tree91a543af8aa361986dc24fbf26045d7d970310bb /mysql-test
parent91de2afb8cb8c36c5a1e2181f52f12108dea2197 (diff)
downloadmariadb-git-da73495f09c1987e06426c80b2ea473ec7eda8e5.tar.gz
make it less stressful. some pushbuild boxes cannot cope with it
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/events_stress.result8
-rw-r--r--mysql-test/t/events_stress.test12
2 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/r/events_stress.result b/mysql-test/r/events_stress.result
index a903a4502bf..ead618e8136 100644
--- a/mysql-test/r/events_stress.result
+++ b/mysql-test/r/events_stress.result
@@ -16,7 +16,7 @@ CREATE EVENT ev_drop3 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
USE events_test;
SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS;
COUNT(*)
-203
+103
SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
COUNT(*)
3
@@ -29,7 +29,7 @@ CREATE DATABASE events_conn1_test2;
USE events_conn1_test2;
SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
COUNT(*)
-100
+50
SET GLOBAL event_scheduler=1;
DROP DATABASE events_conn1_test2;
SET GLOBAL event_scheduler=2;
@@ -41,14 +41,14 @@ USE events_conn1_test3;
SET GLOBAL event_scheduler=1;
SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test3';
COUNT(*)
-100
+50
CREATE DATABASE events_conn1_test4;
USE events_conn1_test4;
CREATE DATABASE events_conn1_test2;
USE events_conn1_test2;
SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
COUNT(*)
-100
+50
DROP DATABASE events_conn2_db;
DROP DATABASE events_conn3_db;
DROP DATABASE events_conn1_test2;
diff --git a/mysql-test/t/events_stress.test b/mysql-test/t/events_stress.test
index 24bb5bc89b1..ab6da98ba28 100644
--- a/mysql-test/t/events_stress.test
+++ b/mysql-test/t/events_stress.test
@@ -13,7 +13,7 @@ GRANT ALL ON *.* TO event_user3@localhost;
connect (conn2,localhost,event_user2,,events_conn2_db);
--echo "In the second connection we create some events which won't be dropped till the end"
--disable_query_log
-let $1= 100;
+let $1= 50;
while ($1)
{
eval CREATE EVENT conn2_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it VALUES("conn2_ev$1", NOW());
@@ -23,7 +23,7 @@ while ($1)
connect (conn3,localhost,event_user3,,events_conn3_db);
--echo "In the second connection we create some events which won't be dropped till the end"
--disable_query_log
-let $1= 100;
+let $1= 50;
while ($1)
{
eval CREATE EVENT conn3_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it VALUES("conn3_ev$1", NOW());
@@ -45,7 +45,7 @@ SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_
CREATE DATABASE events_conn1_test2;
USE events_conn1_test2;
--disable_query_log
-let $1= 100;
+let $1= 50;
while ($1)
{
eval CREATE EVENT conn1_round1_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it VALUES("conn1_round1_ev$1", NOW());
@@ -62,7 +62,7 @@ SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_
CREATE DATABASE events_conn1_test3;
USE events_conn1_test3;
--disable_query_log
-let $1= 100;
+let $1= 50;
while ($1)
{
eval CREATE EVENT conn1_round2_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it VALUES("conn1_round2_ev$1", NOW());
@@ -74,7 +74,7 @@ SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_
CREATE DATABASE events_conn1_test4;
USE events_conn1_test4;
--disable_query_log
-let $1= 100;
+let $1= 50;
while ($1)
{
eval CREATE EVENT conn1_round3_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it VALUES("conn1_round3_ev$1", NOW());
@@ -85,7 +85,7 @@ while ($1)
CREATE DATABASE events_conn1_test2;
USE events_conn1_test2;
--disable_query_log
-let $1= 100;
+let $1= 50;
while ($1)
{
eval CREATE EVENT ev_round4_drop$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it VALUES("conn1_round4_ev$1", NOW());