Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

With latest MySQL version Performance_Schema is enabled by default and you can enable Instruments and Consumers as well to gather all performance related metrics and which is very useful to see performance and improve it later.

I would like to know:

  1. What is the impact of P_S if all instruments and consumers are enabled?
  2. Is it feasible to enable instruments and consumers on a production environment ?
share|improve this question
Nobody has any clue for this ? –  Mahesh Patil Dec 18 '13 at 14:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.