From da73495f09c1987e06426c80b2ea473ec7eda8e5 Mon Sep 17 00:00:00 2001
From: unknown <andrey@lmy004.>
Date: Tue, 23 May 2006 10:49:09 +0200
Subject: make it less stressful. some pushbuild boxes cannot cope with it

---
 mysql-test/r/events_stress.result |  8 ++++----
 mysql-test/t/events_stress.test   | 12 ++++++------
 2 files changed, 10 insertions(+), 10 deletions(-)

(limited to 'mysql-test')

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());
-- 
cgit v1.2.1