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

Which statement is true?

There is a datadir copy from two days ago in the dbbackup directory

Which set of steps would restore only the missing table?

/backup/ful 1/mybacku p/myimage.img

mysqlbackup.cnf contains this data

[mysq I backup]

backup-d ir= /backup/ful 1/myresto re

backup-image=/backup/full/mybackup/myimag e.1mg

uncompress

You must perform a d ata base restore to a new ma chine.

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

$mysqlbackup --user= dba --password --port=3306 --with-timestamp --only-know-file-types --backu p-dir= /exprot/backups backup

Which statement is true？

Company policy is to create a backup every day

The main tables being updated are prefixed with transactions-.

These tables are archived into tables that are prefixed with archives- each month

mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*"backup

Which optimization process best describes what happens with the redo logs?

In the output, there is a value for Seconds_ behind_ master.

How is this time calculated?

The slave instance had a disk I/0 problem, so it was stopped

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged

You restart MySQL Server.

How can replication be restored?

MASTER command are correct. Examine the GTID information from both master and slave

（含图）

Which statement is true?

（含图）

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

shell> mysqld --initialize- insecure

Which statement is true?

[mysq ld]

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?

Examine this client error:

（含图）

Which option will allow this client to connect to MYSQL Server?

Examine the output

（含图）

What statement is true about the start attempt?

[mysqld]

user=mysql

datadir=/data/mysql

Which method sets the default authentication to SHA-256 hashing for authenticating

user account passwords?

GLOBAL STATUS 1

（含图）

GLOBAL STATUS 2:

（含图）

Your MySQL system normally supports 50-75 concurrent connections.

Which configuration change will improve performance?