For AI agents: A markdown version of this page is available at https://docs.datadoghq.com/ddsql_reference/data_directory/dd/dd.mysql_logical_databases.dataset.md. A documentation index is available at /llms.txt.

MySQL Logical Databases

The MySQL Logical Databases table provides metadata about logical databases discovered in MySQL instances. Each row represents a logical database and includes information such as database name, character set, collation, and a join key to navigate up the hierarchy to the database instance. This table enables you to inventory logical databases, analyze database configurations, and walk the hierarchy (logical database to database instance). The whole hierarchy is mysql_tables → mysql_logical_databases → database_instances (3 tables).

dd.mysql_logical_databases

Fields

TitleIDTypeData TypeDescription
Key_keycorestringUnique identifier for the MySQL logical database record.
Database Namedatabase_namecorestringName of the logical database.
Default Character Setdefault_character_set_namecorestringDefault character set of the logical database.
Default Collationdefault_collation_namecorestringDefault collation of the logical database.
Display Namedisplay_namecorestringHuman-readable display name for the logical database.
Database Instance Keydatabase_instance_keycorestringUsed to join this logical database to dd.database_instances to get instance details and walk the hierarchy (logical database to database instance).