1Z0-888 Question #45: Real Exam Question with Answer & Explanation

You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE. mysql> SELECT THREAD_ID, threads.NAME, SUM(COUNT_STAR) AS TotalCount, SUM (SUM_TIMER_WAIT) AS TotalTime -> FROM performance_schema.events_waits_summary_by_thread_by_event_name -> INNER JOIN performance_schema.threads USING (THREAD_ID) -> WHERE threads.NAME LIKE 'thread/sql/slave_%' -> GROUP BY THREAD_ID, threads.NAME; +-----------+-----------------------+------------+-----------+ | THREAD_ID | NAME | TotalCount | TotalTime | +-----------+-----------------------+------------+-----------+ | 20 | thread/sql/slave_io | 5785 | 654785731193 | | 21 | thread/sql/slave_sql | 3875 | 96931638913 | | 22 | thread/sql/slave_worker | 0 | 0 | | 23 | thread/sql/slave_worker | 0 | 0 | | 24 | thread/sql/slave_worker | 346730 | 7262131209667 | | 25 | thread/sql/slave_worker | 597127 | 15498842906584 | +-----------+-----------------------+------------+-----------+ Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?