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
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.5/en/performance-schema-timing.html
D Truncate
E Disable and re-enable instruments
D.
https://dev.mysql.com/doc/refman/5.6/en/performance-schema-table-characteristics.html
F.
Tables in the performance_schema database are views or temporary tables that use no persistent on-disk storage.
http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html
Have tested and D & F seem to work
Reset instruments doesnt clear the tables. Note i reset instruments via update instrument table.
Tried to look for other ways but cldnt find command line option. But D and F deinitely work.
D&F
D, F
For sure: D & F