# 数据库结构

### 逻辑结构

![](/files/8PRO0SP9eh3AAcWxQym8)

### 物理存储结构

![](/files/vLrQWmX0PPrzV4AnXMfr)

#### 例子

```bash
# MyISAM 引擎的表
[root@db01 data]# ls -l /data/mysql/data/mysql | grep user
-rw-r----- 1 mysql mysql   10816 Feb 13 10:27 user.frm
-rw-r----- 1 mysql mysql     972 Feb 13 21:36 user.MYD
-rw-r----- 1 mysql mysql    4096 Feb 14 01:39 user.MYI
```

```bash
# InnoDB 引擎(默认的存储引擎）的表：
[root@db01 data]# ls -l /data/mysql/data/mysql | grep servers
-rw-r----- 1 mysql mysql    8838 Feb 13 10:27 servers.frm
-rw-r----- 1 mysql mysql   98304 Feb 13 10:27 servers.ibd
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mysql.yunwei361.com/li-lun-ji-chu/shu-ju-ku-jie-gou.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.