content_image/822045.jpg content_image/822046.jpg content_image/822049.jpg
<img src='content_image/822045.jpg'>

Stage event instruments that provide statement progress information are enabled and timed by default: 

mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments WHERE ENABLED=’YES’ AND NAME LIKE "stage/%"; 

<img src='content_image/822046.jpg'>

The stage consumers are disabled by default: 

mysql> SELECT * FROM performance_schema.setup_consumers WHERE NAME LIKE ’events_stages%’; 

<img src='content_image/822049.jpg'>

To control stage event collection at server startup, use lines like these in your my.cnf  file: 

•Enable: 

[mysqld] performance-schema-instrument=’stage/%=ON’ performance-schema-consumer-events-stages-current=ON 

