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?

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



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Vince

Vince

D Truncate
E Disable and re-enable instruments

Saimoni

Saimoni

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.

dash-68

dash-68

For sure: D & F