• Marc Alff's avatar
    Bug#58512 Performance_schema.myisam_file_io fails sporadically in PB2 · 639b2598
    Marc Alff authored
    Before this fix, the test myisam_file_io executed:
    - (a) an update on setup_instrument to disable non myisam file io instruments
    - (b) a truncate on events_waits_history_long
    and later
    - (c) a select on events_waits_history_long
    
    Surprisingly, events that were supposed to be disabled in (a) and removed in (b)
    still were found in (c).
    
    This happened for events such as 
      wait/io/file/innodb/innodb_data_file fil0fil.c: sync  
    because the sync was started before (a) and completed after (b),
    and as a consequence was added in the performance schema history, as expected.
    
    Presence of these records in the history made the test fail. 
    
    This fix makes the test script more robust to account for extra spill waits records in (c).
    639b2598
myisam_file_io.test 2.51 KB