Performance Schema Stage Event Tables performance-schema-consumer-events-stages-history=ON performance-schema-consumer-events-stages-history-long=ON To control stage event collection at runtime, update the  setup_instruments  and  setup_consumers tables: To collect only specific stage events, enable only the corresponding stage instruments. To collect stage events only for specific stage event tables, enable the stage instruments but only the stage consumers corresponding to the desired tables. For additional information about configuring event collection, see Section 27.3, “Performance Schema Startup Configuration” , and Section 27.4, “Performance Schema Runtime Configuration” . The Performance Schema stage event tables contain two columns that, taken together, provide a stage progress indicator for each row: Each column is  NULL  if no progress information is provided for an instrument. Interpretation of the information, if it is available, depends entirely on the instrument implementation. The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: •The  WORK_COMPLETED  value can increase one or many units at a time, depending on the instrumented code. •A “work unit”  is an integer metric that increases over time during execution, such as the number of bytes, rows, files, or tables processed. The definition of “work unit”  for a particular instrument is left to the instrumentation code providing the data. • WORK_COMPLETED : The number of work units completed for the stage • WORK_ESTIMATED : The number of work units expected for the stage •Disable: •Enable: •Disable: UPDATE performance_schema.setup_instruments SET ENABLED = ’NO’, TIMED = ’NO’ WHERE NAME LIKE ’stage/%’; UPDATE performance_schema.setup_consumers SET ENABLED = ’NO’ WHERE NAME LIKE ’events_stages%’; UPDATE performance_schema.setup_instruments SET ENABLED = ’YES’, TIMED = ’YES’ WHERE NAME LIKE ’stage/%’; UPDATE performance_schema.setup_consumers SET ENABLED = ’YES’ WHERE NAME LIKE ’events_stages%’; [mysqld] performance-schema-instrument=’stage/%=OFF’ performance-schema-consumer-events-stages-current=OFF performance-schema-consumer-events-stages-history=OFF performance-schema-consumer-events-stages-history-long=OFF Stage Event Progress Information 4966