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: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100, 

                          bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-10, 

                          cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237 

Slave: 

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?

do this by default？

（含图）

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?

Tables ( country, countryinfo, location) 

Which two option will export data into one or more files?

Mysql>SELECT * 

FROM performance_schema.table_10_waits_summary_by_table 

WHERE COUNT_STAAR >0\G 

********************************2.row ************************************** 

OBJECT_TYPE:TABLE 

OBJECT_SCHEMA:test 

OBJECT_NAME:demo_test 

CONUNT_STAR:61567093 

SUM_TIMER_WAIT:59009007572922MIN_TIMER_WAIT:395922 

AVG_TIMER_WAIT:958095 

MAX_TIMER_WAIT:558852005358 

COUNT_READ:38665056 

SUM_TIMER_READ:20598719962188 

MIN_TIMER_READ:395922 

AVG_TIMER_READ:532728 

MAX_TIMER_READ:558852005358 

COUNT_WRITE:22902028 

SUM_TIMER_WRITE:38410287610743 

MIN_TIMER_WRITE:1130688 

AVG_TIMER_WRITE:1677006 

MAX_TIMER_WRITE:17205682920 

COUNT_FETCH:38665056 

SUM_TIMER_FETCH:20598719962188 

MIN_TIMER_FETCH:395922 

AVG_TIMER_FETCH:532728 

MAX_TIMER_FETCH:558852005358 

..... 

COUNT_DELETE:22902028 

SUM_TIMER_DELETE:38410287610743 

MIN_TIMER_DELETE:1130688 

AVG_TIMER_DELETE:1677006 

MAX_TIMER_DELETE:17205682920 

Which two are true?

copy from two days ago in the dbbackup directory. 

Which set of steps would restore only the missing table?

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?

Examine these statements and output: 

Selet count(1) from t; 

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

| count(1) | 

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

| 72 | 

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

Mysql show indexes from t\G 

***************************1.row*************************** 

Table: t 

Non_unique:0 

Key_name:PRIMARY 

Seq_in_index: 1 

Column_name: a 

Collation:A 

Cardinality: 72 

Sub_part:NULL 

Packed:NULL 

Null: 

Index_type:STREE 

Comment: 

Index_comment: 

Visible:YES 

Expression:NULL 

***************************2.row*************************** 

Table: t 

Non_unique:1 

Key_name:b_idx 

Seq_in_index: 1 

Column_name: b 

Collation:A 

Cardinality: 1 

Sub_part:NULL 

Packed:NULL 

Null:YESIndex_type:BTREE 

Comment: 

Index_comment: 

Visible:NO 

Expression:NULL 

2 row in set (0.00 sec) 

Which two are true?

of rows of a large table named FACTORY.INVENTORY. 

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?

● 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?

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?

innodb cluster to use SSL for group communication. 

Which two statements are ture?