# Mysql 教程

![img](https://raw.githubusercontent.com/dunwu/images/dev/snap/20200716103611.png)

## 📖 内容

### [Mysql 应用指南](mysql-quickstart.md)

### [Mysql 索引](mysql-index.md)

> 关键词：`Hash`、`B 树`、`聚簇索引`、`回表`

![img](https://raw.githubusercontent.com/dunwu/images/dev/snap/20200715172009.png)

### [Mysql 锁](mysql-lock.md)

> 关键词：`乐观锁`、`表级锁`、`行级锁`、`意向锁`、`MVCC`、`Next-key 锁`

![img](https://raw.githubusercontent.com/dunwu/images/dev/snap/20200716064947.png)

### [Mysql 事务](mysql-transaction.md)

> 关键词：`ACID`、`AUTOCOMMIT`、`事务隔离级别`、`死锁`、`分布式事务`

![img](https://raw.githubusercontent.com/dunwu/images/dev/snap/20200716074533.png)

### [Mysql 性能优化](mysql-optimization.md)

### [Mysql 运维](mysql-ops.md) 🔨

### [Mysql 配置](mysql-config.md) 🔨

---

相关扩展知识：

- [关系型数据库面试总结](https://github.com/dunwu/db-tutorial/blob/master/docs/sql/sql-interview.md) 💯
- [SQL Cheat Sheet](https://github.com/dunwu/db-tutorial/blob/master/docs/sql/sql-cheat-sheet.md)
- [分布式事务基本原理](https://github.com/dunwu/blog/blob/master/source/_posts/theory/distributed-transaction.md)

## 📚 资料

- **官方**
  - [Mysql 官网](https://www.mysql.com/)
  - [Mysql 官方文档](https://dev.mysql.com/doc/refman/8.0/en/)
  - [Mysql 官方文档之命令行客户端](https://dev.mysql.com/doc/refman/8.0/en/mysql.html)
- **书籍**
  - [《高性能 MySQL》](https://book.douban.com/subject/23008813/) - 经典，适合 DBA 或作为开发者的参考手册
  - [《MySQL 必知必会》](https://book.douban.com/subject/3354490/) - 适合入门者
- **教程**
  - [MySQL 实战 45 讲](https://time.geekbang.org/column/intro/139)
  - [runoob.com MySQL 教程](http://www.runoob.com/mysql/mysql-tutorial.html)
  - [mysql-tutorial](https://github.com/jaywcjlove/mysql-tutorial)
- **更多资源**
  - [awesome-mysql](https://github.com/jobbole/awesome-mysql-cn)

## 🚪 传送

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