~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/include/no_running_event_scheduler.inc

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
ImportĀ upstreamĀ versionĀ 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
##########   include/no_running_event_scheduler.inc   ##########################
 
2
#                                                                              #
 
3
# Wait till the event scheduler disappeared from processlist.                  #
 
4
#                                                                              #
 
5
# The characteristics of the event_scheduler entry within the processlist is   #
 
6
# user = 'event_scheduler' and command = 'Daemon'. I am not 100% sure if       #
 
7
# ther is no short phase with command <> 'Daemon'.                             #
 
8
# A query with WHERE user = 'event_scheduler' only will also catch events in   #
 
9
# startup phase. This is no problem since this phase is very short.            #
 
10
#                                                                              #
 
11
# A wait_timeout of >= 3 seconds was within experiments sufficient even on a   #
 
12
# testing box with heavy parallel load. Therefore 5 seconds should be enough.  #
 
13
#                                                                              #
 
14
# Creation:                                                                    #
 
15
# 2008-12-19 mleich Implement this check needed for test bug fixes             #
 
16
#                                                                              #
 
17
################################################################################
 
18
 
 
19
let $wait_timeout= 5;
 
20
let $wait_condition=
 
21
  SELECT COUNT(*) = 0 FROM information_schema.processlist
 
22
  WHERE user = 'event_scheduler';
 
23
--source include/wait_condition.inc