mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup-dir=/export/backups backup-and-apply-log

Which statement is true?

The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Master:

Gtids_executed:

aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-321, bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50,

Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_purged:

Slave:

aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100, bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-10, cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_executed:

aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-160, cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_executed:

aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70, cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Which statement is true?

Mysql>SHOW GLOBAL VARIABLES

WHERE Varisble_name=’tmpdir ‘

OR Variable_name =’ tmp_table_size;

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

| Variable_name        |Value      

 | +------------------------+-----+

 Temporary tables are created in tmpdir only if configured to use MyISAM。|tmp_tabe_size       | 16777216|

 |tmpdir                     |    /tmp      |

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

Shell>cd/var/lib/mysql

Shell>ls -1|grep temp

Drwxr-x---.2 mysql mysql 4096 Dec 11 14:05 #innodb_temp

Which statement is true about disk temporary tables for this installation?

shell> mysqld --initialize-insecure 

Which statement is true?

shell> mysqldump --no-create-info --all-databases --result-file=dump.sql 

Which statement is true?

Connection_control_min_connection_delay=1000

Connection_control_max_connection_delay=2000

The minimum and maximum delays need to be increased to 3000 and 5000, respectively.

A command is executed:

Mysql> SET GLOBAL connection_control_min_connection_delay=3000; What is the result?

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?

Which command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

Those servers are monitored with MySQL Enterprise Monitor.

Using Query Analyzer, where do you begin to look for problem queries?

/backup/full/mybackup/myimage.img mysqlbackup.cnf contains this data:

[mysqlbackup]

backup-dir=/backup/full/myrestore

backup-image=/backup/full/mybackup/myimage.img uncompress You must perform a database restore to a new machine.

which command can provision the new database in datadir as /data/MEB?

The database administrator is informed and immediately grants the required privilege:

GRANT UPDATE ON world.city TO 'user1';

How can you proceed with your transaction with the least interruption?

Which two steps are a part of implementing GTID replication?

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?

$mysqlbackup --user=dba      --password --port=3306 --with-timestamp --only-know-file-types --backup-dir=/exprot/backups backup Which statement is true?

Time

Id

Command

Argument

2019-12-17T00:36:23.389450z

24

Connect

root@localhost on mydb using SSL/TLS

2019-12-17T00:36:23.389450z

24

Query

select @@version_comment limit 1

2019-12-17T00:36:23.929519z

25

Connect

root@localhost on mydb using SSL/TLS

2019-12-17T00:36:23.929846z

25

Query

select @@version_comment limit 1

2019-12-17T00:36:27.633082z

24

Query

START TRANSACTION

2019-12-17T00:36:30.321657z

24

Query

UPDATE t1 SET val =1 WHERE ID=130

2019-12-17T00:36:32.417433z

25

Query

START TRANSACTION

2019-12-17T00:36:33.617642z

25

Query

UPDATE t2 SET val =5 WHERE ID=3805

2019-12-17T00:36:36.045498z

25

Query

UPDATE t1 SET val =10 WHERE ID=130

2019-12-17T00:36:33.617642z

25

Query

UPDATE t2 SET val =5 WHERE ID=3805

2019-12-17T00:36:38.513674z

24

Query

UPDATE t2 SET val =42 WHERE ID=3805

All UPDATE statements reference existing rows.

Which describes the outcome of the sequence of statements? 

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?