# Data Base

- [Cache](/phper/data-base/cache.md)
- [如何保证缓存与数据库的双写一致性](/phper/data-base/cache/ru-he-bao-zheng-huan-cun-yu-shu-ju-ku-de-shuang-xie-yi-zhi-xing.md)
- [Memcached和Redis对比](/phper/data-base/cache/memcached-he-redis-dui-bi.md)
- [ES](/phper/data-base/es.md)
- [倒排索引](/phper/data-base/es/dao-pai-suo-yin.md)
- [概念](/phper/data-base/es/gai-nian.md)
- [入门](/phper/data-base/es/ru-men.md)
- [Memcached](/phper/data-base/memcached.md)
- [Memcached介绍](/phper/data-base/memcached/memcached-jie-shao.md)
- [Memcached使用](/phper/data-base/memcached/memcached-shi-yong.md)
- [Mongo DB](/phper/data-base/mongo-db.md)
- [安装](/phper/data-base/mongo-db/an-zhuang.md)
- [MongoDB查询](/phper/data-base/mongo-db/mongodb-cha-xun.md)
- [MongoDB连接](/phper/data-base/mongo-db/mongodb-lian-jie.md)
- [MongoDB入门](/phper/data-base/mongo-db/mongodb-ru-men.md)
- [My Cat](/phper/data-base/my-cat.md)
- [原理](/phper/data-base/my-cat/yuan-li.md)
- [Mycat中的概念](/phper/data-base/my-cat/mycat-zhong-de-gai-nian.md)
- [My SQL](/phper/data-base/my-sql.md)
- [基础篇](/phper/data-base/my-sql/ji-chu-pian.md)
- [\[1. Mysql\](DataBase/MySQL/基础篇/1. Mysql.md)](/phper/data-base/my-sql/ji-chu-pian/1.-mysqldatabasemysql-ji-chu-pian-1.-mysql.md.md)
- [\[2. 数据库操作\](DataBase/MySQL/基础篇/2. 数据库操作.md)](/phper/data-base/my-sql/ji-chu-pian/2.-shu-ju-ku-cao-zuo-databasemysql-ji-chu-pian-2.-shu-ju-ku-cao-zuo-.md.md)
- [\[3. 数据类型\](DataBase/MySQL/基础篇/3. 数据类型.md)](/phper/data-base/my-sql/ji-chu-pian/3.-shu-ju-lei-xing-databasemysql-ji-chu-pian-3.-shu-ju-lei-xing-.md.md)
- [\[4. 数据库设计\](DataBase/MySQL/基础篇/4. 数据库设计.md)](/phper/data-base/my-sql/ji-chu-pian/4.-shu-ju-ku-she-ji-databasemysql-ji-chu-pian-4.-shu-ju-ku-she-ji-.md.md)
- [\[5. 索引\](DataBase/MySQL/基础篇/5. 索引.md)](/phper/data-base/my-sql/ji-chu-pian/5.-suo-yin-databasemysql-ji-chu-pian-5.-suo-yin-.md.md)
- [\[6. 事务\](DataBase/MySQL/基础篇/6. 事务.md)](/phper/data-base/my-sql/ji-chu-pian/6.-shi-wu-databasemysql-ji-chu-pian-6.-shi-wu-.md.md)
- [编码](/phper/data-base/my-sql/ji-chu-pian/bian-ma.md)
- [范式](/phper/data-base/my-sql/ji-chu-pian/fan-shi.md)
- [一条SQL查询语句是如何执行的？](/phper/data-base/my-sql/ji-chu-pian/yi-tiao-sql-cha-xun-yu-ju-shi-ru-he-zhi-hang-de.md)
- [实践篇](/phper/data-base/my-sql/shi-jian-pian.md)
- [\[1. 事务回滚\](DataBase/MySQL/实践篇/1. 事务回滚.md)](/phper/data-base/my-sql/shi-jian-pian/1.-shi-wu-hui-gun-databasemysql-shi-jian-pian-1.-shi-wu-hui-gun-.md.md)
- [\[2. 隐式转换\](DataBase/MySQL/实践篇/2. 隐式转换.md)](/phper/data-base/my-sql/shi-jian-pian/2.-yin-shi-zhuan-huan-databasemysql-shi-jian-pian-2.-yin-shi-zhuan-huan-.md.md)
- [\[3. 分库分表\](DataBase/MySQL/实践篇/3. 分库分表.md)](/phper/data-base/my-sql/shi-jian-pian/3.-fen-ku-fen-biao-databasemysql-shi-jian-pian-3.-fen-ku-fen-biao-.md.md)
- [事务和锁](/phper/data-base/my-sql/shi-wu-he-suo.md)
- [表锁&行锁](/phper/data-base/my-sql/shi-wu-he-suo/biao-suo-hang-suo.md)
- [乐观锁&悲观锁](/phper/data-base/my-sql/shi-wu-he-suo/le-guan-suo-bei-guan-suo.md)
- [事务](/phper/data-base/my-sql/shi-wu-he-suo/shi-wu.md)
- [数据库锁](/phper/data-base/my-sql/shi-wu-he-suo/shu-ju-ku-suo.md)
- [mysql死锁的条件及应对措施](/phper/data-base/my-sql/shi-wu-he-suo/mysql-si-suo-de-tiao-jian-ji-ying-dui-cuo-shi.md)
- [性能优化](/phper/data-base/my-sql/xing-neng-you-hua.md)
- [\[0. 性能优化\](DataBase/MySQL/性能优化/0. 性能优化.md)](/phper/data-base/my-sql/xing-neng-you-hua/0.-xing-neng-you-hua-databasemysql-xing-neng-you-hua-0.-xing-neng-you-hua-.md.md)
- [\[1. 执行优化\](DataBase/MySQL/性能优化/1. 执行优化.md)](/phper/data-base/my-sql/xing-neng-you-hua/1.-zhi-xing-you-hua-databasemysql-xing-neng-you-hua-1.-zhi-xing-you-hua-.md.md)
- [\[2. 架构优化\](DataBase/MySQL/性能优化/2. 架构优化.md)](/phper/data-base/my-sql/xing-neng-you-hua/2.-jia-gou-you-hua-databasemysql-xing-neng-you-hua-2.-jia-gou-you-hua-.md.md)
- [Note](/phper/data-base/my-sql/note.md)
- [如何进行分库分表](/phper/data-base/my-sql/note/ru-he-jin-hang-fen-ku-fen-biao.md)
- [如何选择主库和从库](/phper/data-base/my-sql/note/ru-he-xuan-ze-zhu-ku-he-cong-ku.md)
- [如何做数据恢复](/phper/data-base/my-sql/note/ru-he-zuo-shu-ju-hui-fu.md)
- [删除和添加索引，为什么要先加后删](/phper/data-base/my-sql/note/shan-chu-he-tian-jia-suo-yin-wei-shi-mo-yao-xian-jia-hou-shan.md)
- [什么是关系表](/phper/data-base/my-sql/note/shi-mo-shi-guan-xi-biao.md)
- [数据库单表由万级变成亿级，怎么处理](/phper/data-base/my-sql/note/shu-ju-ku-dan-biao-you-wan-ji-bian-cheng-yi-ji-zen-mo-chu-li.md)
- [索引失效的场景](/phper/data-base/my-sql/note/suo-yin-shi-xiao-de-chang-jing.md)
- [一条SQL查询语句是如何执行的](/phper/data-base/my-sql/note/yi-tiao-sql-cha-xun-yu-ju-shi-ru-he-zhi-hang-de.md)
- [count查询为什么会慢](/phper/data-base/my-sql/note/count-cha-xun-wei-shi-mo-hui-man.md)
- [\[MySQL 意外宕机，如何数据恢复\](DataBase/MySQL/Note/MySQL 意外宕机，如何数据恢复.md)](/phper/data-base/my-sql/note/mysql-yi-wai-dang-ji-ru-he-shu-ju-hui-fu-databasemysqlnotemysql-yi-wai-dang-ji-ru-he-shu-ju-hui-fu-..md)
- [Mysql安装](/phper/data-base/my-sql/note/mysql-an-zhuang.md)
- [mysql查询语句怎么做性能分析？](/phper/data-base/my-sql/note/mysql-cha-xun-yu-ju-zen-mo-zuo-xing-neng-fen-xi.md)
- [mysql批量删除表名符合条件的表](/phper/data-base/my-sql/note/mysql-pi-liang-shan-chu-biao-ming-fu-he-tiao-jian-de-biao.md)
- [MySQL数据库规范](/phper/data-base/my-sql/note/mysql-shu-ju-ku-gui-fan.md)
- [Pt Online Schema Change](/phper/data-base/my-sql/note/pt-online-schema-change.md)
- [SQL慢查优化方案](/phper/data-base/my-sql/note/sql-man-cha-you-hua-fang-an.md)
- [\[Warning PDO Statementexecute SQLSTATE HY 093 Invalid Parameter Number Number Of Bound Variables Doe](/phper/data-base/my-sql/note/warning-pdo-statementexecute-sqlstate-hy-093-invalid-parameter-number-number-of-bound-variables-doe.md)
- [\[x1. 常见问题\](DataBase/MySQL/x1. 常见问题.md)](/phper/data-base/my-sql/x1.-chang-jian-wen-ti-databasemysqlx1.-chang-jian-wen-ti-.md.md)
- [\[x2 参考资料\](DataBase/MySQL/x2 参考资料.md)](/phper/data-base/my-sql/x2-can-kao-zi-liao-databasemysqlx2-can-kao-zi-liao-.md.md)
- [\[x3 资料推荐\](DataBase/MySQL/x3 资料推荐.md)](/phper/data-base/my-sql/x3-zi-liao-tui-jian-databasemysqlx3-zi-liao-tui-jian-.md.md)
- [Redis](/phper/data-base/redis.md)
- [多线程](/phper/data-base/redis/duo-xian-cheng.md)
- [KeyDB实现](/phper/data-base/redis/duo-xian-cheng/keydb-shi-xian.md)
- [\[Redis 多线程\](DataBase/Redis/多线程/Redis 多线程.md)](/phper/data-base/redis/duo-xian-cheng/redis-duo-xian-cheng-databaseredis-duo-xian-cheng-redis-duo-xian-cheng-.md.md)
- [分布式](/phper/data-base/redis/fen-bu-shi.md)
- [集群](/phper/data-base/redis/fen-bu-shi/ji-qun.md)
- [清理集群](/phper/data-base/redis/fen-bu-shi/qing-li-ji-qun.md)
- [哨兵机制](/phper/data-base/redis/fen-bu-shi/shao-bing-ji-zhi.md)
- [主从复制](/phper/data-base/redis/fen-bu-shi/zhu-cong-fu-zhi.md)
- [Redis分布式锁](/phper/data-base/redis/fen-bu-shi/redis-fen-bu-shi-suo.md)
- [基础知识](/phper/data-base/redis/ji-chu-zhi-shi.md)
- [\[1. 简介\](DataBase/Redis/基础知识/1. 简介.md)](/phper/data-base/redis/ji-chu-zhi-shi/1.-jian-jie-databaseredis-ji-chu-zhi-shi-1.-jian-jie-.md.md)
- [\[2. 数据结构\](DataBase/Redis/基础知识/2. 数据结构.md)](/phper/data-base/redis/ji-chu-zhi-shi/2.-shu-ju-jie-gou-databaseredis-ji-chu-zhi-shi-2.-shu-ju-jie-gou-.md.md)
- [配置说明](/phper/data-base/redis/ji-chu-zhi-shi/pei-zhi-shuo-ming.md)
- [问题画像](/phper/data-base/redis/ji-chu-zhi-shi/wen-ti-hua-xiang.md)
- [知识图](/phper/data-base/redis/ji-chu-zhi-shi/zhi-shi-tu.md)
- [进阶](/phper/data-base/redis/jin-jie.md)
- [管道](/phper/data-base/redis/jin-jie/guan-dao.md)
- [消息队列](/phper/data-base/redis/jin-jie/xiao-xi-dui-lie.md)
- [性能调优](/phper/data-base/redis/jin-jie/xing-neng-tiao-you.md)
- [性能分析](/phper/data-base/redis/jin-jie/xing-neng-fen-xi.md)
- [优化建议](/phper/data-base/redis/jin-jie/you-hua-jian-yi.md)
- [redis升级](/phper/data-base/redis/jin-jie/redis-sheng-ji.md)
- [使用场景](/phper/data-base/redis/shi-yong-chang-jing.md)
- [数据类型适用场景](/phper/data-base/redis/shi-yong-chang-jing/shu-ju-lei-xing-shi-yong-chang-jing.md)
- [Redis的问题](/phper/data-base/redis/shi-yong-chang-jing/redis-de-wen-ti.md)
- [数据结构](/phper/data-base/redis/shu-ju-jie-gou.md)
- [底层的数据结构](/phper/data-base/redis/shu-ju-jie-gou/di-ceng-de-shu-ju-jie-gou.md)
- [复杂度](/phper/data-base/redis/shu-ju-jie-gou/fu-za-du.md)
- [键值](/phper/data-base/redis/shu-ju-jie-gou/jian-zhi.md)
- [内存分配](/phper/data-base/redis/shu-ju-jie-gou/nei-cun-fen-pei.md)
- [Notes](/phper/data-base/redis/notes.md)
- [缓存特征、介质](/phper/data-base/redis/notes/huan-cun-te-zheng-jie-zhi.md)
- [如果有大量的key需要设置同一时间过期，一般需要注意什么？](/phper/data-base/redis/notes/ru-guo-you-da-liang-de-key-xu-yao-she-zhi-tong-yi-shi-jian-guo-qi-yi-ban-xu-yao-zhu-yi-shen-me.md)
- [如何查找key](/phper/data-base/redis/notes/ru-he-cha-zhao-key.md)
- [如何应对缓存穿透和缓存雪崩问题？](/phper/data-base/redis/notes/ru-he-ying-dui-huan-cun-chuan-tou-he-huan-cun-xue-beng-wen-ti.md)
- [如何找到最大值对应的key](/phper/data-base/redis/notes/ru-he-zhao-dao-zui-da-zhi-dui-ying-de-key.md)
- [为什么要使用Nosql](/phper/data-base/redis/notes/wei-shen-me-yao-shi-yong-nosql.md)
- [\[为什么Redis 是单线程却能支撑高并发\](DataBase/Redis/Notes/为什么Redis 是单线程却能支撑高并发.md)](/phper/data-base/redis/notes/wei-shen-me-redis-shi-dan-xian-cheng-que-neng-zhi-cheng-gao-bing-fa-databaseredisnotes-wei-shen-me-r.md)
- [应用场景](/phper/data-base/redis/notes/ying-yong-chang-jing.md)
- [\[Redis 字典遍历\](DataBase/Redis/Notes/Redis 字典遍历.md)](/phper/data-base/redis/notes/redis-zi-dian-bian-li-databaseredisnotesredis-zi-dian-bian-li-.md.md)
- [\[Redis Cluster请求路由原理\](DataBase/Redis/Notes/Redis Cluster请求路由原理.md)](/phper/data-base/redis/notes/redis-cluster-qing-qiu-lu-you-yuan-li-databaseredisnotesredis-cluster-qing-qiu-lu-you-yuan-li-.md.md)
- [Redis的监控](/phper/data-base/redis/notes/redis-de-jian-kong.md)
- [Redis的同步机制](/phper/data-base/redis/notes/redis-de-tong-bu-ji-zhi.md)
- [redis的hash怎么实现的？](/phper/data-base/redis/notes/redis-de-hash-zen-me-shi-xian-de.md)
- [redis过期策略和缓存置换策略](/phper/data-base/redis/notes/redis-guo-qi-ce-le-he-huan-cun-zhi-huan-ce-le.md)
- [\[Redis缓存数据类型的选择 \](DataBase/Redis/Notes/Redis缓存数据类型的选择 .md)](/phper/data-base/redis/notes/redis-huan-cun-shu-ju-lei-xing-de-xuan-ze-databaseredisnotesredis-huan-cun-shu-ju-lei-xing-de-xuan-z.md)
- [Redis集群之间是如何复制？](/phper/data-base/redis/notes/redis-ji-qun-zhi-jian-shi-ru-he-fu-zhi.md)
- [Redis迁移](/phper/data-base/redis/notes/redis-qian-yi.md)
- [Redis如何做持久化的](/phper/data-base/redis/notes/redis-ru-he-zuo-chi-jiu-hua-de.md)
- [Redis写入大量数据后，为什么变慢了](/phper/data-base/redis/notes/redis-xie-ru-da-liang-shu-ju-hou-wei-shen-me-bian-man-le.md)
- [redis有哪些危险的命令？怎么避免](/phper/data-base/redis/notes/redis-you-na-xie-wei-xian-de-ming-ling-zen-me-bi-mian.md)
- [参考资料](/phper/data-base/redis/can-kao-zi-liao.md)
