8

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..?
  • 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
  • I found this link useful reference; percona.com/blog/2011/04/25/performance-schema-overhead – PodTech.io May 3 '16 at 15:59
7

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

  • 1
    Unfortunately, the links provided don't actually say how to enable the performance_schema monitoring. – John Little Dec 9 '13 at 15:03
  • MySQL's documentation is hardly the easiest thing to skim-read, which is why having the basic bullet points like this on a stack exchange site is really helpful (as a response to the sliiiightly passive aggressive RTFM line) – Matt Fletcher Nov 20 '15 at 16:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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