Skip to content

Commit c05b22e

Browse files
dunwudunwu
committed
update docs
1 parent 84d6d0a commit c05b22e

File tree

13 files changed

+1444
-1581
lines changed

13 files changed

+1444
-1581
lines changed

‎README.md

Lines changed: 18 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -5,22 +5,26 @@
55
> - 🔁 项目同步维护：[Github](https://github.com/dunwu/db-tutorial/) | [Gitee](https://gitee.com/turnon/db-tutorial/)
66
> - 📖 电子书阅读：[Github Pages](https://dunwu.github.io/db-tutorial/) | [Gitee Pages](https://turnon.gitee.io/db-tutorial/)
77
8-
## 知识点
8+
## 关系型数据库
99

10-
- 1️⃣ [关系型数据库](docs/sql/README.md)
11-
- [关系型数据库面试题](docs/sql/sql-interview.md)
12-
- [关系型数据库基本原理](docs/sql/sql-theory.md)
13-
- [SQL 基本语法](docs/sql/sql-grammar.md)
14-
- [H2 快速指南](docs/sql/h2.md)
15-
- [SqLite 快速指南](docs/sql/sqlite.md)
16-
- [PostgreSQL 快速指南](docs/sql/postgresql.md)
17-
- [数据库中间件 flyway](docs/sql/middleware/flyway.md)
18-
- 2️⃣ [Nosql](docs/nosql/README.md)
19-
- 3️⃣ [Mysql](docs/sql/mysql/README.md)
10+
> [关系型数据库](docs/sql/README.md)
11+
12+
- [关系型数据库面试题 💯](docs/sql/sql-interview.md)
13+
- [SQL 语法速成手册](docs/sql/sql-grammar.md)
14+
- [H2 快速指南](docs/sql/h2.md)
15+
- [SqLite 快速指南](docs/sql/sqlite.md)
16+
- [PostgreSQL 快速指南](docs/sql/postgresql.md)
17+
- [数据库中间件 flyway](docs/sql/middleware/flyway.md)
18+
- [Mysql](docs/sql/mysql/README.md)
2019
- [Mysql 原理](docs/sql/mysql/mysql-theory.md)
21-
- [Mysql 维护](docs/sql/mysql/mysql-ops.md)
22-
- [Mysql 配置](docs/sql/mysql/mysql-config.md)
23-
- 4️⃣ [Redis](docs/nosql/redis/README.md)
20+
- [Mysql 运维](docs/sql/mysql/mysql-ops.md)
21+
- [Mysql 服务器配置详解](docs/sql/mysql/mysql-config.md)
22+
23+
## Nosql 数据库
24+
25+
> [Nosql 数据库](docs/nosql/README.md)
26+
27+
- [Redis](docs/nosql/redis/README.md)
2428
- [Redis 快速入门](docs/nosql/redis/redis.md)
2529
- [Redis 持久化](docs/nosql/redis/redis-persistence.md)
2630
- [Redis 复制](docs/nosql/redis/redis-replication.md)

‎assets/xmind/database.xmind

-168 KB
Binary file not shown.

‎assets/xmind/mysql.xmind

884 KB
Binary file not shown.

‎assets/xmind/sql.xmind

-156 KB
Binary file not shown.

‎docs/README.md

Lines changed: 18 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -5,22 +5,26 @@
55
> - 🔁 项目同步维护：[Github](https://github.com/dunwu/db-tutorial/) | [Gitee](https://gitee.com/turnon/db-tutorial/)
66
> - 📖 电子书阅读：[Github Pages](https://dunwu.github.io/db-tutorial/) | [Gitee Pages](https://turnon.gitee.io/db-tutorial/)
77
8-
## 知识点
8+
## 关系型数据库
99

10-
- 1️⃣ [关系型数据库](sql/README.md)
11-
- [关系型数据库面试题](sql/sql-interview.md)
12-
- [关系型数据库基本原理](sql/sql-theory.md)
13-
- [SQL 基本语法](sql/sql-grammar.md)
14-
- [H2 快速指南](sql/h2.md)
15-
- [SqLite 快速指南](sql/sqlite.md)
16-
- [PostgreSQL 快速指南](sql/postgresql.md)
17-
- [数据库中间件 flyway](sql/middleware/flyway.md)
18-
- 2️⃣ [Nosql](nosql/README.md)
19-
- 3️⃣ [Mysql](sql/mysql/README.md)
10+
> [关系型数据库](sql/README.md)
11+
12+
- [关系型数据库面试题 💯](sql/sql-interview.md)
13+
- [SQL 语法速成手册](sql/sql-grammar.md)
14+
- [H2 快速指南](sql/h2.md)
15+
- [SqLite 快速指南](sql/sqlite.md)
16+
- [PostgreSQL 快速指南](sql/postgresql.md)
17+
- [数据库中间件 flyway](sql/middleware/flyway.md)
18+
- [Mysql](sql/mysql/README.md)
2019
- [Mysql 原理](sql/mysql/mysql-theory.md)
21-
- [Mysql 维护](sql/mysql/mysql-ops.md)
22-
- [Mysql 配置](sql/mysql/mysql-config.md)
23-
- 4️⃣ [Redis](nosql/redis/README.md)
20+
- [Mysql 运维](sql/mysql/mysql-ops.md)
21+
- [Mysql 服务器配置详解](sql/mysql/mysql-config.md)
22+
23+
## Nosql 数据库
24+
25+
> [Nosql 数据库](nosql/README.md)
26+
27+
- [Redis](nosql/redis/README.md)
2428
- [Redis 快速入门](nosql/redis/redis.md)
2529
- [Redis 持久化](nosql/redis/redis-persistence.md)
2630
- [Redis 复制](nosql/redis/redis-replication.md)

‎docs/coverpage.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,6 +2,6 @@
22

33
# DB Tutorial
44

5-
> **db-tutorial** 是一个数据库教程。
5+
> 💾 **db-tutorial** 是一个数据库教程。
66
77
[开始阅读](README.md)

‎docs/sidebar.md

Lines changed: 5 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,20 +1,19 @@
11
# db-tutorial
22

33
- [关系型数据库](sql/README.md)
4-
- [关系型数据库面试题](sql/sql-interview.md)
5-
- [关系型数据库基本原理](sql/sql-theory.md)
6-
- [SQL 基本语法](sql/sql-grammar.md)
4+
- [关系型数据库面试题 💯](sql/sql-interview.md)
5+
- [SQL 语法速成手册](sql/sql-grammar.md)
76
- [H2 快速指南](sql/h2.md)
87
- [SqLite 快速指南](sql/sqlite.md)
98
- [PostgreSQL 快速指南](sql/postgresql.md)
109
- [数据库中间件 flyway](sql/middleware/flyway.md)
1110
- [Mysql](sql/mysql/README.md)
12-
- [Mysql 命令](sql/mysql/mysql-cli.md)
13-
- [Mysql 运维](sql/mysql/mysql-ops.md)
1411
- [Mysql 原理](sql/mysql/mysql-theory.md)
12+
- [Mysql 运维](sql/mysql/mysql-ops.md)
13+
- [Mysql 服务器配置详解](sql/mysql/mysql-config.md)
1514
- [Nosql 数据库](nosql/README.md)
1615
- [Redis](nosql/redis/README.md)
17-
- [Redis 入门指南](nosql/redis/redis.md)
16+
- [Redis 快速入门](nosql/redis/redis.md)
1817
- [Redis 持久化](nosql/redis/redis-persistence.md)
1918
- [Redis 复制](nosql/redis/redis-replication.md)
2019
- [Redis 哨兵](nosql/redis/redis-sentinel.md)

‎docs/sql/mysql/README.md

Lines changed: 18 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -2,30 +2,24 @@
22

33
## :memo: 知识点
44

5-
- [mysql 原理](mysql-theory.md)
6-
- [mysql 维护](mysql-ops.md)
7-
- [mysql 配置](mysql-config.md)
8-
9-
## 📚 学习资源
10-
11-
### 官方
12-
13-
- [Mysql 官网](https://www.mysql.com/)
14-
- [Mysql 官方文档](https://dev.mysql.com/doc/refman/8.0/en/)
15-
- [Mysql 官方文档之命令行客户端](https://dev.mysql.com/doc/refman/8.0/en/mysql.html)
16-
17-
### 书
18-
19-
- [MySQL 必知必会](https://book.douban.com/subject/3354490/) - 适合入门者
20-
- [高性能 MySQL](https://book.douban.com/subject/23008813/) - 经典，适合 DBA 或作为开发者的参考手册
21-
22-
### 在线教程
23-
24-
[runoob.com MySQL 教程](http://www.runoob.com/mysql/mysql-tutorial.html) - 入门级教程
25-
26-
### 更多资源
27-
28-
- [awesome-mysql](https://github.com/jobbole/awesome-mysql-cn)
5+
- [Mysql 原理](mysql-theory.md)
6+
- [Mysql 运维](mysql-ops.md)
7+
- [Mysql 服务器配置说明](mysql-config.md)
8+
9+
## 📚 资源
10+
11+
- **官方**
12+
- [Mysql 官网](https://www.mysql.com/)
13+
- [Mysql 官方文档](https://dev.mysql.com/doc/refman/8.0/en/)
14+
- [Mysql 官方文档之命令行客户端](https://dev.mysql.com/doc/refman/8.0/en/mysql.html)
15+
- **书籍**
16+
- [《高性能 MySQL》](https://book.douban.com/subject/23008813/) - 经典，适合 DBA 或作为开发者的参考手册
17+
- [《MySQL 必知必会》](https://book.douban.com/subject/3354490/) - 适合入门者
18+
- **教程**
19+
- [runoob.com MySQL 教程](http://www.runoob.com/mysql/mysql-tutorial.html) - 入门级 SQL 教程
20+
- [mysql-tutorial](https://github.com/jaywcjlove/mysql-tutorial)
21+
- **更多资源**
22+
- [awesome-mysql](https://github.com/jobbole/awesome-mysql-cn)
2923

3024
## :door: 传送门
3125

‎docs/sql/mysql/mysql-config.md

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
# Mysql 服务器配置说明
22

3-
> 版本：![mysql](https：//img.shields.io/badge/mysql-8.0-blue)
3+
> 版本：![mysql](https://img.shields.io/badge/mysql-8.0-blue)
44
5-
## 1. 基本配置
5+
## 一、基本配置
66

77
```ini
88
[mysqld]
@@ -47,7 +47,7 @@ socket = /var/lib/mysql/mysql.sock
4747
port = 3306
4848
```
4949

50-
## 2. 配置项说明
50+
## 二、配置项说明
5151

5252
```ini
5353
[client]
@@ -469,7 +469,7 @@ auto-rehash
469469
socket = /var/lib/mysql/mysql.sock
470470
```
471471

472-
## 3. 参考资料
472+
## 参考资料
473473

474474
- [高性能 MySQL](https：//book.douban.com/subject/23008813/)
475475
- [Mysql 配置文件/etc/my.cnf 解析](https：//www.jianshu.com/p/5f39c486561b)

0 commit comments

Comments
 (0)