（含图）

Which two conclusions can be made from the output?

Which two changes would ensure that the temporary table does not propagate to the slave? 

InnoDB: Warning: a long semaphore wait:

The relevant parts of the InnoDB monitor output shows:

（含图）

Which two options would help avoid the long wait in the future? 

（含图）

You execute a "SHOW CREATE TABLE mytable" on the slave:

（含图）

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.

Which statement should be used? 

You are unable to use an additional intermediate MySQL instance to restore the table.

Which two backup methods can be used to restore the single table without stopping the MySQL instance?

    [mysqld]

    skip-log-bin

/myfolder2/my.cnf has this option set: 

    [mysqld]

    log-bin = /valid/path/to/mysqlbinlog

All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.

You start an instance by using this command line:

mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf 

What is the outcome?

mysqld: Can’t change dir to '/var/lib/mysql/' (Errcode: 13 - Permission denied)

The user option is set to mysql in /etc/my.cnf.

What is the reason for this error and how do you fix it?

Mysql > select user, host , plugin, authentication_string from user;

（含图）

Which two statements will best secure this environment?

shell> cat /etc/my.cnf

[mysqld] 

log-bin 

server-id=1

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections. 

Which two arguments will you pass to mysqldump to achieve this?

`id` int unsignet NOT NULL AUTO_INCREMENT,

`val` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)

) ENGINE=InnoDB;

Some example values are:

（含图）

A typical query using the val column for filltering is:

mysql > SELECT * FROM t1 WHERE val LIKE '%/def/%';

Which three changes will allow the use of an index to perform this kind of filtering?

（含图）

The application uses a query such as:

SELECT * FROM people WHERE YEAR(Birthday) = 1980; The query is not using an index.

Which two methods can be used to allow the query to use an index?

（含图）

What does the possible_keys column in this output denote? 

Mysql> SELECT thd_id, conn_id, user, state, time FROM sys.session;

（含图）

12 rows in set (0.42 sec)

Why does the message "Waiting for an event from Coordinator" show up on the slave_worker threads?