# 数据库结构

### 逻辑结构

![](https://1497818641-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMGxklqVlTadIHcFo0mxF%2Fuploads%2Fgit-blob-b5340b247b9c068c369eb883bcdf5f4d3f1ef4a7%2F%E6%95%B0%E6%8D%AE%E5%BA%93%E9%80%BB%E8%BE%91%E5%85%B3%E7%B3%BB.png?alt=media)

### 物理存储结构

![](https://1497818641-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMGxklqVlTadIHcFo0mxF%2Fuploads%2Fgit-blob-e1d61e3195f3a55706700b3a7ea744bd3eb3e7f6%2F%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%A9%E7%90%86%E5%AD%98%E5%82%A8%E7%BB%93%E6%9E%84.png?alt=media)

#### 例子

```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
```