release/src/router/mysql/mysql-test/include/no_running_event_scheduler.inc

   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