复习mysql，整理的资料和笔记 ## MySQL知识整理 - [字段类型]()  - char/varchar/text/longtext - enum/set - int[4]/smallint[2]/tinyint[1]/bigint[8] - double/float - datetime/date/timestamp - bit - [索引]() - [聚集索引和非聚集索引区别](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优化]() - [慢查询]() - [配置优化](http://www.cnblogs.com/luyucheng/p/6340076.html) - [主从配置]() - [锁]() - [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) - [聚簇索引和聚簇索引介绍](https://www.cnblogs.com/Jessy/p/3543063.html) - [MySQL笔记](https://github.com/CyC2018/Interview-Notebook/blob/master/notes/MySQL.md)