A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B.Using the statement RESET PERFORMANCE CACHE
C.Using the statement FLUSH PERFORMANCE CACHE
D.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E.Disabling and re-enabling all instruments
F.Restarting Mysql

A.Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
B.An error message is issued because – install is not a valid option for mysqld
C.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf
D.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file

A.12; only top-level statements and stored procedure events are logged
B.111; top-level statements and all lower-level statements are logged
C.3; only the top-level statements are logged
D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event

A.The auto-increment lock can be a table-level lock
B.InnoDB never uses table-level locks
C.Some settings for innodb_autoinc_lock_mode can help reduce locking
D.InnoDB always protects auto-increment updates with a table-level lock

A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
B.Execute the PURGE BINARY LOGE NOT USED command
C.Remove all of the binary log files that have a modification date earlier than today
D.Edit the .index file to remove the files you want to delete
E.Ensure that none of the attached slaves are using any of the binary logs you want to delete

A.The command prints all parameter for the login-path. The password is replaced with stars
B.The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists
C.The command prints all parameters for the login-path. The password is shown only when you provide the  –password option
D.The command prints all parameters for the login-path. The password is printed in plain tex

A.The Query Cache is pruning queries due to an increased number of requests
B.Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups
C.Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature
D.The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution

A.Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';
B.Shell＞ mysql –u root –p sakila sakila2013.sql
C.Shell＞ mysql import –u root –p sakila sakila2013.sql
D.Shell＞ mysql  –u root -p  –e 'use sakila; source sakila2013.sql'
E.Shell＞ mysql  –u root  –p  –silent ＜ sakila2013.sql

A.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
B.The table definition on the slave -litters from the master
C.Multi-threaded replication slaves can have temporary errors occurring for cross database updates
D.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

A.A syntax error will result as you cannot specify more than one partition in the same statement
B.All data in p1 and p3 partitions are removed and the table definition is changed
C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D.Only the first partition (p1) will be dropped as only one can be dropped at any time