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.

I have upgraded to MySQL version 5.5. There, I had observed performance_schema in the schema list.

  • What is the usage of this new schema..?
  • How can we monitor using this schema..?
  • What are the advantages of using this schema..?
  • Is there any overhead by enabling of this schema..?
share|improve this question
    
I have the same question. Personally, I find the official mysql documents quite useless - you read them and have no clue how to actually use the feature, they are for reference. I am also looking for someone to write a short intro to how one can enable then use the performance_schema. –  John Little Dec 9 '13 at 15:01

1 Answer 1

All of your answers can be found by reading the documentation:

  • What is the usage of this new schema..?

The Performance Schema monitors server events. An “event” is anything the server does that takes time and has been instrumented so that timing information can be collected. In general, an event could be a function call, a wait for the operating system, a stage of an SQL statement execution such as parsing or sorting, or an entire statement or group of statements.

  • What are the advantages of using this schema..?

The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” source

  • Is there any overhead by enabling of this schema..?

Server monitoring occurs continuously and unobtrusively with very little overhead. Activating the Performance Schema does not make the server unusable.

  • How can we monitor using this schema..?

This page gives a basic overview of how to use the performance schema

share|improve this answer
    
Unfortunately, the links provided don't actually say how to enable the performance_schema monitoring. –  John Little Dec 9 '13 at 15:03

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.