多项选择题
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?()
单项选择题 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?()
多项选择题 Which two statements are true about InnoDB auto-increment locking?()