Monitoring

Question 1

What does the Performance Schema provide?

a) recommendations for schema changes
b) a text based version of Mysql enterprise monitor
c) insight into the internal workings of MySQL

Answer 1

c)

The Performance Schema provides a way to inspect internal execution of the server at runtime.

It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. The Performance Schema focuses primarily on performance data.