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 19let $wait_timeout= 5; 20let $wait_condition= 21 SELECT COUNT(*) = 0 FROM information_schema.processlist 22 WHERE user = 'event_scheduler'; 23--source include/wait_condition.inc 24