--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+---------------------------------------------------+------------+----------------+
| event_name                                        | count_star | sum_timer_wait |
+---------------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/lock_mutex                |         64 |      418777898 |
| wait/synch/mutex/sql/THD::LOCK_thd_data           |       1967 |      277851288 |
| wait/synch/rwlock/sql/LOCK_system_variables_hash  |        640 |      276117424 |
| wait/synch/mutex/sql/LOCK_global_system_variables |        256 |      226357868 |
| wait/synch/mutex/innodb/dict_sys_mutex            |        247 |      115064532 |
| wait/synch/mutex/innodb/flush_list_mutex          |       1280 |       88117744 |
| wait/synch/mutex/sql/hash_filo::lock              |         64 |       87202742 |
| wait/synch/rwlock/sql/MDL_lock::rwlock            |        156 |       69473690 |
| wait/synch/mutex/sql/LOCK_table_cache             |        172 |       48741308 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill           |        140 |       40108354 |
+---------------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        384 |       28293584 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         87 |       14904626 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        114 |       10737584 |
| wait/synch/mutex/innodb/fil_system_mutex     |        114 |        7764768 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         16 |        2859120 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1631872 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1401136 |
| wait/synch/mutex/innodb/lock_wait_mutex      |          4 |        1377728 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        384 |       26323968 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        114 |        9226096 |
| wait/synch/mutex/innodb/fil_system_mutex     |        114 |        7336736 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         87 |        5939362 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         12 |        3067284 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/lock_wait_mutex      |          3 |        1948716 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1638560 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1469688 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       37051520 |
| wait/synch/mutex/mysys/LOCK_timer            |         18 |       32393328 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13379344 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10202544 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         89 |        6524562 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2043184 |
| wait/synch/mutex/innodb/lock_wait_mutex      |          4 |        1688720 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1437920 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        384 |       43706080 |
| wait/synch/mutex/innodb/fil_system_mutex     |        114 |       11794288 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        114 |       10252704 |
| wait/synch/mutex/mysys/LOCK_timer            |         12 |        8460320 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7163266 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2120096 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1809104 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          3 |        1601776 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       37138464 |
| wait/synch/mutex/mysys/LOCK_timer            |         14 |       32289664 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13439536 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10342992 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |        106 |       10209650 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          9 |        4270288 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         28 |        2207040 |
| wait/synch/mutex/sql/LOCK_table_cache        |         14 |        1999712 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35546720 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12810864 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9884864 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7773546 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        2515106 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1926144 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1631872 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1182104 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34767568 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12376144 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9801264 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        8129682 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1875984 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1785696 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1758944 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1531552 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36770624 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13115168 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10413216 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7868850 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1976304 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1655280 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1598432 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1511488 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35122032 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12533312 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9734384 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7348858 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        2992880 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2120096 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1966272 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1936176 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34680624 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12252416 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9791232 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        6833882 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2572372 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1953732 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1702096 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1434576 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35001648 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12476464 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9928336 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        6935874 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        2023120 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1946208 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1859264 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1768976 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35315984 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12406240 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9761136 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7474258 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2153536 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1916112 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1906080 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1829168 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34897984 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12004960 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9761136 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7409050 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        2337456 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2019776 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1901064 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1795728 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34376320 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12252416 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9888208 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7620558 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1976304 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1685376 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1601776 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1427888 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34336192 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12048432 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9801264 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7071306 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1939520 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1802416 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1690392 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1685376 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36827472 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12994784 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10005248 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7322106 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2539768 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2039840 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1605120 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1464672 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34734128 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12509904 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9971808 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7179986 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1996368 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1919456 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1825824 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1779008 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36452944 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13065008 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9951744 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7865506 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        2120096 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1855920 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1675344 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1457984 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36292432 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12874400 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9908272 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7763514 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1815792 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1812448 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1772320 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1478048 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34894640 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12473120 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9938368 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7912740 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2212056 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1782352 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1541584 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1461328 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34677280 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12733952 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9844736 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        8064892 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        2036496 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1921128 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1900646 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1789040 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        384 |       26989424 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        114 |        9323072 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7977948 |
| wait/synch/mutex/innodb/fil_system_mutex     |        114 |        7336736 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1957076 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1809940 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          3 |        1792384 |
| wait/synch/mutex/aria/TRANSLOG_BUFFER::mutex |          1 |        1571680 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       33453376 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       11533456 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9650784 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7780234 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        2063248 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1829168 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1815792 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1304160 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35479840 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12921216 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9854768 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        8184858 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2083730 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1916112 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1715472 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1447116 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       37332416 |
| wait/synch/mutex/sql/LOCK_error_log          |        129 |       14315664 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13051632 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9988528 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        9884864 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        8219970 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1952896 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1314192 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        640 |       40148064 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        190 |       14771702 |
| wait/synch/mutex/innodb/fil_system_mutex     |        190 |       11323202 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7883898 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2046528 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2033152 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1661968 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1528208 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       37967776 |
| wait/synch/mutex/sql/LOCK_error_log          |        129 |       15476032 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13041600 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |       11958144 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10259392 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7229728 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2019776 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1658624 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.006 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36252304 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13279024 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10205888 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7035358 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2130128 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1484736 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1397792 |
| wait/synch/mutex/sql/LOCK_binlog             |          9 |        1337600 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34496704 |
| wait/synch/mutex/sql/LOCK_error_log          |        129 |       14308976 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12305920 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9797920 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7425770 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1924472 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1785696 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1782352 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35901184 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13158640 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10062096 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        9268314 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1993024 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1932832 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1564992 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1478048 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36593392 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       14215344 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13218832 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10336304 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7890586 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1959584 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1625184 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1578368 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35887808 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13419472 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10376432 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7783578 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2006400 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1447952 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1411168 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1182104 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36138608 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       13984608 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13061664 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10252704 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        9597280 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7972514 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2051544 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2003056 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36269024 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12971376 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9924992 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7592970 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2098360 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1942864 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1765632 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1424544 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36342592 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13118512 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       13071696 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |       12422960 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10179136 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7591298 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2006400 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1819136 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35132064 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12466432 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9807952 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7372266 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        3307216 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2170256 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1748912 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1340944 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        384 |       25788928 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       14395920 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        114 |        9152528 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7763514 |
| wait/synch/mutex/innodb/fil_system_mutex     |        114 |        7527344 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2238808 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1899392 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          3 |        1588400 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (16.268 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34379664 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12302576 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9938368 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7181658 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_error_log          |         25 |        3430944 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        2283952 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        2143504 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2076624 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.074 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35566784 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12319296 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9834704 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7238506 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        2113408 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2073280 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2062412 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1712128 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.053 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       31844494 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       11227480 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9178862 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7317090 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_error_log          |         23 |        3002912 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1845888 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1725504 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1534896 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.094 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       31364212 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       11151404 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        8412668 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7257734 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2090000 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1802834 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1290784 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1270720 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.002 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       35061840 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12653696 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9878176 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7517730 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_error_log          |         27 |        3213584 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        2397648 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1966272 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1956240 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36777312 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13131888 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10366400 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7504354 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1892704 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1842544 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1427888 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1310848 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/sql/LOCK_error_log          |         51 |       42579152 |
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       37111712 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12904496 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10052064 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7367250 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2100032 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        1789040 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1404480 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34864544 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12262448 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9794576 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7119794 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2285624 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1926144 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1919456 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        1638560 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34961520 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       12449712 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       11844448 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9868144 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7173716 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1956240 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1765632 |
| wait/synch/mutex/mysys/LOCK_timer            |         10 |        1595088 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.159 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       36158672 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       13051632 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |       10132320 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7098058 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2431088 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        2310704 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1916112 |
| wait/synch/mutex/mysys/LOCK_timer            |          8 |        1421200 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.047 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |        512 |       34633808 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        152 |       12008304 |
| wait/synch/mutex/innodb/fil_system_mutex     |        152 |        9838048 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7887242 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_error_log          |         23 |        3247024 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/LOCK_table_cache        |         10 |        2081640 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2036496 |
| wait/synch/mutex/innodb/dict_sys_mutex       |          4 |        1812448 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Ctrl-C -- sending "KILL QUERY 442" to server ...
Ctrl-C -- query killed. Continuing normally.
Query OK, 0 rows affected, 1 warning (9.899 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+--------------------------------------------------+------------+----------------+
| event_name                                       | count_star | sum_timer_wait |
+--------------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex         |        512 |       34891296 |
| wait/synch/mutex/innodb/buf_pool_mutex           |        152 |       12359424 |
| wait/synch/mutex/innodb/fil_system_mutex         |        152 |       10011936 |
| wait/synch/mutex/sql/THD::LOCK_thd_data          |        106 |        8734946 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share     |         30 |        4515654 |
| wait/synch/mutex/sql/LOCK_plugin                 |          9 |        4273632 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill          |         33 |        3397504 |
| wait/synch/rwlock/sql/THD_list::lock             |          8 |        2711984 |
| wait/synch/mutex/aria/SHARE::intern_lock         |         56 |        2331186 |
| wait/synch/rwlock/sql/LOCK_system_variables_hash |          5 |        2106720 |
+--------------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.000 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         31 |  2010712004400 |
| wait/synch/mutex/sql/LOCK_item_func_sleep    |         41 |  1990740964256 |
| wait/synch/mutex/innodb/flush_list_mutex     |       1280 |       87067728 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        380 |       30791552 |
| wait/synch/mutex/innodb/fil_system_mutex     |        380 |       24421232 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       13014848 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         98 |        8701506 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         22 |        3892416 |
| wait/synch/mutex/innodb/dict_sys_mutex       |         10 |        2936032 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |       1280 |       85235216 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        380 |       29694720 |
| wait/synch/mutex/innodb/fil_system_mutex     |        380 |       24073456 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        8828578 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         20 |        3651648 |
| wait/synch/mutex/innodb/dict_sys_mutex       |         10 |        2374240 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2003056 |
| wait/synch/mutex/innodb/buf_dblwr_mutex      |         11 |        1682032 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |       1280 |       83362576 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        380 |       29194792 |
| wait/synch/mutex/innodb/fil_system_mutex     |        380 |       23501632 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       13372656 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7427442 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         22 |        3929200 |
| wait/synch/mutex/innodb/dict_sys_mutex       |         10 |        2384272 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/buf_dblwr_mutex      |         11 |        1850904 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |       1280 |       91495184 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        380 |       32878208 |
| wait/synch/mutex/innodb/fil_system_mutex     |        380 |       25521408 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       13305776 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        8551026 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         22 |        3813832 |
| wait/synch/mutex/innodb/dict_sys_mutex       |         10 |        3811742 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/innodb/buf_dblwr_mutex      |         11 |        2160224 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |       1280 |       85255280 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        380 |       29935488 |
| wait/synch/mutex/innodb/fil_system_mutex     |        380 |       24116928 |
| wait/synch/mutex/sql/LOCK_error_log          |        130 |       13051632 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        8892114 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         22 |        3942576 |
| wait/synch/mutex/innodb/dict_sys_mutex       |         10 |        2404336 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        1976304 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.007 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected (10.000 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

+----------------------------------------------+------------+----------------+
| event_name                                   | count_star | sum_timer_wait |
+----------------------------------------------+------------+----------------+
| wait/synch/mutex/innodb/flush_list_mutex     |       1280 |       84936764 |
| wait/synch/mutex/innodb/buf_pool_mutex       |        380 |       29530446 |
| wait/synch/mutex/innodb/fil_system_mutex     |        380 |       23898314 |
| wait/synch/mutex/sql/THD::LOCK_thd_data      |         91 |        7648146 |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share |         30 |        4515654 |
| wait/synch/mutex/mysys/LOCK_timer            |         20 |        3644960 |
| wait/synch/mutex/mysys/my_thread_var::mutex  |          2 |        2818992 |
| wait/synch/mutex/innodb/dict_sys_mutex       |         10 |        2414368 |
| wait/synch/mutex/aria/SHARE::intern_lock     |         56 |        2331186 |
| wait/synch/mutex/sql/THD::LOCK_thd_kill      |         27 |        2287296 |
+----------------------------------------------+------------+----------------+
10 rows in set (0.008 sec)

Bye
--------------
truncate events_waits_summary_global_by_event_name
--------------

Query OK, 0 rows affected (0.001 sec)

--------------
do sleep(10)
--------------

Query OK, 0 rows affected, 1 warning (0.841 sec)

--------------
select event_name, count_star, sum_timer_wait from events_waits_summary_global_by_event_name where count_star>0 order by SUM_TIMER_WAIT desc, count_star desc limit 10
--------------

Bye
