Skip to content

Commit 6496371

Browse files
dunwudunwu
committed
update docs
1 parent 463bef3 commit 6496371

24 files changed

+720
-534
lines changed

‎README.md

Lines changed: 19 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -22,44 +22,45 @@
2222

2323
> [关系型数据库](docs/sql) 整理主流关系型数据库知识点。
2424
25-
[关系型数据库面试总结](docs/sql/sql-interview.md) 💯
25+
#### [共性知识](docs/sql/common)
2626

27-
[**SQL Cheat Sheet**](docs/sql/sql-cheat-sheet.md) 是一个 SQL 入门教程。
27+
- [关系型数据库面试总结](docs/sql/common/sql-interview.md) 💯
28+
- [SQL Cheat Sheet](docs/sql/common/sql-cheat-sheet.md) 是一个 SQL 入门教程。
29+
- [分布式存储基本原理](https://github.com/dunwu/blog/blob/master/source/_posts/theory/distributed-storage-theory.md)
30+
- [分布式事务基本原理](https://github.com/dunwu/blog/blob/master/source/_posts/theory/distributed-transaction.md)
2831

29-
![img](http://dunwu.test.upcdn.net/snap/20200115160512.png)
32+
#### [Mysql](docs/sql/mysql) 📚
3033

31-
#### Mysql
34+
![img](http://dunwu.test.upcdn.net/snap/20200716103611.png)
3235

33-
> [Mysql](docs/sql/mysql) 📚 是互联网最流行的关系型数据库。
34-
35-
- [Mysql 应用指南](docs/sql/mysql/mysql-quickstart.md)
36-
- [Mysql 索引](docs/sql/mysql/mysql-index.md)
37-
- [Mysql 锁](docs/sql/mysql/mysql-lock.md)
38-
- [Mysql 事务](docs/sql/mysql/mysql-transaction.md)
36+
- [Mysql 应用指南](docs/sql/mysql/mysql-quickstart.md) ⚡
37+
- [Mysql 工作流](docs/sql/mysql/mysql-index.md) - 关键词：`连接`、`缓存`、`语法分析`、`优化`、`执行引擎`、`redo log`、`bin log`、`两阶段提交`
38+
- [Mysql 索引](docs/sql/mysql/mysql-index.md) - 关键词：`Hash`、`B 树`、`聚簇索引`、`回表`
39+
- [Mysql 锁](docs/sql/mysql/mysql-lock.md) - 关键词：`乐观锁`、`表级锁`、`行级锁`、`意向锁`、`MVCC`、`Next-key 锁`
40+
- [Mysql 事务](docs/sql/mysql/mysql-transaction.md) - 关键词：`ACID`、`AUTOCOMMIT`、`事务隔离级别`、`死锁`、`分布式事务`
3941
- [Mysql 性能优化](docs/sql/mysql/mysql-optimization.md)
4042
- [Mysql 运维](docs/sql/mysql/mysql-ops.md) 🔨
4143
- [Mysql 配置](docs/sql/mysql/mysql-config.md)
44+
- [Mysql 问题](docs/sql/mysql/mysql-faq.md)
4245

4346
#### 其他关系型数据库
4447

45-
- [H2 入门指南](docs/sql/h2.md)
46-
- [SqLite 入门指南](docs/sql/sqlite.md)
47-
- [PostgreSQL 入门指南](docs/sql/postgresql.md)
48+
- [H2 应用指南](docs/sql/h2.md)
49+
- [SqLite 应用指南](docs/sql/sqlite.md)
50+
- [PostgreSQL 应用指南](docs/sql/postgresql.md)
4851

4952
### Nosql 数据库
5053

5154
> [Nosql 数据库](docs/nosql) 整理主流 Nosql 数据库知识点。
5255
5356
- [Nosql 技术选型](docs/nosql/nosql-selection.md)
5457

55-
#### Redis
56-
57-
> [Redis](docs/nosql/redis) 📚
58+
#### [Redis](docs/nosql/redis) 📚
5859

5960
![img](http://dunwu.test.upcdn.net/snap/20200713105627.png)
6061

6162
- [Redis 面试总结](docs/nosql/redis/redis-interview.md) 💯
62-
- [Redis 入门指南](docs/nosql/redis/redis-quickstart.md) ⚡ - 关键词：`内存淘汰`、`事件`、`事务`、`管道`、`发布与订阅`
63+
- [Redis 应用指南](docs/nosql/redis/redis-quickstart.md) ⚡ - 关键词：`内存淘汰`、`事件`、`事务`、`管道`、`发布与订阅`
6364
- [Redis 数据类型和应用](docs/nosql/redis/redis-datatype.md) - 关键词：`STRING`、`HASH`、`LIST`、`SET`、`ZSET`、`BitMap`、`HyperLogLog`、`Geo`
6465
- [Redis 持久化](docs/nosql/redis/redis-persistence.md) - 关键词：`RDB`、`AOF`、`SAVE`、`BGSAVE`、`appendfsync`
6566
- [Redis 复制](docs/nosql/redis/redis-replication.md) - 关键词：`SLAVEOF`、`SYNC`、`PSYNC`、`REPLCONF ACK`
@@ -115,7 +116,7 @@
115116
- **书籍**
116117
- [《Redis 实战》](https://item.jd.com/11791607.html)
117118
- [《Redis 设计与实现》](https://item.jd.com/11486101.html)
118-
- 源码
119+
- **源码**
119120
- [《Redis 实战》配套 Python 源码](https://github.com/josiahcarlson/redis-in-action)
120121
- **资源汇总**
121122
- [awesome-redis](https://github.com/JamzyWang/awesome-redis)

‎assets/mysql/Mysql.xmind

-38.6 KB
Binary file not shown.

‎assets/redis/redis.xmind renamed to ‎assets/redis/Redis.xmind

File renamed without changes.

‎docs/README.md

Lines changed: 31 additions & 27 deletions
Original file line numberDiff line numberDiff line change
@@ -23,34 +23,45 @@ footer: CC-BY-SA-4.0 Licensed | Copyright © 2018-Now Dunwu
2323

2424
> [关系型数据库](sql) 整理主流关系型数据库知识点。
2525
26-
- [关系型数据库面试总结](sql/sql-interview.md) 💯
27-
- [SQL Cheat Sheet](sql/sql-cheat-sheet.md)
28-
- [Mysql](sql/mysql) 📚
29-
- [Mysql 应用指南](sql/mysql/mysql-quickstart.md)
30-
- [Mysql 索引](sql/mysql/mysql-index.md)
31-
- [Mysql 锁](sql/mysql/mysql-lock.md)
32-
- [Mysql 事务](sql/mysql/mysql-transaction.md)
33-
- [Mysql 性能优化](sql/mysql/mysql-optimization.md)
34-
- [Mysql 运维](sql/mysql/mysql-ops.md) 🔨
35-
- [Mysql 配置](sql/mysql/mysql-config.md)
36-
- [H2 入门指南](sql/h2.md)
37-
- [SqLite 入门指南](sql/sqlite.md)
38-
- [PostgreSQL 入门指南](sql/postgresql.md)
26+
#### [共性知识](sql/common)
27+
28+
- [关系型数据库面试总结](sql/common/sql-interview.md) 💯
29+
- [SQL Cheat Sheet](sql/common/sql-cheat-sheet.md) 是一个 SQL 入门教程。
30+
- [分布式存储基本原理](https://github.com/dunwu/blog/blob/master/source/_posts/theory/distributed-storage-theory.md)
31+
- [分布式事务基本原理](https://github.com/dunwu/blog/blob/master/source/_posts/theory/distributed-transaction.md)
32+
33+
#### [Mysql](sql/mysql) 📚
34+
35+
![img](http://dunwu.test.upcdn.net/snap/20200716103611.png)
36+
37+
- [Mysql 应用指南](sql/mysql/mysql-quickstart.md) ⚡
38+
- [Mysql 工作流](sql/mysql/mysql-index.md) - 关键词：`连接`、`缓存`、`语法分析`、`优化`、`执行引擎`、`redo log`、`bin log`、`两阶段提交`
39+
- [Mysql 索引](sql/mysql/mysql-index.md) - 关键词：`Hash`、`B 树`、`聚簇索引`、`回表`
40+
- [Mysql 锁](sql/mysql/mysql-lock.md) - 关键词：`乐观锁`、`表级锁`、`行级锁`、`意向锁`、`MVCC`、`Next-key 锁`
41+
- [Mysql 事务](sql/mysql/mysql-transaction.md) - 关键词：`ACID`、`AUTOCOMMIT`、`事务隔离级别`、`死锁`、`分布式事务`
42+
- [Mysql 性能优化](sql/mysql/mysql-optimization.md)
43+
- [Mysql 运维](sql/mysql/mysql-ops.md) 🔨
44+
- [Mysql 配置](sql/mysql/mysql-config.md)
45+
- [Mysql 问题](sql/mysql/mysql-faq.md)
46+
47+
#### 其他关系型数据库
48+
49+
- [H2 应用指南](sql/h2.md)
50+
- [SqLite 应用指南](sql/sqlite.md)
51+
- [PostgreSQL 应用指南](sql/postgresql.md)
3952

4053
### Nosql 数据库
4154

4255
> [Nosql 数据库](nosql) 整理主流 Nosql 数据库知识点。
4356
4457
- [Nosql 技术选型](nosql/nosql-selection.md)
4558

46-
#### Redis
47-
48-
> [Redis](nosql/redis) 📚
59+
#### [Redis](nosql/redis) 📚
4960

5061
![img](http://dunwu.test.upcdn.net/snap/20200713105627.png)
5162

5263
- [Redis 面试总结](nosql/redis/redis-interview.md) 💯
53-
- [Redis 入门指南](nosql/redis/redis-quickstart.md) ⚡ - 关键词：`内存淘汰`、`事件`、`事务`、`管道`、`发布与订阅`
64+
- [Redis 应用指南](nosql/redis/redis-quickstart.md) ⚡ - 关键词：`内存淘汰`、`事件`、`事务`、`管道`、`发布与订阅`
5465
- [Redis 数据类型和应用](nosql/redis/redis-datatype.md) - 关键词：`STRING`、`HASH`、`LIST`、`SET`、`ZSET`、`BitMap`、`HyperLogLog`、`Geo`
5566
- [Redis 持久化](nosql/redis/redis-persistence.md) - 关键词：`RDB`、`AOF`、`SAVE`、`BGSAVE`、`appendfsync`
5667
- [Redis 复制](nosql/redis/redis-replication.md) - 关键词：`SLAVEOF`、`SYNC`、`PSYNC`、`REPLCONF ACK`
@@ -106,7 +117,7 @@ footer: CC-BY-SA-4.0 Licensed | Copyright © 2018-Now Dunwu
106117
- **书籍**
107118
- [《Redis 实战》](https://item.jd.com/11791607.html)
108119
- [《Redis 设计与实现》](https://item.jd.com/11486101.html)
109-
- 源码
120+
- **源码**
110121
- [《Redis 实战》配套 Python 源码](https://github.com/josiahcarlson/redis-in-action)
111122
- **资源汇总**
112123
- [awesome-redis](https://github.com/JamzyWang/awesome-redis)
@@ -117,13 +128,6 @@ footer: CC-BY-SA-4.0 Licensed | Copyright © 2018-Now Dunwu
117128
- [CRUG | Redisson PRO vs. Jedis: Which Is Faster? 翻译](https://www.jianshu.com/p/82f0d5abb002)
118129
- [redis 分布锁 Redisson 性能测试](https://blog.csdn.net/everlasting_188/article/details/51073505)
119130

120-
## 🚪 传送门
121-
122-
◾ 🏠 [LINUX-TUTORIAL 首页](https://github.com/dunwu/linux-tutorial) ◾ 🎯 [我的博客](https://github.com/dunwu/blog) ◾
123-
124-
125-
126-
127-
128-
131+
## 🚪 传送
129132

133+
◾ 🏠 [DB-TUTORIAL 首页](https://github.com/dunwu/db-tutorial) ◾ 🎯 [我的博客](https://github.com/dunwu/blog) ◾

‎docs/nosql/README.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -49,6 +49,6 @@ TODO: 待补充
4949
- [CRUG | Redisson PRO vs. Jedis: Which Is Faster? 翻译](https://www.jianshu.com/p/82f0d5abb002)
5050
- [redis 分布锁 Redisson 性能测试](https://blog.csdn.net/everlasting_188/article/details/51073505)
5151

52-
## 🚪 传送门
52+
## 🚪 传送
5353

5454
◾ 🏠 [DB-TUTORIAL 首页](https://github.com/dunwu/db-tutorial) ◾ 🎯 [我的博客](https://github.com/dunwu/blog) ◾

‎docs/nosql/elasticsearch/README.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -24,11 +24,11 @@
2424
> Elastic 技术栈，在 ELK 的基础上扩展了一些新的产品，如：[Beats](https://www.elastic.co/products/beats) 、[X-Pack](https://www.elastic.co/products/x-pack) 。
2525
2626
- [Elastic 技术栈快速入门](nosql/elasticsearch/elastic/elastic-quickstart.md)
27-
- [Beats 入门指南](nosql/elasticsearch/elastic/elastic-beats.md)
27+
- [Beats 应用指南](nosql/elasticsearch/elastic/elastic-beats.md)
2828
- [Beats 运维](nosql/elasticsearch/elastic/elastic-beats-ops.md)
29-
- [Kibana 入门指南](nosql/elasticsearch/elastic/elastic-kibana.md)
29+
- [Kibana 应用指南](nosql/elasticsearch/elastic/elastic-kibana.md)
3030
- [Kibana 运维](nosql/elasticsearch/elastic/elastic-kibana-ops.md)
31-
- [Logstash 入门指南](nosql/elasticsearch/elastic/elastic-logstash.md)
31+
- [Logstash 应用指南](nosql/elasticsearch/elastic/elastic-logstash.md)
3232
- [Logstash 运维](nosql/elasticsearch/elastic/elastic-logstash-ops.md)
3333

3434
## 📚 资料

‎docs/nosql/redis/README.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010

1111
### [Redis 面试总结 💯](redis-interview.md)
1212

13-
### [Redis 入门指南 ⚡](redis-quickstart.md)
13+
### [Redis 应用指南 ⚡](redis-quickstart.md)
1414

1515
> 关键词：`内存淘汰`、`事件`、`事务`、`管道`、`发布与订阅`
1616

‎docs/nosql/redis/redis-interview.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -129,7 +129,7 @@ AOF 丢数据比 RDB 少，但文件会比 RDB 文件大很多。
129129

130130
> **_Redis 的事务特性、原理_**
131131
>
132-
> 详情参考：[Redis 入门指南之 事务](redis-quickstart.md#六redis-事务)
132+
> 详情参考：[Redis 应用指南之 事务](redis-quickstart.md#六redis-事务)
133133
134134
**Redis 提供的不是严格的事务，Redis 只保证串行执行命令，并且能保证全部执行，但是执行命令失败时并不会回滚，而是会继续执行下去**。
135135

‎docs/nosql/redis/redis-quickstart.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
# Redis 入门指南
1+
# Redis 应用指南
22

33
<!-- TOC depthFrom:2 depthTo:3 -->
44

‎docs/sql/README.md

Lines changed: 14 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -4,23 +4,26 @@
44
55
## 📖 内容
66

7-
- [关系型数据库面试题 💯](sql-interview.md)
7+
### [共性知识](common)
88

9-
### SQL
10-
11-
![img](http://dunwu.test.upcdn.net/snap/20200115160512.png)
12-
13-
- [SQL Cheat Sheet](sql-cheat-sheet.md) - SQL 速查手册
9+
- [关系型数据库面试总结](common/sql-interview.md) 💯
10+
- [SQL Cheat Sheet](common/sql-cheat-sheet.md) 是一个 SQL 入门教程。
11+
- [分布式存储基本原理](https://github.com/dunwu/blog/blob/master/source/_posts/theory/distributed-storage-theory.md)
12+
- [分布式事务基本原理](https://github.com/dunwu/blog/blob/master/source/_posts/theory/distributed-transaction.md)
1413

1514
### [Mysql](mysql/README.md)
1615

17-
- [Mysql 基本原理](mysql/mysql-theory.md)
18-
- [Mysql 索引](mysql/mysql-index.md)
19-
- [Mysql 锁](mysql/mysql-lock.md)
20-
- [Mysql 事务](mysql/mysql-transaction.md)
16+
![img](http://dunwu.test.upcdn.net/snap/20200716103611.png)
17+
18+
- [Mysql 应用指南](mysql/mysql-quickstart.md) ⚡
19+
- [Mysql 工作流](mysql/mysql-index.md) - 关键词：`连接`、`缓存`、`语法分析`、`优化`、`执行引擎`、`redo log`、`bin log`、`两阶段提交`
20+
- [Mysql 索引](mysql/mysql-index.md) - 关键词：`Hash`、`B 树`、`聚簇索引`、`回表`
21+
- [Mysql 锁](mysql/mysql-lock.md) - 关键词：`乐观锁`、`表级锁`、`行级锁`、`意向锁`、`MVCC`、`Next-key 锁`
22+
- [Mysql 事务](mysql/mysql-transaction.md) - 关键词：`ACID`、`AUTOCOMMIT`、`事务隔离级别`、`死锁`、`分布式事务`
2123
- [Mysql 性能优化](mysql/mysql-optimization.md)
2224
- [Mysql 运维](mysql/mysql-ops.md) 🔨
2325
- [Mysql 配置](mysql/mysql-config.md)
26+
- [Mysql 问题](mysql/mysql-faq.md)
2427

2528
### 其他关系型数据库
2629

@@ -43,6 +46,6 @@
4346
- **更多资源**
4447
- [awesome-mysql](https://github.com/jobbole/awesome-mysql-cn)
4548

46-
## 🚪 传送门
49+
## 🚪 传送
4750

4851
◾ 🏠 [DB-TUTORIAL 首页](https://github.com/dunwu/db-tutorial) ◾ 🎯 [我的博客](https://github.com/dunwu/blog) ◾

0 commit comments

Comments
 (0)