1z1-883 Free Dumps Study Materials
Question 9: 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, TRUNCATE TABLE
performance_schema.events_waits_current;
E. Disabling and re-enabling all instruments
F. Restarting Mysql
Correct Answer: D,E
Explanation:
D: To avoid unpredictable results if you make timer changes, use TRUNCATE
TABLE to reset Performance Schema statistics.
Example:
As with other aggregate tables within Performance Schema, you can reset the statistics within the
digest table with:
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
Reference: 22.2.3.1 Performance Schema Event Timing
http://dev.mysql.com/doc/refman/5.5/en/performance-schema-timing.html