Identify a performance impact when using the Performance Schema.

Identify a performance impact when using the Performance Schema.

Identify a performance impact when using the Performance Schema.

A.
There is no impact on performance.

B.
There is an overhead for querying the Performance Schema but not for having it enabled.

C.
There is a constant overhead regardless of settings and workload.

D.
The overhead depends on the settings of the Performance Schema.

Explanation:



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Me

Me

B, Reference Manual 5.6 page 2926

E

E

It’s theory. Real world answer is D.

Steve

Steve

B is not correct and I cannot find reference on page 2926 in the manual.

From reading on it, D is the answer.

Tim Little

Tim Little

B can be demonstrated as wrong as READING from a table is rarely SLOWER than WRITING to the table.