MSGI>SHOW GLOBAL VARIABLES WHERE Varisble_name="tmpdir' OR Variable_name =' tmp_ table_ size;

+---------------+--------+
|Variable_name | Value   |
+---------------+--------+
| tmp_tabe_size|1677216|
I t m p d i r       | / t m p |
+---------------+--------+
Shell> cd /var/lib/mysql

Shell> ls -1l 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 ?

A. Temporary tables are created in tmpdir only if configured to use MylISAM.

B. Temporary tables are created in tmpdir only after they reach tmp table size

C. Temporary tables will use the InnoDB temporary tablespace located in datadir

D. Only internal temporary tables from the optimizer will be created in tmpdir.

E. Temporary tables will use the InnoDB temporary tablespace located in /tmp

Which statement is true?
A. The installation creates a temporary test environment with data in the /tmp directory

B. The installation is created without enforcing or generating SSL certificates.

C. The root password is created in the error log in plain text.

D. The root password is not created allowing easy access from the same host.

What is the result?

A. The minimum connection value is changed to 2000

B.Only the minimum connection value is increased to 3000.

C.The minimum value increases to 3000 and the maximum value increases to 4000

D.An error is retumed.

Examine this set of tables: Tables ( country, countryinfo, location).

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

A. mySqI> CLONE LOCAL DATA DIRECTORY = '"var/lib/mysql/worid x/country',

mySql> CLONE LOCAL DATA DIRECTORY = "var/lib/mysql/world x/countryinfo';

mySqI> CLONE LOCAL DATA DIRECTORY = "/var/lib/mysql/worid x/location'.

B. mySqI>SELECT * INTO OUTFILE '/output/contry.txt' FROM world x.country,

mySqI>SELECT *INTO OUTFILE '/output/contryinfo.txt' FROM world x.countryinfo,

mySqI>SELECT *INTO OUTFILE "/output/location.txt" FROM world x.location,

C. shell> mysqlexport world_x country countryinfo location> mydump.sql #没有 mysqlexport 这个工具

D.shell> mysql --batch word x.country world x.countryinfo world x.location > mydump.sql

E.shell> mysqldump worid x country countryinfo location > mydump.sql

Which operation will complete the command?
A. --write-to-remote-server must be added to the command line to uodate the database tables

B. lt can be piped into the MySQL Server via the command-line client.

C. You must use --stop-position=1797 to avoid the DELETE statement that caused the initial problem

D. No changes required. lt automatically updates the MySQL Server with the data.

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

OBJECT_TYPE:TABLE

OBJECT_SCHEMA.test

OBJECT_NAME:demo test

CONUNT_STAR:61567093

SUM_TMER_WAT:S9009007572922

MIN_TIMER_WAT:395922

AVG_TIMER_WAIT:9S8095

MAX_TIMER_WAIT:558852005358

COUNT_READ.30665056

SUM_TVER_READ:20598719962188

MIN_TIVER_READ:395922

AVG_TIMER_READ:532728

MAK_TIMER_READ:558652005356

COUNT_WRITE:22902028

SUM_TMER_WRITE 38410287610743

MIN_TIVER_WRITE-1130688

AVG_TIMER_WRITE:1677006

MAX_TIMER_WRITE:17205682920

COUNT_FETCH:38665056

SUM_TMER_FETCH:20598719962188

MIN_TIVER_FETCH:395922

AVG_TIMER_FETCHS32728

MAX_TIMER_FETCHS56652005358

......
COUNT_DELETE:22902028
SUM_TMER_DELETE:38410287610743
MIN_TIVER_DELETE:1130688
AVG_TIMER_DELETE:1677006
MAX_TIMER_DELETE:17205662920

Wnich two are true?

A. The longest lo wal was for wrtes.

B. lo dlsirbution ls approximately sos0 readirite

C.22902028 ro6 were deleted.

D. Average read times are approxmately three times faster than wrses

E. The lo average time ls 532728.

Which set of steps would restore only the missing table?

A. Stop the MySQL Server process, and execute.
mysqlbackup --datadir=/var/lib/mysql --backup-dir=/dbbackup -include-tables='Company.Customers' copy-backStart the mysqld process.

B. Stop the MySQL Server process and restart it with the command.mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysqlRun mysqldump on this table and restore the dump file.

C.Stop the MySQL Server process and restart it with the command.
mysqld --basedir=/usr/local/mysql --datadir=/dbbackupRun mysqldump on this table and restore the dump file

D. Stop the MySQL Server process, copy the Customers.ibd file from the dbbackup directory, and start the mysqldprocess.

Which two are true?

A. ANALYZE TABLE t would update index statistics uniquely for the PRIMARY index.

B. Table t has two viable indexes to be used for queries.

C. SELECT b from t would perform a table scan.

D. Index b_idx has a low number of unique values.
E. SELECT a FROM t would perform a table scan._

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?

A. CHECK TABLE FACTORY.INVENTORY

B. ANALYZE TABLE FACTORY.INVENTORY

C. OPTIMIZE TABLE FACTORY.INVENTORY

D. mysqlcheck -u root -p FACTORY.INVENTORY

E. mysqldump -u root -p FACTORY INVENTORY

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

A. Max_connections=10000

B. Innodb_log_file_size=1G

C. Sync_binlog=0

D. Innodb_doublewrite=0

E. Buffer_pool_size=24G

F. Innodb_flush_log_at_trx_commit=1

B. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

C. Look for queries with low total latency times in the Latency section in the time series graph.

D. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.

B. mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB image-to-dir-and-apply-log

C. mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB apply-log-and-copy-back

D. mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB copy-back-and-apply-log

E. mysqlbackup --defaults-file=mysqlbackup.cnf --datadir=/data/MEB image-to-dir

Which two statements are ture?

A. Configuring SSL group communication also configures SSL distributed recovery.

B. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.

C. If only some innoDB cluster members are enabled for SSL group communication, and --ssl-mode=PREFERED,
communication will fail back to unencrypted connection.

D. An existing innoDB cluster must be dissolved and created form scratch to enable SSL for group communication.

E. SSL group communication can be enabled for an existing cluster,one instance at time, by setting
group_replication_ssl_mode.

F. SSL group communication must be enable at cluster creation time by pecifying createCluster{{membersslmode
REQUIRED}}