目录
数据库
......................................................................................................................................................................................
4
1.事务四大特性(ACID)原子性、一致性、隔离性、持久性?
..............................................................................
4
1.1.原子性(Atomicity)
........................................................................................................................................
4
1.2.一致性(Consistency)
....................................................................................................................................
4
1.3.
隔离性(
Isolation
)
.........................................................................................................................................
4
1.4.持久性(Durability)
.......................................................................................................................................
4
2.
事务的并发?事务隔离级别,每个级别会引发什么问题,
MySQL
默认是哪个级别?
.....................................
4
2.1 事务的并发问题
...............................................................................................................................................
4
2.2
事务的隔离级别
...............................................................................................................................................
5
2.3 补充
...................................................................................................................................................................
5
3.MySQL 常见的三种存储引擎(InnoDB、MyISAM、MEMORY)的区别?
............................................................
6
3.1.MySQL 存储引擎 MyISAM 与 InnoDB 如何选择
............................................................................................
6
3.2.
关于
MySQL
数据库提供的两种存储引擎,
MyISAM
与
InnoDB
选择使用:
............................................
6
3.3.MEMORY
存储引擎
...........................................................................................................................................
7
4.MySQL
的
MyISAM
与
InnoDB
两种存储引擎在,事务、锁级别,各自的适用场景?
.......................................
7
3.4.事务处理上方面
...............................................................................................................................................
7
3.5.锁级别
...............................................................................................................................................................
7
5.查询语句不同元素(where、jion、limit、group by、having 等等)执行先后顺序?
.......................................
8
6.什么是临时表,临时表什么时候删除?
..................................................................................................................
8
7.MySQL B+Tree
索引和
Hash
索引的区别?
...............................................................................................................
9
7.1.Hash 索引
..........................................................................................................................................................
9
7.2.B+Tree
索引
.......................................................................................................................................................
9
7.3.B+树索引和哈希索引的明显区别是:
...........................................................................................................
9
8.sql
查询语句确定创建哪种类型的索引,如何优化查询
......................................................................................
10
9.聚集索引和非聚集索引区别?
................................................................................................................................
10
10.
有哪些锁(乐观锁悲观锁),
select
时怎么加排它锁?
..................................................................................
11
10.1 悲观锁(Pessimistic Lock)
.........................................................................................................................
11
10.2
乐观锁(
Optimistic Lock
)
..........................................................................................................................
11
10.3 总结
...............................................................................................................................................................
12
Redis
缓存
..............................................................................................................................................................................
12
1.为什么要用 redis /为什么要用缓存
.......................................................................................................................
12
1.1.
高性能
.............................................................................................................................................................
12
1.2.高并发
.............................................................................................................................................................
14
2.redis 和 memcached 的区别
..................................................................................................................................
15
3.redis 常见数据结构以及使用场景分析
..................................................................................................................
16
3.1. String
...............................................................................................................................................................
16
3.2.Hash
.................................................................................................................................................................
16
3.3.List
....................................................................................................................................................................
16
3.4.Set
....................................................................................................................................................................
17
3.5.Sorted Set
........................................................................................................................................................
17
4.redis
设置过期时间
..................................................................................................................................................
17
5.redis 内存淘汰机制(MySQL 里有 2000w 数据,Redis 中只存
..........................................................................
18
20w 的数据,如何保证 Redis 中的数据都是热点数据?)
....................................................................................
18
6.redis 持久化机制(怎么保证 redis 挂掉之后再重启数据可以进行恢复)
.....................................................
18
7.redis 事务
..................................................................................................................................................................
19
8.Redis
常见异常及解决方案
.....................................................................................................................................
20
8.1
缓存穿透
........................................................................................................................................................
20
8.2
缓存雪崩
........................................................................................................................................................
21
8.3 缓存预热
........................................................................................................................................................
21
8.4 缓存降级
........................................................................................................................................................
22
9.分布式环境下常见的应用场景
................................................................................................................................
23
9.1
分布式锁
........................................................................................................................................................
23
9.2 分布式自增 ID
...............................................................................................................................................
25
10.Redis
集群模式
.......................................................................................................................................................
26
10.1 主从模式
......................................................................................................................................................
26
10.2
哨兵模式
......................................................................................................................................................
27