Mysql\>SELET FORMAT_BYTES(@@global.innodb_buffer_pool_size)AS BufferPoolSize,

 @@global.innodb_buffer_pool_instances AS NumInstances, 

FORMAT_BYTES(@@global.innodb_buffer_buffer_poof-chunk-size) AS Chunksize; 

+----------------------+--------------------+----------------+ 

|BufferPoolSize | NumInstances | ChunkSize |

 +----------------------+--------------------+----------------+

 |12。00 GiB | 8 | 128.00 MiB | 

+----------------------+--------------------+----------------+ 

Mysql\> SELECT * FROM sys.metrics WHERE Variable_name LIKE ‘Threads%’; 

+----------------------+--------------------+----------------+-------------+ 

|Variable_name |Variable_b=value |Type |Enabled | 

+----------------------+--------------------+----------------+-------------+ 

|Threads_cached | 4 |Global Status |YES | 

|Threads_cached | 32 |Global Status |YES |

 |Threads_cached | 112 |Global Status |YES | 

|Threads_cached | 16 |Global Status |YES | 

+----------------------+--------------------+----------------+-------------+ 

4 rows in set (0.00 sec) 

Which change should optimize the number of buffer pool instances for this workload? 

You want to add one or more indexes that minimize the work done by the query 

Which statement accomplishes this? 

mysqlsh\> dba。 createCluster('cluster1', {}memberWeight:35}) 

mysqlsh\> var mycluster = dba。getCluster () 

mysqlsh\> mycluster。addInstance(' ic@ic2', {memberWeight:25}） 

mysqlsh\> mycluster 。addInstance(' ic@ic3', {memberWeight:50}) 

Now examine this configuration setting, which is the same on all nodes: 

group_ replication_ consistency=BEFORE_ ON_ PRIMARY_ FAILOVER 

Which statement is true if primary node ic1 fails?

mysql\> GRANT PROXY ON accounting@localhost TO ' '@ '%'; 

mysql\> SELECT USER(), CURRENT_ USER(), @@proxy_ user; 

+------------------------+-------------------+-----------------+

 |USER() I CURRENT_ USER() I @@proxy_ user I | r smith@localhost 1 |accounting@localhost I ' '@'%' | 

+------------------------+-------------------+-----------------+ 

Which statement is true? 

You determine that all entries in the binary log file after position 1797 must be replayed；

Examine this partial command: 

mysqlbinlog binlog.000008 --start-position=1798 

Which operation will complete the command?

$mysqlbackup 

--user=dba 

--password 

--port=3306 

--with-timestamp 

--only-know-filetypes 

--backup-dir=/exprot/backups backup 

Which statement is true?

[mysqld] 

log_output=FILE

 slow_query_log long_query_time=2.01

 log_queries_not_using_indexes 

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes 

Which contains all the settings that you need to add to or modify the slow log configuration?

mysql\> show global status like 'Table_ lock%' ;

 +------------------------------+---------+ 

IVariable_name | Value l 

+------------------------------+---------+

 |Table_ locks_ immediate l 53148 | | Table_ locks_ waited |17716 | 

+------------------------------+---------+ 

2 rows in set (0.00 3ec) 

What is the most likely cause for the high number of lock waits? (锁定等待次数最多的最可能原因是什么)

You have a corporate private network, which uses its own Certificate Authority (CA) using an industry standard 2048-bit RSA key length (您有一个公司专用网络，该网络使用自己的证书颁发机构 （CA），使用行业标准的 2048 位 RSA 密钥长度)

All MySQL Server and client certificates are signed using the central corporate CA 

All clients are known, controlled,,and exist only on the private LAN 

The private network uses its own private authoritative DNS 

The private network also uses other nominal enterprise services 

An end-to-end encrypted connection for a MySQL client to MySQL server has been established on this LAN 

MySQL服务器的自签名证书与由已知的公共，第三方信任的证书颁发机构签名的证书相比如何? 

Examine this set of messages and responses: （尝试恢复 InnoDB 集群失败 检查这组消息和响应）

host3:3377 ss1 JS \> dba.rebootClusterFromCompleteOutage () 

Reconfiguring the defau1t cluster from comp1ete outage。 ·

 The instance 'host1 : 3377’was part of the cluster configuration

 Would you like to rejoin it to the cluster? [y/N] : y 

The instance 'host2:3377' was part of the cluster configuration 

Would you like to rejoin it to the cluster? [y/N] : 'Y 

Dba. rebootClusterEromCompleteOutage:

The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata 

Please use the most up to date instance: 'host1:3377'. (RuntimeError) 

Which statement is true? 

 What is the reason for the error? 

 # at 5000324 

#191120 14155116 server id 1 end_log_pos 500453 crc32 0x98159515 Query thread_id=9 

exec_time=2 error_code=0xid=1106 

SET TIMESTAMP=1574222116/*!*/; 

DROP TABLE ‘rental’/* generated by server*/ 

/*!*/; 

The rental table was accidentally dropped, and you must recover the table 

You have restored the last backup, which corresponds to the start of the binlog.000036 binary log. 

Which command will complete the recovery? 

Which command will do this? 

MySQL Server fails to start.

 Examine this snapshot of the error log: 

190925 12：49:05 InooDB; Initializing buffer pool,size=3.0G

 190925 12：49:05 InooDB; Completed Initializing of buffer poo 

InnoDB:Error:log file ./ib_logfiiel0 is of different size 0 5242880 bytes 

InnoDB than specified in the .cnf fiel 0 26214400 bytes 1 

190925 12:49:05 [ERROR] Plugin ‘InnoDB’ init function returned error 

190925 12:49:05 [ERROR] Plugin ‘InnoDB’registation as a STORAGE PNGINR failed 

190925 12:49:05 [ERROR] Plugin ‘Aborting 

190925 12:49:05 [ERROR] Plugin ‘/usr/sbin/mysqld:Shutdown complete 

Which action would allow the server to start?

$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path 

Which activity is performed?

 shell# mysqldump --master-data=2 --all-databases \> full_backup.Sql

 You want to make incremental backups every hour after the full backup 

Which loa file would be used for incremental backups?