README.md

## MySQL知识整理

- [事务](https://github.com/xianyunyh/PHP-Interview/blob/master/Mysql/%E4%BA%8B%E5%8A%A1.md)

- [字段类型]()

  ![](https://www.2cto.com/uploadfile/Collfiles/20171201/2017120109334458.png) 

  - char/varchar/text/longtext
  - enum/set
  - int[4]/smallint[2]/tinyint[1]/bigint[8]
  - double/float
  - datetime/date/timestamp
  - bit

- [三范式](https://github.com/xianyunyh/PHP-Interview/blob/master/Mysql/MySQL%E4%B8%89%E8%8C%83%E5%BC%8F.md)

- [存储引擎](https://github.com/xianyunyh/PHP-Interview/blob/master/Mysql/%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E.md)

- [索引]()

  - [聚集索引和非聚集索引区别](https://blog.csdn.net/zc474235918/article/details/50580639) 

  - [索引的分类](https://www.cnblogs.com/luyucheng/p/6289714.html)

- [mysql优化](http://www.cnblogs.com/luyucheng/p/6323477.html)

  - [sql优化]()
    - [explain](https://github.com/xianyunyh/PHP-Interview/blob/master/Mysql/MySQL%E3%80%90explain%E3%80%91.md)
    - [慢查询]()
  - [配置优化](http://www.cnblogs.com/luyucheng/p/6340076.html)
  - [主从配置]()
  - [索引优化](https://github.com/xianyunyh/PHP-Interview/blob/master/Mysql/MySQL%E4%BC%98%E5%8C%96.md)

- [锁]()

  -  [mysql共享锁与排他锁](http://www.cnblogs.com/boblogsbo/p/5602122.html)
  - [乐观锁和悲观锁]()
  - [死锁](https://www.cnblogs.com/sivkun/p/7518540.html)


### 阅读资料

- [MySQL索引背后的数据结构及算法原理](http://blog.codinglabs.org/articles/theory-of-mysql-index.html) 

- [MySQL索引原理及慢查询优化](https://tech.meituan.com/mysql-index.html)

- [InnoDB备忘录 - Next-Key Lock](http://zhongmingmao.me/2017/05/19/innodb-next-key-lock/)

- [MySQL主从复制与读写分离](https://www.cnblogs.com/luckcs/articles/2543607.html)