赞
踩
1、官网
https://dev.mysql.com/downloads/mysql/
https://mariadb.com/kb/en/show
2、MySQL 思维导图
https://www.processon.com/view/657c0e3493c7aa0ae98d2755
https://www.processon.com/view/65a1f3351a610d40bb93c553
https://www.processon.com/view/5e5b3132e4b02bc3ad6a151e
https://www.processon.com/view/60af54f21e08531e9c899e74
https://www.processon.com/view/6177e7fb5653bb7318d6d2ed
https://www.processon.com/view/5e5b4e53e4b0cb56dab137cd
https://www.processon.com/view/606496567d9c0829db64d17d
https://www.processon.com/view/6101034af346fb1b4f672f23
https://www.processon.com/view/628505e60e3e7407e508f00d
https://www.processon.com/view/607d245de0b34d166649fdef
3.1、InnoDB Architecture
https://dev.mysql.com/doc/refman/5.7/en/innodb-architecture.html
https://blog.csdn.net/qq_42267081/article/details/112383883
3.2、InnoDB redo 事务工作原理
https://www.processon.com/view/link/62d0e5720e3e74607271856f
4、MySQL不同log
(1)slow query log
(2)general query log
(3)error log
(4)redolog
(5)undolog
(6)binlog
(7)relaylog
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
https://mariadb.com/kb/en/binary-log/
https://mariadb.com/kb/en/relay-log/
https://www.xiaolincoding.com/mysql/log/how_update.html
https://blog.csdn.net/qq_17612199/article/details/80284080
MySQL ACID 实现原理
https://blog.csdn.net/JMW1407/article/details/107849922
5、goInception
https://hanchuanchuan.github.io/goInception/
https://github.com/hanchuanchuan/goInception
6、MySQL优化
https://blog.csdn.net/wechat_fee1024/article/details/124413415
尚硅谷 宋红康 MySQL
E:\BaiduNetdiskDownload\0 数据库资料\尚硅谷MySQL入门到高级-宋红康版
E:\BaiduNetdiskDownload\0 数据库资料\尚硅谷MySQL入门到高级-宋红康版\learn_db-master\mysql\learn_mysql_ksf
E:\BaiduNetdiskDownload\0 数据库资料\尚硅谷MySQL入门到高级-宋红康版\高级篇\参考课件(供实操参考)
https://www.youtube.com/playlist?list=PLmOn9nNkQxJFi4x7rZ5wpUKts3u7cDx21
https://www.bilibili.com/video/BV1iq4y1u7vj
http://www.atguigu.com/download_detail.shtml?v=349
《MySQL小白到大神技术图谱_尚硅谷-宋红康》
https://www.youtube.com/watch?v=9DAU8vfUsH4&list=PLmOn9nNkQxJFi4x7rZ5wpUKts3u7cDx21&index=1
《MySQL高级特性篇技术图谱_尚硅谷-宋红康.png》
https://github.com/lliuql/learn_db/tree/master/mysql/learn_mysql_ksf
基础
https://www.youtube.com/watch?v=1URJ-TRp6Ok&list=PLmOn9nNkQxJFi4x7rZ5wpUKts3u7cDx21&index=95
高级
https://www.youtube.com/watch?v=yEAk0YzQ4Ns&list=PLmOn9nNkQxJFi4x7rZ5wpUKts3u7cDx21&index=199
https://www.youtube.com/watch?v=GDM_iMloq4Q&list=PLmOn9nNkQxJFi4x7rZ5wpUKts3u7cDx21&index=102
SHOW ENGINES;
SHOW PRIVILEGES;
SHOW INDEX FROM sale_db.t_order_delivery_address\G;
新增字段
ALTER TABLE t_rocketmq_broker_machine_info
ADD COLUMN `Fis_nameserver` varchar(8) DEFAULT "否" comment '是否混合部署了 NameServer' AFTER `Fserver_host`;
新增索引
ALTER TABLE ${TABLE_NAME} ADD INDEX ${INDEX_NAME}(${FIELD_NAME_1}, ${FIELD_NAME_N});
例如:
ALTER TABLE oa_db.t_monitor_js ADD INDEX idx_fhost(Fhost, Fcreate_time);
https://www.cnblogs.com/javabg/p/9951852.html
https://blog.csdn.net/qq_38220334/article/details/104891684
https://blog.csdn.net/qq_25983579/article/details/124385829
MHA
MGR
PXC(Percona)
主从
Orchestrator
https://github.blog/2018-06-20-mysql-high-availability-at-github
cd /usr/local/orchestrator nohup ./orchestrator --config=orchestrator.conf.json http >> orchestrator.log 2>&1 & tailf orchestrator.log 访问 http://10.XX.36.216:30000 实例管理命令 discover forget begin-maintenance end-maintenance in-maintenance begin-downtime end-downtime orchestrator --config=./orchestrator.conf.json -c discover -i host_name
https://github.com/openark/orchestrator
https://github.blog/2018-06-20-mysql-high-availability-at-github
https://www.percona.com/blog/orchestrator-mysql-replication-topology-manager/
https://blog.csdn.net/fruitless/article/details/130752646
https://blog.csdn.net/u014650965/article/details/129253059
https://blog.51cto.com/u_15474913/5399667
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html
姜承尧、李海翔、丁奇、杨建荣、雷海林、周彦伟、阿里多隆、何登成
恩墨学院、知数堂、极数云舟(ArkDB)
ArkDB
https://www.modb.pro/db/58722
tdsql
库表类型:除了单库单表类型,其他类型库表一律需要提前找DBA评审,单表不能建在2、3、4类型的库里面 1、 单库单表: 使用场景:预估单表数据量不会超过五千万数据量时使用 命名规范:如order_db.t_order 2、 百库十表: 使用场景:预估单表数据量会超过五千万且总数据量不会超过一百亿,数据不能集中在分库分表字段的部分值上 命名规范:如merch_#xx#_db.t_merch_order_#y# 说明:百库十表根据某字段如fmerch_id分库分表 #xx#(库位,两位数,不足两位在前面补零,00-99)= Fmerch_id倒数第二、三位,如:Fmerch_id= MC201503110074,#xx# = 07; #y#(表位,一位数,0-9)= Fmerch_id最后一位,如:Fmerch_id= MC201503110074,#y# = 4; 综上所述,如Fmerch_id= MC201503110074,则这条记录对应的库表名是:merch_07_db.t_merch_order_4 3、 多set百库十表: 使用场景:预估单表数据量会超过五千万且总数据量会超过一百亿,数据不能集中在分库分表字段的部分值上 命名规范:如user_account_#xx#_#yy#_db.t_user_account_#z# 说明:多set百库十表根据某字段如fuid分库分表 #xx#(set位,两位数,不足两位在前面补零,00-99)= Fuid/10000000 取两位数商,如:Fuid=23451235,#xx# = 02; #yy#(库位,两位数,不足两位在前面补零,00-99)= Fuid倒数第二、三位,如:Fuid=23451235,#yy# = 23; #z#(表位,一位数,0-9)= Fuid最后一位,如:Fuid=23451235,#z# = 5; 综上所述,如Fuid=23451235,则这条记录对应的库表名是:user_account_02_23_db.t_user_account_5 4、 年库天表: 使用场景:预估单表数据量会超过五千万数据量时、分库分表的字段必须包含年月日信息如forder_id,且数据特性为流水数据或一段时间不会更新的数据 命名规范如:order_#yyyy#_db.t_order_water_#mmdd# 说明:年库天表根据包含年月日字段如forder_id分库分表 #yyyy#(库位,四位数,年份)= forder_id顺数第二位到第五位,如:forder_id=O20151125307039900628,#yyyy#=2015; #mmdd#(表位,四位数,月日)= forder_id顺数第六位到第九位,如:forder_id=O20151125307039900628,#mmdd#=1125; 综上所述,如forder_id=O20151125307039900628,则这条记录对应的库表名是:order_2015_db.t_order_water_1125
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。