Question

Which data directory subdirectory provides the information used to inspect the internal execution of the server at runtime.

(a) mysql

(b) performance_schema

(c) sys

(d) nbdinfo

This question was posed to me during an interview for a job.

This is a very interesting question from Location of the Data Directory in division MySQL Data Directory of MySQL

Answer 1

Right option is (b) performance_schema

To elaborate: The ‘performance_schema’ directory corresponds to the Performance Schema. It provides information used to inspect the internal execution of the server at runtime. The ‘sys’ directory maps to ‘nbdinfo’.