MySQL system databases and metadata: does MySQL keep its metadata in a database named “meta_sql”? Evaluate this claim against current and historical defaults.

Difficulty: Easy

Correct Answer: Invalid (MySQL stores metadata in information_schema and related system schemas, not “meta_sql”)

Explanation:


Introduction / Context:
Understanding where a DBMS stores metadata helps DBAs query object definitions, privileges, and performance statistics. MySQL provides well-known system schemas for this purpose; confusing their names may lead to incorrect administrative queries.


Given Data / Assumptions:

  • The claim says MySQL keeps metadata in “meta_sql.”
  • We compare this with actual MySQL system schemas.
  • We consider mainstream MySQL distributions.


Concept / Approach:
MySQL uses several system schemas: information_schema (virtual metadata views), performance_schema (instrumentation), and the mysql schema (users, privileges, time zone tables, and other internal data). There is no standard schema named “meta_sql.” Therefore, the statement is incorrect.


Step-by-Step Solution:

List system schemas in a stock MySQL instance: information_schema, performance_schema, mysql, sys (helper views).Identify that metadata about tables, columns, and routines is obtained from information_schema views.Conclude that “meta_sql” is not a MySQL system database.Therefore, the claim is invalid.


Verification / Alternative check:
Run SHOW DATABASES; inspect the presence of the documented system schemas and the absence of “meta_sql.”


Why Other Options Are Wrong:

  • OS, engine, or fork do not create a “meta_sql” schema by default.


Common Pitfalls:
Confusing MySQL system schemas with SQL Server’s system databases or assuming custom admin-created schemas are universal.


Final Answer:
Invalid (MySQL stores metadata in information_schema and related system schemas, not “meta_sql”)

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion