復習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)