数据库
文章平均质量分 70
MySQL数据库相关知识总结与记录
Kensin_
中科院信工所在读,想变强的计算机渣硕一枚
展开
-
博客内容仅代表自己观点——博客纠错
最近在学习MySQL,在网上看到一篇博客:mysql 联合索引 复合索引(abc)如何索引命中规则实测但是博客中的一个点引起了我的注意:嗯哼?明明对a,b,c三列做了联合索引,在对a进行范围查找的时候肯定会使用索引啊。根据最左匹配原则,对a查询肯定会用到a的索引;B+树的叶子节点是双向指针链接起来的,范围查找很适合啊!为啥不用索引?我迷惑了,既然人家实战了,咱也来实际测试一下。建表与索引语句如下:CREATE TABLE `test_copy1` ( `id` int(255) NOT原创 2021-06-09 14:02:22 · 276 阅读 · 0 评论 -
mongodb4.2及以后的版本将移除eval命令
Eval has left the buildingThe eval command itself was deprecated way back at MongoDB 3.0. What’s changed in MongoDB 4.2 is that the Mongo shell now will only accept the db.eval command when working with a 4.0 or earlier server. The eval command went becau原创 2020-07-27 10:45:34 · 1090 阅读 · 0 评论 -
MySql8.0详细安装记录 文件下载
第一步当然是先下载安装包啦!(下载地址审核通过后展示)解压缩文件mysql-8.0.15-winx64将 my.ini 文件放入解压后的目录下修改mysql路径将bin路径配置到环境变量当中D:\Program\mysql\mysql-8.0.15-winx64\bin管理员权限cmd 进入到bin目录下运行,初始化mysqla. mysqld --initialize --console 且记录下临时密码b. mysqld installc. net star..原创 2020-10-20 20:42:06 · 104 阅读 · 0 评论 -
Redo Log & Bin Log
Redo LogThe redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level AP原创 2021-04-23 11:02:12 · 85 阅读 · 0 评论 -
MySQL配置主从复制
参考自:《高性能MySQL》主备的最新叫法:primary and replica基本场景:对于新安装的主库和备库1.创建复制账号grant replication slave, replication client on *.* to '229_slave'@'10.10.3.229' identified by 'password';replication slave 复制权限replication client 监控和管理复制的账号 的权限两个权限都赋予上,方便后续互为主备的配置。原创 2021-04-21 21:26:26 · 75 阅读 · 0 评论