MYSQL
文章平均质量分 52
engchina
Get your hands dirty
展开
-
MySQL8 设置半同步复制
默认情况下,复制是异步的。主库不知道写入操作是否已经到达从库。如果主库和从库之间存在延迟,并且主库崩溃,尚未到达从库的那些数据就会丢失。为了解决这种问题,你可以使用半同步复制。在半同步复制中,主库会一直等待,知道至少有一个从库接收到写入的数据。默认情况下,rpl_semi_sync_master_wait_point的值是AFTER_SYNC,这意味着主库将事务同步到二进制日志,再由从库读取使用。之后,从库向主库发送确认消息,然后主库提交事务并将结果返回给客户端。所以,写入操作能到达中继日志就主够了,从原创 2021-06-16 13:22:01 · 472 阅读 · 0 评论 -
MySQL8 搭建主主复制
MySQL8 搭建主主复制step1,事前准备,创建2个docker网络docker network create mypubnet --subnet=10.10.0.0/16docker network create myprvnet --subnet=10.20.0.0/16step2,启动2个MySQL容器docker run --name mysql101 --net mypubnet --add-host host101:10.10.0.101 --add-host host102:1原创 2021-06-16 10:18:27 · 248 阅读 · 0 评论 -
MySQL8 搭建主从复制
MySQL8 搭建主从复制step1,事前准备,创建2个docker网络docker network create mypubnet --subnet=10.10.0.0/16docker network create myprvnet --subnet=10.20.0.0/16step2,启动2个MySQL容器docker run --name mysql101 --net mypubnet --add-host host101:10.10.0.101 --add-host host102:1原创 2021-06-16 10:03:33 · 278 阅读 · 0 评论 -
MySQL8 tmp_table_size和max_heap_table_size
tmp_table_size规定了内部内存临时表的最大值,每个线程都要分配。(实际起限制作用的是tmp_table_size和max_heap_table_size的最小值)如果内存临时表超出了限制,MySQL就会自动地把它转化为基于磁盘的MyISAM表,存储在指定的tmpdir目录下,默认mysql> SHOW VARIABLES LIKE 'tmpdir';+---------------+-------+| Variable_name | Value |+--------------原创 2021-06-16 09:42:26 · 1032 阅读 · 0 评论 -
MySQL8 Status Variables: Internal Temporary Tables and Files
These status variables show you how many times MySQL has created internal temporary tables and files. These are expensive operations and can help you diagnose poorly performing queries. They include:Create_tmp_disk_tables:If an internal temporary table原创 2021-06-15 18:25:48 · 150 阅读 · 0 评论 -
MySQL8 基于clone创建主从复制
MySQL8 基于clone创建主从复制step1,事前准备,创建2个docker网络docker network create mypubnet --subnet=10.10.0.0/16docker network create myprvnet --subnet=10.20.0.0/16step2,启动2个MySQL容器docker run --name mysql101 --net mypubnet --add-host host101:10.10.0.101 --add-host ho原创 2021-06-14 15:47:02 · 255 阅读 · 0 评论 -
MySQL性能测试工具sysbench学习
SysBench Benchmark ToolSysbench is a popular open source benchmark to test open source DBMSs.Step1. 下载https://dev.mysql.com/downloads/benchmarks.html=》Download SysBench Benchmark ToolStep2. 安装原创 2021-06-13 11:12:46 · 192 阅读 · 0 评论 -
MySQL8 Encrypting InnoDB Tablespaces
Encrypting InnoDB TablespacesThe following InnoDB tablespaces can be encrypted:File-per-table tablespace:Add the ENCRYPTION = ‘Y’ option to the CREATE TABLE or ALTER TABLE statementALTER TABLE t1 ENCRYPTION = 'Y';General tablespace:Add the EN原创 2021-06-09 09:36:15 · 196 阅读 · 0 评论 -
MySQL8 1Z0-908学习(15)
问题(答案在文章最后):Which four are types of information stored in the MySQL data dictionary? (Choose four.)A performance metricsB table definitionsC access control listsD view definitionsE server runtime configurationF server configuration rollbackG stored原创 2021-06-05 12:57:46 · 98 阅读 · 0 评论 -
MySQL8 1Z0-908学习(7)
问题(答案在文章最后):You encountered an insufficient privilege error in the middle of a long transaction.The database administrator is informed and immediately grants the required privilege:GRANT UPDATE ON world.city TO ‘user1’;How can you proceed with your tra原创 2021-06-03 13:26:38 · 67 阅读 · 0 评论 -
MySQL8 1Z0-908学习(6)
问题(答案在文章最后):Examine this command, which executes successfully:$ mysqlrouter --bootstrap user@hostname:port --directory=directory_pathWhich activity is performed?A MySQL Router is configured based on the information in files in directory_path.B MySQL R原创 2021-06-03 13:22:37 · 102 阅读 · 0 评论 -
MySQL8 1Z0-908学习(5)
问题(答案在文章最后):Examine these entries from the general query log:Time Id Command Argument2019-12-17T00:36:23.389450Z 24 Connect root@localhost on mydb using SSL/TLS2019-12-17T00:36:23.389754Z 24 Query select @@version comment limit 12019-12-17T00:36:23.92原创 2021-06-03 12:55:45 · 81 阅读 · 0 评论 -
MySQL8 1Z0-908学习(4)
问题(答案在文章最后):Which two queries are examples of successful SQL injection attacks? (Choose two.)A SELECT user,passwd FROM membersWHERE user = ‘?’;INSERT INTO members(‘user’,‘passwd’) VALUES (‘bob@example.com’,‘secret’);–’;B SELECT id, name FROM user WHERE原创 2021-06-03 12:42:26 · 114 阅读 · 0 评论 -
MySQL8 1Z0-908学习(3)
问题(答案在文章最后):You wish to protect your MySQL database against SQL injection attacks.Which method would fail to do this?A installing and configuring the Connection Control pluginB avoiding concatenation of SQL statements and user-supplied values in an app原创 2021-06-03 10:50:07 · 61 阅读 · 0 评论 -
MySQL8 1Z0-908学习(2)
问题(答案在文章最后):Consider this shell output and executed commands:[root@oel7 ~]# ps aux | grep mysqldMysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid [root@oel7 ~]# kill -15 2076Which statement is true about MySQL server shutdown?A kill原创 2021-06-03 10:23:25 · 60 阅读 · 0 评论 -
MySQL8 1Z0-908学习(1)
问题:You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.Which value of --ssl-mode will do this?A PREFERREDB VERIFY_CAC REQUIREDD VERIFY_IDENTITY答案:D解析:VERIFY_原创 2021-06-03 09:22:28 · 110 阅读 · 0 评论 -
MySQL 8 安装mysql_no_login插件
输入以下命令安装mysql_no_login插件。INSTALL PLUGIN mysql_no_login SONAME 'mysql_no_login.dll';输入以下命令停止某用户登录。ALTER USER username@hostname IDENTIFIED WITH mysql_no_login;原创 2021-04-05 14:40:39 · 575 阅读 · 0 评论 -
CentOS7 64位下MySQL5.7安装与配置(YUM)
原文地址:http://www.linuxidc.com/Linux/2016-09/135288.htm1、配置YUM源在MySQL官网中下载YUM源rpm安装包:http://dev.mysql.com/downloads/repo/yum/# 下载mysql源安装包wget http://dev.mysql.com/get/mysql57-co转载 2017-12-03 17:16:09 · 473 阅读 · 0 评论