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 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 LittleDec 9 '13 at 15:01

1 Answer
1

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.