> For the complete documentation index, see [llms.txt](https://mysql.yunwei361.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mysql.yunwei361.com/li-lun-ji-chu/shu-ju-ku-jie-gou.md).

# 数据库结构

### 逻辑结构

![](/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
```