MySQL 8 Cookbook

Statement by type from each user

mysql> SELECT statement, total, total_latency, rows_sent, rows_examined, rows_affected, full_scans FROM sys.user_summary_by_statement_type ORDER BY total DESC LIMIT 5;+------------+--------+---------------+-----------+---------------+---------------+------------+| statement  | total  | total_latency | rows_sent | rows_examined | rows_affected | full_scans |+------------+--------+---------------+-----------+---------------+---------------+------------+| select     | 208535 | 1.14 d        |  27485256 |     799246972 |             0 |       9273 || Quit       | 199551 | 4.76 s        |         0 |             0 |             0 |          0 || insert     |   9848 | 12.75 m       |         0 |             0 |       5075058 |          0 || Ping       |   4674 | 278.76 ms     |         0 |             0 |             0 |          0 || set_option |   2552 | 634.76 ms     |         0 |             0 |             0 |          0 |+------------+--------+---------------+-----------+---------------+---------------+------------+ ...