Cluster.setInstanceOption()’host1:3377’,’MenmberWeight’,40) 

Cluster.setInstanceOption()’host1:3377’,’MenmberWeight’,30) 

Cluster.setInstanceOption()’host1:3377’,’MenmberWeight’,40) 

Cluster.setInstanceOption()’host1:3377’,’exitStateAction’,”ABORT_SERVER”) 

Now examine the partial staus: 

“topology”;{ ”host1:3377”: 

“address”:”

host1:3377”, 

“mode”:”R/O”, 

[...]

 “statue”:”

ONLINE”, 

“version”:”

8.0.18” }, 

“host2:3377”:{ “address”:”

host2:3377”, 

“mode”:”R/O”,

 [...]

 “statue”:”

ONLINE”,

 “version”:”

8.0.18” }, 

“host3:3377”:{ 

“address”:”

host3:3377”, 

“mode”:”

R/O”, 

[...] 

“statue”:”

ONLINE”, “

version”:”

8.0.18” 

} 

}

 A permanent network failure isolates host3.(永久性网络故障隔离主机3)

 Which two statements are true? 

where the bin directory is found at 1 app/mysql/bin and the data directory at /app/data （其中 bin 目录位于 1 app/mysql/bin，数据目录位于 /app/data）

Which two parameters are required to configure the MySQL instance?（配置 MySQL 实例需要哪两个参数）

Why does the file contain no visible statement events? （为什么文件不包含可见的语句事件）

 TRUNCATE test;

 BEGIN; 

INSERT INTO test(id, name) VALUES(1, HELLO ); 

ROLLBACK; 

SELECT id FROM test; 

Which three storage engines would return a nonempty recordset for the test table when executing the statements?（执行语句时，哪三个存储引擎将返回测试表的非空记录集）

 root@dbhost: /var/lib/mysql# ls -al 

total 540 

drwxrwxr-x 1 mysql mysql 4096 Aug 22 14:07 

drwxr-xr-x 1 root root 4096 May 22 00:42 

-rw-r- - ---- 1 mysql mysql 56 Aug 20 13:58 auto. cnf 

drwxr-xr-x 1 mysql mysql 4096 Aug 21 10:28 accounting 

-rw-r--r-- 1 mysql mysql 1112 Aug 20 13:58 ca. Pem 

-rw-r----- 1 mysql mysql 172040 Aug 22 14:07 ib_ buffer_ pool 

-rw-r----- 1 mysql mysql 12582919 Aug 22 14:07 ibdata1 

-rw-r----- 1 mysql mysql 50331648 Aug 22 14:07 ib_ logfile0 

-rw-r----- 1 mysql mysql 50331648 Aug 20 13:47 ib_ logfile1 

-rw-r----- 1 mysql mysql 292292 Aug 22 14:07 ibtmp1 

drwxr-x--- 1 mysql users 4096 Aug 20 13:59 mysql 

-rw-r----- 1 mysql mysql 64064 Aug 22 15:18 mysql -error .log d

rwxr-x--- 1 mysql mysql 4096 Aug 20 13:59 performance_ schema 

-rw-rw---- 1 mysql mysql 1680 Aug 20 13:59 private_ key.pem 

-rw-r--r-- 1 mysql mysql 452 Aug 20 13:59 public_ key.pem 

-rw-r--r-- 1 mysql mysql 1112 Aug 20 13:58 server -cert.pem 

-rw------- 1 mysql mysql 1680 Aug 20 13:58 server- key.pem 

drwxr-x--- 1 mysql mysql 4096 Aug 20 13:59 sys 

Which two options will improve the security of the MySQL instance? (Choose two.) 

no backup or replication will be required.

It is currently under performing 

The database size is static and including indexes is 19G 

Total system memory is 32G After profiling the system,you highlight these MySQL status and global variables: 

Com_rollback |85408355 | 

Com_commit |1234342 | 

Innodb_buffer_pool_pages_free |163840 | 

[mysqld] 

Buffer_pool_size=20G 

Innodb_flush_log_at_trx_commit=2

 Disable-log-bin

 The OS metrics indicate that disk is a bottleneck 

Other variables retain their default values 

Which two changes will provide the most benefit to the instance? 

 mysql\> DROP ROLE r_role1, r_role2;

 Which two are true? 

Which two are true? 

mysqlpump --user=root --password \> full_ backup.sql 

Which two databases will be excluded from this dump? （将从此转储中排除哪两个数据库）