---
title: MySQL Logical Databases
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > MySQL Logical Databases
---

# 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

| Title                 | ID                         | Type | Data Type | Description                                                                                                                                         |
| --------------------- | -------------------------- | ---- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------- |
| Key                   | _key                       | core | string    | Unique identifier for the MySQL logical database record.                                                                                            |
| Database Name         | database_name              | core | string    | Name of the logical database.                                                                                                                       |
| Default Character Set | default_character_set_name | core | string    | Default character set of the logical database.                                                                                                      |
| Default Collation     | default_collation_name     | core | string    | Default collation of the logical database.                                                                                                          |
| Display Name          | display_name               | core | string    | Human-readable display name for the logical database.                                                                                               |
| Database Instance Key | database_instance_key      | core | string    | Used to join this logical database to dd.database_instances to get instance details and walk the hierarchy (logical database to database instance). |