数据库管理与优化-优快云博客

本文链接：https://blog.youkuaiyun.com/Amen_Wu/article/details/79522954

安装和使用

安装oracle出现环境不满足最低要求
https://www.cnblogs.com/qncl/p/8538695.html
PLSQL注册码，亲测，可用
https://blog.youkuaiyun.com/ma141982/article/details/76154919
oracle默认账号和密码及账号解锁方法
https://blog.youkuaiyun.com/jj0741209/article/details/25122085
Oracle11默认用户名和密码
https://www.cnblogs.com/zhangwuji/p/7411641.html
Oracle创建表空间和表
https://www.cnblogs.com/qmfsun/p/3817344.html
plsql连接远程数据库
https://blog.youkuaiyun.com/a2226701325/article/details/56306621

数据库：## 标题 ##

数据库常见面试题汇总（50）
https://blog.youkuaiyun.com/weinierzui/article/details/71054964
数据库4大特性
http://blog.youkuaiyun.com/wolenski/article/details/7980521
事务传播机制
http://blog.sina.com.cn/s/blog_6689cae30101cpa1.html
数据库5大约束
https://www.2cto.com/database/201304/199872.html
mysql流程控制等语句
http://blog.youkuaiyun.com/baoliangsheng/article/details/46459471
JOIN IN与IN的区别
http://blog.youkuaiyun.com/qq_33290787/article/details/51931261
Constraints
http://blog.youkuaiyun.com/lengyue_wy/article/details/6712258
mysql乐观锁、悲观锁及隔离级别
http://blog.youkuaiyun.com/zztfj/article/details/6319740
http://blog.youkuaiyun.com/liyantianmin/article/details/50752102
http://blog.youkuaiyun.com/fg2006/article/details/6937413
mysql悲观锁
http://chenzhou123520.iteye.com/blog/1860954
mysql乐观锁
http://chenzhou123520.iteye.com/blog/1863407
mybatis乐观锁实现，解决并发问题
https://www.cnblogs.com/linjiqin/p/5096206.html
SQL语句、Mysql、Navicat编码不一致问题
http://blog.youkuaiyun.com/fenfei12138/article/details/49661879
复合主键与联合主键
http://blog.youkuaiyun.com/amen_wu/article/details/79376605
主键索引和唯一索引的区别
https://www.cnblogs.com/-619569179/p/6528896.html
MySQL的lock tables和unlock tables的用法（转载）
http://blog.youkuaiyun.com/amen_wu/article/details/79478529
解决mysql执行SQL文件，报错：”Got a packet bigger than ‘max_allowed_packet’ bytes“
https://blog.youkuaiyun.com/github_39325328/article/details/79549756

SQL语句

mysql update和case语句结合
https://blog.youkuaiyun.com/qq_25067905/article/details/54948625
mysql中You can’t specify target table for update in FROM clause错误
https://blog.youkuaiyun.com/priestmoon/article/details/8016121
mysql中where+if判断
https://blog.youkuaiyun.com/zqtsx/article/details/9786453
MySQL多表连接查询
https://www.cnblogs.com/geaozhang/p/6753190.html
mysql 的 case when then 用法和null 的判断
https://www.cnblogs.com/blogxiao/p/7600964.html
MySQL最常用分组聚合函数
https://www.cnblogs.com/geaozhang/p/6745147.html

表结构优化：

SQL语句优化（语法+处理逻辑）
http://database.51cto.com/art/200904/118526.htm
http://blog.youkuaiyun.com/love_xsq/article/details/42417917
http://www.cnblogs.com/shiluoliming/p/6604407.html

分片（分区分表）：

数据库分库分表策略的具体实现方案
http://blog.youkuaiyun.com/xlgen157387/article/details/53976153
MyBatis实现Mysql数据库分库分表操作和总结（推荐）
http://www.jb51.net/article/121743.htm?utm_source=debugrun&utm_medium=referral
MySQL分库分表总结
http://blog.youkuaiyun.com/hanghangaidoudou/article/details/69569625
Mysql分库分表方案
https://www.cnblogs.com/try-better-tomorrow/p/4987620.html
mysql分表的3种方法
https://www.cnblogs.com/lucky-man/p/6207873.html
MySQL 高可用：mysql+mycat实现数据库分片（分库分表）
http://blog.youkuaiyun.com/kk185800961/article/details/51147029
mysql分库分表的常见策略
https://www.2cto.com/database/201708/668574.html
透明的分库分表方案
https://my.oschina.net/tinyframework/blog/531444
Mysql分表和分区的区别、分库分表介绍与区别
https://www.cnblogs.com/langtianya/p/4997768.html
mysql 分库分表
http://songfeng-123.iteye.com/blog/2369504
数据库（分库分表）中间件对比
https://www.cnblogs.com/wangzhongqiu/p/7100332.html
MyCat是什么？为什么要用MyCat？
http://blog.youkuaiyun.com/nxw_tsp/article/details/56277430
数据库学习：高并发数据库设计
https://blog.youkuaiyun.com/chenpeng19910926/article/details/51789934

索引优化：

主键、约束和索引
https://www.cnblogs.com/Uest/p/5230130.html
什么是数据库索引有哪些类型和特点
https://www.jb51.net/article/73255.htm
漫谈数据库索引
https://kb.cnblogs.com/page/45712/
mysql联合索引
https://www.cnblogs.com/softidea/p/5977860.html
复合索引如何用？创建、使用、排序优化
https://blog.youkuaiyun.com/bigtree_3721/article/details/51255401
CREATE INDEX 语句
https://blog.youkuaiyun.com/zhanglei5415/article/details/2407681
聚合索引(clustered index) / 非聚合索引(nonclustered index)
https://blog.youkuaiyun.com/ak913/article/details/8026743
sql-索引的作用(超详细)
https://www.cnblogs.com/hyd1213126/p/5828937.html
mysql-覆盖索引
https://www.cnblogs.com/happyflyingpig/p/7662881.html