多项选择题

Consider the events_% tables in performance Schema.
Which two methods will clear or reset the collected events in the tables?（）

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

点击查看答案

上一题目录下一题

相关考题

单项选择题

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.
C: \＞ mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?（）

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

单项选择题

Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( );
Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?（）

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

多项选择题

Which two statements are true about InnoDB auto-increment locking?（）

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

Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）

相关考题

Consider the events_% tables in performance Schema.
Which two methods will clear or reset the collected events in the tables?（）