db2079
db2080
db2081
db2082
db2083
db2084
db2085:3318
db2086:3318
db2091

set sql_log_bin=0;
GRANT SELECT, EXECUTE ON `sys`.* TO <mw_admin_account>;
GRANT SELECT ON `performance_schema`.* TO <mw_admin_account>;

we want your ok to expose low level internal mw database performance metrics to mw deployers for debugging purposes, through the existing mediawiki admin database account. Think of logs, but real time and database layer. Metrics will be accessed, for now, through the SQL interface only. There is a lot of metrics involved (literally billions of them) but it includes file, thread, user, transaction, query and query digest, and indexes individual metrics and counters (aggregations). Currently that access is reserved for mysql root users only.

host_summary
+--------------+------------+-------------------+-----------------------+-------------+----------+-----------------+---------------------+-------------------+--------------+
| host         | statements | statement_latency | statement_avg_latency | table_scans | file_ios | file_io_latency | current_connections | total_connections | unique_users |
+--------------+------------+-------------------+-----------------------+-------------+----------+-----------------+---------------------+-------------------+--------------+
| 10.192.0.113 |   34848092 | 3.36 h            | 347.46 us             |     1092621 |   211236 | 43.48 s         |                   0 |           1064561 |            1 |
+--------------+------------+-------------------+-----------------------+-------------+----------+-----------------+---------------------+-------------------+--------------+
host_summary_by_file_io
+------------+------------+------------+
| host       | ios        | io_latency |
+------------+------------+------------+
| background | 8828173834 | 3.99 d     |
+------------+------------+------------+
host_summary_by_file_io_type
+--------------+--------------------------------------+--------+---------------+-------------+
| host         | event_name                           | total  | total_latency | max_latency |
+--------------+--------------------------------------+--------+---------------+-------------+
| 10.192.0.113 | wait/io/file/innodb/innodb_data_file | 211002 | 43.47 s       | 43.55 ms    |
+--------------+--------------------------------------+--------+---------------+-------------+
host_summary_by_stages
host_summary_by_statement_latency
+------------+------------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
| host       | total      | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans |
+------------+------------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
| background | 2382240462 | 1.11 w        | 4.85 h      | 1.29 d       |         0 |    1570489550 |             0 |       4169 |
+------------+------------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
host_summary_by_statement_type
+--------------+-----------+----------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
| host         | statement | total    | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans |
+--------------+-----------+----------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
| 10.192.0.113 | select    | 30924098 | 3.31 h        | 17.73 s     | 31.20 m      |  60393898 |     614363763 |             0 |    1037491 |
+--------------+-----------+----------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
innodb_buffer_stats_by_schema
+---------------+-----------+-----------+---------+--------------+-----------+-------------+
| object_schema | allocated | data      | pages   | pages_hashed | pages_old | rows_cached |
+---------------+-----------+-----------+---------+--------------+-----------+-------------+
| wikidatawiki  | 57.18 GiB | 88.27 GiB | 7495291 |      7495291 |   7495291 |    21118151 |
+---------------+-----------+-----------+---------+--------------+-----------+-------------+
innodb_buffer_stats_by_table
+---------------+----------------+-----------+-----------+---------+--------------+-----------+-------------+
| object_schema | object_name    | allocated | data      | pages   | pages_hashed | pages_old | rows_cached |
+---------------+----------------+-----------+-----------+---------+--------------+-----------+-------------+
| wikidatawiki  | wbt_item_terms | 20.59 GiB | 28.82 GiB | 2698613 |      2698613 |   2698613 |   356000675 |
+---------------+----------------+-----------+-----------+---------+--------------+-----------+-------------+
innodb_lock_waits
io_by_thread_by_latency
+-----------+------------+---------------+-------------+-------------+-------------+-----------+----------------+
| user      | total      | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id |
+-----------+------------+---------------+-------------+-------------+-------------+-----------+----------------+
| slave_sql | 4779213158 | 3.32 d        | 825.68 ns   | 73.44 us    | 1.17 s      |        28 |           NULL |
+-----------+------------+---------------+-------------+-------------+-------------+-----------+----------------+
io_global_by_file_by_bytes
+-------------------+------------+------------+-----------+-------------+---------------+-----------+----------+-----------+
| file              | count_read | total_read | avg_read  | count_write | total_written | avg_write | total    | write_pct |
+-------------------+------------+------------+-----------+-------------+---------------+-----------+----------+-----------+
| @@datadir/ibdata1 |       1168 | 20.27 MiB  | 17.77 KiB |    74644501 | 6.17 TiB      | 88.79 KiB | 6.17 TiB |    100.00 |
+-------------------+------------+------------+-----------+-------------+---------------+-----------+----------+-----------+
io_global_by_file_by_latency
+-----------------------+------------+---------------+------------+--------------+-------------+---------------+------------+--------------+
| file                  | total      | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency |
+-----------------------+------------+---------------+------------+--------------+-------------+---------------+------------+--------------+
| @@datadir/ib_logfile1 | 1224247647 | 1.10 d        |          2 | 613.90 us    |   612124894 | 2.82 h        |  612122751 | 23.66 h      |
+-----------------------+------------+---------------+------------+--------------+-------------+---------------+------------+--------------+
io_global_by_wait_by_bytes
+-------------------------+------------+---------------+-------------+-------------+-------------+------------+------------+----------+-------------+---------------+-------------+-----------------+
| event_name              | total      | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested |
+-------------------------+------------+---------------+-------------+-------------+-------------+------------+------------+----------+-------------+---------------+-------------+-----------------+
| innodb/innodb_data_file | 1616618962 | 1.20 d        | 0 ps        | 64.24 us    | 147.40 ms   |  450473236 | 3.36 TiB   | 8.00 KiB |   471838816 | 9.13 TiB      | 20.78 KiB   | 12.49 TiB       |
+-------------------------+------------+---------------+-------------+-------------+-------------+------------+------------+----------+-------------+---------------+-------------+-----------------+
io_global_by_wait_by_latency
+------------------------+------------+---------------+-------------+-------------+--------------+---------------+--------------+------------+------------+-----------+-------------+---------------+-------------+
| event_name             | total      | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read  | count_write | total_written | avg_written |
+------------------------+------------+---------------+-------------+-------------+--------------+---------------+--------------+------------+------------+-----------+-------------+---------------+-------------+
| innodb/innodb_log_file | 2447910584 | 2.21 d        | 77.86 us    | 394.45 ms   | 1.96 ms      | 5.64 h        | 1.97 d       |          6 | 66.50 KiB  | 11.08 KiB |  1223957608 | 4.37 TiB      | 3.83 KiB    |
+------------------------+------------+---------------+-------------+-------------+--------------+---------------+--------------+------------+------------+-----------+-------------+---------------+-------------+
latest_file_io
metrics
+-----------------+----------------+---------------+---------+
| Variable_name   | Variable_value | Type          | Enabled |
+-----------------+----------------+---------------+---------+
| aborted_clients | 37868          | Global Status | YES     |
+-----------------+----------------+---------------+---------+
processlist
+--------+---------+----------+-------+---------+-------+----------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+----------------+------------------------+-----------+-------------------+--------+
| thd_id | conn_id | user     | db    | command | state | time     | current_statement | statement_latency | lock_latency | rows_examined | rows_sent | rows_affected | tmp_tables | tmp_disk_tables | full_scan | last_statement | last_statement_latency | last_wait | last_wait_latency | source |
+--------+---------+----------+-------+---------+-------+----------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+----------------+------------------------+-----------+-------------------+--------+
|      1 |    NULL | sql/main | mysql | NULL    | NULL  | 13366316 | NULL              | NULL              | NULL         |          NULL |      NULL |          NULL |       NULL |            NULL | NO        | NULL           | NULL                   | NULL      | NULL              | NULL   |
+--------+---------+----------+-------+---------+-------+----------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+----------------+------------------------+-----------+-------------------+--------+
ps_check_lost_instrumentation
+----------------------------------+----------------+
| variable_name                    | variable_value |
+----------------------------------+----------------+
| PERFORMANCE_SCHEMA_ACCOUNTS_LOST | 58300          |
+----------------------------------+----------------+
schema_auto_increment_columns
+--------------+---------------+-------------+-----------+------------------+-----------+-------------+------------+----------------+----------------------+
| table_schema | table_name    | column_name | data_type | column_type      | is_signed | is_unsigned | max_value  | auto_increment | auto_increment_ratio |
+--------------+---------------+-------------+-----------+------------------+-----------+-------------+------------+----------------+----------------------+
| wikidatawiki | recentchanges | rc_id       | int       | int(10) unsigned |         0 |           1 | 4294967295 |     1540954690 |               0.3588 |
+--------------+---------------+-------------+-----------+------------------+-----------+-------------+------------+----------------+----------------------+
schema_index_statistics
+--------------+----------------+------------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name     | index_name             | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+----------------+------------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wbt_item_terms | wbt_item_terms_item_id |  588914841420 | 16.66 w        |             0 | 0 ps           |            0 | 0 ps           |      4385266 | 0 ps           |
+--------------+----------------+------------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
schema_object_overview
+-----------+-------------+-------+
| db        | object_type | count |
+-----------+-------------+-------+
| heartbeat | BASE TABLE  |     1 |
+-----------+-------------+-------+
schema_redundant_indexes
+--------------+------------+----------------------+-------------------------+----------------------------+---------------------+------------------------+---------------------------+----------------+----------------------------------------------------------------+
| table_schema | table_name | redundant_index_name | redundant_index_columns | redundant_index_non_unique | dominant_index_name | dominant_index_columns | dominant_index_non_unique | subpart_exists | sql_drop_index                                                 |
+--------------+------------+----------------------+-------------------------+----------------------------+---------------------+------------------------+---------------------------+----------------+----------------------------------------------------------------+
| wikidatawiki | config     | cf_name_value        | cf_name,cf_value        |                          1 | PRIMARY             | cf_name                |                         0 |              1 | ALTER TABLE `wikidatawiki`.`config` DROP INDEX `cf_name_value` |
+--------------+------------+----------------------+-------------------------+----------------------------+---------------------+------------------------+---------------------------+----------------+----------------------------------------------------------------+
schema_table_statistics
+--------------+----------------+---------------+--------------+---------------+---------------+----------------+--------------+----------------+--------------+----------------+------------------+------------+-----------------+-------------------+------------+------------------+------------------+-----------------+
| table_schema | table_name     | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read    | io_read_latency | io_write_requests | io_write   | io_write_latency | io_misc_requests | io_misc_latency |
+--------------+----------------+---------------+--------------+---------------+---------------+----------------+--------------+----------------+--------------+----------------+------------------+------------+-----------------+-------------------+------------+------------------+------------------+-----------------+
| wikidatawiki | wbt_item_terms | 16.70 w       | 588947836010 | 16.66 w       |     188037185 | 6.07 h         |            0 | 0 ps           |     15925176 | 13.87 m        |         60678271 | 462.94 GiB | 3.24 h          |          26569613 | 202.71 GiB | 6.21 m           |         40251464 | 21.97 m         |
+--------------+----------------+---------------+--------------+---------------+---------------+----------------+--------------+----------------+--------------+----------------+------------------+------------+-----------------+-------------------+------------+------------------+------------------+-----------------+
schema_table_statistics_with_buffer
+--------------+----------------+--------------+---------------+---------------+----------------+--------------+----------------+--------------+----------------+------------------+------------+-----------------+-------------------+------------+------------------+------------------+-----------------+-------------------------+--------------------+--------------------+---------------------+----------------------------+-------------------------+---------------------------+
| table_schema | table_name     | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read    | io_read_latency | io_write_requests | io_write   | io_write_latency | io_misc_requests | io_misc_latency | innodb_buffer_allocated | innodb_buffer_data | innodb_buffer_free | innodb_buffer_pages | innodb_buffer_pages_hashed | innodb_buffer_pages_old | innodb_buffer_rows_cached |
+--------------+----------------+--------------+---------------+---------------+----------------+--------------+----------------+--------------+----------------+------------------+------------+-----------------+-------------------+------------+------------------+------------------+-----------------+-------------------------+--------------------+--------------------+---------------------+----------------------------+-------------------------+---------------------------+
| wikidatawiki | wbt_item_terms | 588947868489 | 16.66 w       |     188037187 | 6.07 h         |            0 | 0 ps           |     15925176 | 13.87 m        |         60678274 | 462.94 GiB | 3.24 h          |          26569613 | 202.71 GiB | 6.21 m           |         40251464 | 21.97 m         | 20.61 GiB               | 28.85 GiB          | -8846661828 bytes  |             2701522 |                    2701522 |                 2701522 |                 356387265 |
+--------------+----------------+--------------+---------------+---------------+----------------+--------------+----------------+--------------+----------------+------------------+------------+-----------------+-------------------+------------+------------------+------------------+-----------------+-------------------------+--------------------+--------------------+---------------------+----------------------------+-------------------------+---------------------------+
schema_tables_with_full_table_scans
+---------------+---------------------+-------------------+---------+
| object_schema | object_name         | rows_full_scanned | latency |
+---------------+---------------------+-------------------+---------+
| wikidatawiki  | wb_changes_dispatch |       42476230348 | 8.15 h  |
+---------------+---------------------+-------------------+---------+
schema_unused_indexes
+---------------+--------------+------------+
| object_schema | object_name  | index_name |
+---------------+--------------+------------+
| wikidatawiki  | abuse_filter | af_user    |
+---------------+--------------+------------+
session
+------------+-----------+----------------------+--------------------+---------+-------+------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+-------------------------------------------------------------------+------------------------+-----------+-------------------+--------+
| thd_id     | conn_id   | user                 | db                 | command | state | time | current_statement | statement_latency | lock_latency | rows_examined | rows_sent | rows_affected | tmp_tables | tmp_disk_tables | full_scan | last_statement                                                    | last_statement_latency | last_wait | last_wait_latency | source |
+------------+-----------+----------------------+--------------------+---------+-------+------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+-------------------------------------------------------------------+------------------------+-----------+-------------------+--------+
| 4736178362 | 614709641 | watchdog@10.64.0.122 | information_schema | Sleep   | NULL  | 2769 | NULL              | NULL              | 121.00 us    |             0 |         0 |             0 |          1 |               0 | YES       | SELECT `USER`, `TOTAL_CONNECTI ... UERIES` FROM `USER_STATISTICS` | 263.79 us              | NULL      | NULL              | NULL   |
+------------+-----------+----------------------+--------------------+---------+-------+------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+-------------------------------------------------------------------+------------------------+-----------+-------------------+--------+
statement_analysis
+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
| query                                                             | db           | full_scan | exec_count | err_count | warn_count | total_latency | max_latency | avg_latency | lock_latency | rows_sent  | rows_sent_avg | rows_examined | rows_examined_avg | rows_affected | rows_affected_avg | tmp_tables | tmp_disk_tables | rows_sorted | sort_merge_passes | digest                           | first_seen          | last_seen           |
+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
| SELECT `wbtl_id` , `wbtl_type_ ... ` = ? AND `wbxl_language` = ?  | wikidatawiki |           | 2581232585 |         0 |          0 | 14.01 w       | 628.43 ms   | 3.28 ms     | 2.45 d       | 1390280777 |             1 |  382287347978 |               148 |             0 |                 0 |          0 |               0 |           0 |                 0 | e6710becca6f731f082ec61199fa2f7d | 2021-06-14 11:32:22 | 2021-09-07 05:58:09 |
+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
statements_with_errors_or_warnings
+-------------------------------------------------------------------+--------------+------------+--------+-----------+----------+-------------+---------------------+---------------------+----------------------------------+
| query                                                             | db           | exec_count | errors | error_pct | warnings | warning_pct | first_seen          | last_seen           | digest                           |
+-------------------------------------------------------------------+--------------+------------+--------+-----------+----------+-------------+---------------------+---------------------+----------------------------------+
| SELECT `page_id` , `page_len`  ...  AND `page_title` = ? LIMIT ?  | wikidatawiki | 1378186682 |   2654 |    0.0002 |        0 |      0.0000 | 2021-04-05 13:04:50 | 2021-09-07 05:58:10 | 8d06129ff0b06526429e6fa04681c977 |
+-------------------------------------------------------------------+--------------+------------+--------+-----------+----------+-------------+---------------------+---------------------+----------------------------------+
statements_with_full_table_scans
+-------------------------------------------------------------------+--------------------+------------+---------------+---------------------+--------------------------+-------------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| query                                                             | db                 | exec_count | total_latency | no_index_used_count | no_good_index_used_count | no_index_used_pct | rows_sent | rows_examined | rows_sent_avg | rows_examined_avg | first_seen          | last_seen           | digest                           |
+-------------------------------------------------------------------+--------------------+------------+---------------+---------------------+--------------------------+-------------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| SELECT `TRIGGER_CATALOG` , `TR ... HERE ( `TRIGGER_SCHEMA` = ? )  | information_schema |        168 | 975.48 ms     |                 168 |                        0 |               100 |         0 |             0 |             0 |                 0 | 2021-04-06 00:01:14 | 2021-04-29 00:02:22 | ce45a8c224e5ead251ef363c5820285c |
+-------------------------------------------------------------------+--------------------+------------+---------------+---------------------+--------------------------+-------------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
statements_with_runtimes_in_95th_percentile
+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| query                                                             | db           | full_scan | exec_count | err_count | warn_count | total_latency | max_latency | avg_latency | rows_sent | rows_sent_avg | rows_examined | rows_examined_avg | first_seen          | last_seen           | digest                           |
+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| CREATE UNIQUE INDEX `page_name ... e_namespace` , `page_title` )  | wikidatawiki |           |          1 |         0 |          0 | 4.13 h        | 4.13 h      | 4.13 h      |         0 |             0 |             0 |                 0 | 2021-06-15 09:02:50 | 2021-06-15 09:02:50 | 4cedbd9c825e94867ad9896d37837c09 |
+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
statements_with_sorting
+-------------------------------------------------------------------+--------------+------------+---------------+-------------------+-----------------+-------------------+------------------+-------------+-----------------+---------------------+---------------------+----------------------------------+
| query                                                             | db           | exec_count | total_latency | sort_merge_passes | avg_sort_merges | sorts_using_scans | sort_using_range | rows_sorted | avg_rows_sorted | first_seen          | last_seen           | digest                           |
+-------------------------------------------------------------------+--------------+------------+---------------+-------------------+-----------------+-------------------+------------------+-------------+-----------------+---------------------+---------------------+----------------------------------+
| SELECT TIMESTAMPDIFF ( MICROSE ...  ? ORDER BY `ts` DESC LIMIT ?  | wikidatawiki | 4189252743 | 1.34 w        |                 0 |               0 |        4191660145 |                0 |  4191664303 |               1 | 2021-05-05 19:19:33 | 2021-09-07 05:58:16 | 752ffd44d554202978a146a0b714dd21 |
+-------------------------------------------------------------------+--------------+------------+---------------+-------------------+-----------------+-------------------+------------------+-------------+-----------------+---------------------+---------------------+----------------------------------+
statements_with_temp_tables
+-------------------------------------------------------------------+--------------+------------+---------------+-------------------+-----------------+--------------------------+------------------------+---------------------+---------------------+----------------------------------+
| query                                                             | db           | exec_count | total_latency | memory_tmp_tables | disk_tmp_tables | avg_tmp_tables_per_query | tmp_tables_to_disk_pct | first_seen          | last_seen           | digest                           |
+-------------------------------------------------------------------+--------------+------------+---------------+-------------------+-----------------+--------------------------+------------------------+---------------------+---------------------+----------------------------------+
| SELECT * FROM ( SELECT `rev_id ...  `rev_id` DESC LIMIT ?, ... )  | wikidatawiki |    3131785 | 3.94 h        |           3131764 |         3131747 |                        1 |                    100 | 2021-08-04 19:10:22 | 2021-09-07 05:58:15 | b70092435539822140e993e99673656b |
+-------------------------------------------------------------------+--------------+------------+---------------+-------------------+-----------------+--------------------------+------------------------+---------------------+---------------------+----------------------------------+
sys_config
+------------------------------+-------+---------------------+--------+
| variable                     | value | set_time            | set_by |
+------------------------------+-------+---------------------+--------+
| diagnostics.allow_i_s_tables | OFF   | 2016-05-04 14:28:58 | NULL   |
+------------------------------+-------+---------------------+--------+
user_summary
+------------+------------+-------------------+-----------------------+-------------+------------+-----------------+---------------------+-------------------+--------------+
| user       | statements | statement_latency | statement_avg_latency | table_scans | file_ios   | file_io_latency | current_connections | total_connections | unique_hosts |
+------------+------------+-------------------+-----------------------+-------------+------------+-----------------+---------------------+-------------------+--------------+
| background | 2382290774 | 1.11 w            | 281.43 us             |        4170 | 8828246472 | 3.99 d          |                 217 |           4632669 |            0 |
+------------+------------+-------------------+-----------------------+-------------+------------+-----------------+---------------------+-------------------+--------------+
user_summary_by_file_io
+------------+------------+------------+
| user       | ios        | io_latency |
+------------+------------+------------+
| background | 8828246647 | 3.99 d     |
+------------+------------+------------+
user_summary_by_file_io_type
+------------+-------------------------------------+------------+---------+-------------+
| user       | event_name                          | total      | latency | max_latency |
+------------+-------------------------------------+------------+---------+-------------+
| background | wait/io/file/innodb/innodb_log_file | 2447927847 | 2.21 d  | 394.45 ms   |
+------------+-------------------------------------+------------+---------+-------------+
user_summary_by_stages
user_summary_by_statement_latency
+----------+-------------+---------------+-------------+--------------+-------------+---------------+---------------+------------+
| user     | total       | total_latency | max_latency | lock_latency | rows_sent   | rows_examined | rows_affected | full_scans |
+----------+-------------+---------------+-------------+--------------+-------------+---------------+---------------+------------+
| wikiuser | 59418889073 | 19.69 w       | 1.55 m      | 3.94 w       | 91317797617 | 1858826706972 |             0 | 4742873705 |
+----------+-------------+---------------+-------------+--------------+-------------+---------------+---------------+------------+
user_summary_by_statement_type
+------------+-----------+------------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
| user       | statement | total      | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans |
+------------+-----------+------------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
| background | insert    | 1251338437 | 3.37 d        | 661.09 ms   | 15.30 h      |         0 |             0 |             0 |          0 |
+------------+-----------+------------+---------------+-------------+--------------+-----------+---------------+---------------+------------+
version
+-------------+---------------------+
| sys_version | mysql_version       |
+-------------+---------------------+
| 1.5.0       | 10.4.18-MariaDB-log |
+-------------+---------------------+
wait_classes_global_by_avg_latency
+--------------+------------+---------------+-------------+-------------+-------------+
| event_class  | total      | total_latency | min_latency | avg_latency | max_latency |
+--------------+------------+---------------+-------------+-------------+-------------+
| wait/io/file | 9225895181 | 4.74 d        | 0 ps        | 44.35 us    | 1.61 s      |
+--------------+------------+---------------+-------------+-------------+-------------+
wait_classes_global_by_latency
+---------------+---------------+---------------+-------------+-------------+-------------+
| event_class   | total         | total_latency | min_latency | avg_latency | max_latency |
+---------------+---------------+---------------+-------------+-------------+-------------+
| wait/io/table | 1884235798773 | 2.62 w        | 44.33 ns    | 842.54 ns   | 1.64 s      |
+---------------+---------------+---------------+-------------+-------------+-------------+
waits_by_host_by_latency
+--------------+---------------------------+-----------+---------------+-------------+-------------+
| host         | event                     | total     | total_latency | avg_latency | max_latency |
+--------------+---------------------------+-----------+---------------+-------------+-------------+
| 10.192.0.113 | wait/io/table/sql/handler | 666100643 | 1.41 h        | 7.60 us     | 41.32 ms    |
+--------------+---------------------------+-----------+---------------+-------------+-------------+
waits_by_user_by_latency
+--------+---------------------------+---------+---------------+-------------+-------------+
| user   | event                     | total   | total_latency | avg_latency | max_latency |
+--------+---------------------------+---------+---------------+-------------+-------------+
| nagios | wait/io/table/sql/handler | 5209343 | 13.58 s       | 2.61 us     | 157.55 ms   |
+--------+---------------------------+---------+---------------+-------------+-------------+
waits_global_by_latency
+---------------------------+---------------+---------------+-------------+-------------+
| events                    | total         | total_latency | avg_latency | max_latency |
+---------------------------+---------------+---------------+-------------+-------------+
| wait/io/table/sql/handler | 1884236080404 | 2.62 w        | 10.63 us    | 1.64 s      |
+---------------------------+---------------+---------------+-------------+-------------+
x$host_summary
+--------------+------------+-------------------+-----------------------+-------------+----------+-----------------+---------------------+-------------------+--------------+
| host         | statements | statement_latency | statement_avg_latency | table_scans | file_ios | file_io_latency | current_connections | total_connections | unique_users |
+--------------+------------+-------------------+-----------------------+-------------+----------+-----------------+---------------------+-------------------+--------------+
| 10.192.0.113 |   34848150 | 12108452250087000 |        347463272.8018 |     1092628 |   211239 |  43485425474920 |                   0 |           1064568 |            1 |
+--------------+------------+-------------------+-----------------------+-------------+----------+-----------------+---------------------+-------------------+--------------+
x$host_summary_by_file_io
+------------+------------+--------------------+
| host       | ios        | io_latency         |
+------------+------------+--------------------+
| background | 8828247777 | 345130486810709886 |
+------------+------------+--------------------+
x$host_summary_by_file_io_type
+--------------+--------------------------------------+--------+----------------+-------------+
| host         | event_name                           | total  | total_latency  | max_latency |
+--------------+--------------------------------------+--------+----------------+-------------+
| 10.192.0.113 | wait/io/file/innodb/innodb_data_file | 211005 | 43476171645764 | 43550566488 |
+--------------+--------------------------------------+--------+----------------+-------------+
x$host_summary_by_stages
x$host_summary_by_statement_latency
+------------+------------+--------------------+-------------------+--------------------+-----------+---------------+---------------+------------+
| host       | total      | total_latency      | max_latency       | lock_latency       | rows_sent | rows_examined | rows_affected | full_scans |
+------------+------------+--------------------+-------------------+--------------------+-----------+---------------+---------------+------------+
| background | 2382292038 | 670451868331290000 | 17468509954824000 | 111577417783000000 |         0 |    1570520557 |             0 |       4170 |
+------------+------------+--------------------+-------------------+--------------------+-----------+---------------+---------------+------------+
x$host_summary_by_statement_type
+--------------+-----------+----------+-------------------+----------------+------------------+-----------+---------------+---------------+------------+
| host         | statement | total    | total_latency     | max_latency    | lock_latency     | rows_sent | rows_examined | rows_affected | full_scans |
+--------------+-----------+----------+-------------------+----------------+------------------+-----------+---------------+---------------+------------+
| 10.192.0.113 | select    | 30924134 | 11926176216421000 | 17728208218000 | 1871844436000000 |  60393931 |     614363805 |             0 |    1037498 |
+--------------+-----------+----------+-------------------+----------------+------------------+-----------+---------------+---------------+------------+
x$innodb_buffer_stats_by_schema
+---------------+-------------+-------------+---------+--------------+-----------+-------------+
| object_schema | allocated   | data        | pages   | pages_hashed | pages_old | rows_cached |
+---------------+-------------+-------------+---------+--------------+-----------+-------------+
| wikidatawiki  | 61391495168 | 94717556400 | 7494076 |      7494076 |   7494076 |    20033674 |
+---------------+-------------+-------------+---------+--------------+-----------+-------------+
x$innodb_buffer_stats_by_table
+---------------+----------------+-------------+-------------+---------+--------------+-----------+-------------+
| object_schema | object_name    | allocated   | data        | pages   | pages_hashed | pages_old | rows_cached |
+---------------+----------------+-------------+-------------+---------+--------------+-----------+-------------+
| wikidatawiki  | wbt_item_terms | 22141165568 | 30991536759 | 2702779 |      2702779 |   2702779 |   356582485 |
+---------------+----------------+-------------+-------------+---------+--------------+-----------+-------------+
x$innodb_lock_waits
x$io_by_thread_by_latency
+-----------+------------+--------------------+-------------+---------------+---------------+-----------+----------------+
| user      | total      | total_latency      | min_latency | avg_latency   | max_latency   | thread_id | processlist_id |
+-----------+------------+--------------------+-------------+---------------+---------------+-----------+----------------+
| slave_sql | 4779263824 | 286506242758100794 |      825682 | 73445306.0000 | 1165830609372 |        28 |           NULL |
+-----------+------------+--------------------+-------------+---------------+---------------+-----------+----------------+
x$io_global_by_file_by_bytes
+----------------------+------------+------------+------------+-------------+---------------+------------+---------------+-----------+
| file                 | count_read | total_read | avg_read   | count_write | total_written | avg_write  | total         | write_pct |
+----------------------+------------+------------+------------+-------------+---------------+------------+---------------+-----------+
| /srv/sqldata/ibdata1 |       1168 |   21250048 | 18193.5342 |    74645890 | 6787099328512 | 90923.9521 | 6787120578560 |    100.00 |
+----------------------+------------+------------+------------+-------------+---------------+------------+---------------+-----------+
x$io_global_by_file_by_latency
+--------------------------+------------+-------------------+------------+--------------+-------------+-------------------+------------+-------------------+
| file                     | total      | total_latency     | count_read | read_latency | count_write | write_latency     | count_misc | misc_latency      |
+--------------------------+------------+-------------------+------------+--------------+-------------+-------------------+------------+-------------------+
| /srv/sqldata/ib_logfile1 | 1224298777 | 95339685428925080 |          2 |    613899286 |   612150459 | 10153273329871100 |  612148316 | 85186411485154694 |
+--------------------------+------------+-------------------+------------+--------------+-------------+-------------------+------------+-------------------+
x$io_global_by_wait_by_bytes
+-------------------------+------------+--------------------+-------------+-------------+--------------+------------+---------------+-----------+-------------+----------------+-------------+-----------------+
| event_name              | total      | total_latency      | min_latency | avg_latency | max_latency  | count_read | total_read    | avg_read  | count_write | total_written  | avg_written | total_requested |
+-------------------------+------------+--------------------+-------------+-------------+--------------+------------+---------------+-----------+-------------+----------------+-------------+-----------------+
| innodb/innodb_data_file | 1616650855 | 103934141967023940 |           0 |    64289654 | 147395255722 |  450489038 | 3690419462144 | 8192.0294 |   471844072 | 10042340892672 |  21283.1770 |  13732760354816 |
+-------------------------+------------+--------------------+-------------+-------------+--------------+------------+---------------+-----------+-------------+----------------+-------------+-----------------+
x$io_global_by_wait_by_latency
+------------------------+------------+--------------------+-------------+--------------+--------------+-------------------+--------------------+------------+------------+------------+-------------+---------------+-------------+
| event_name             | total      | total_latency      | avg_latency | max_latency  | read_latency | write_latency     | misc_latency       | count_read | total_read | avg_read   | count_write | total_written | avg_written |
+------------------------+------------+--------------------+-------------+--------------+--------------+-------------------+--------------------+------------+------------+------------+-------------+---------------+-------------+
| innodb/innodb_log_file | 2447961858 | 190624111610588370 |    77870364 | 394448349438 |   1960452780 | 20312281285578282 | 170311828364557308 |          6 |      68096 | 11349.3333 |  1223983245 | 4806358520832 |   3926.8173 |
+------------------------+------------+--------------------+-------------+--------------+--------------+-------------------+--------------------+------------+------------+------------+-------------+---------------+-------------+
x$latest_file_io
x$processlist
+--------+---------+----------+-------+---------+-------+----------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+----------------+------------------------+-----------+-------------------+--------+
| thd_id | conn_id | user     | db    | command | state | time     | current_statement | statement_latency | lock_latency | rows_examined | rows_sent | rows_affected | tmp_tables | tmp_disk_tables | full_scan | last_statement | last_statement_latency | last_wait | last_wait_latency | source |
+--------+---------+----------+-------+---------+-------+----------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+----------------+------------------------+-----------+-------------------+--------+
|      1 |    NULL | sql/main | mysql | NULL    | NULL  | 13366675 | NULL              |              NULL |         NULL |          NULL |      NULL |          NULL |       NULL |            NULL | NO        | NULL           |                   NULL | NULL      | NULL              | NULL   |
+--------+---------+----------+-------+---------+-------+----------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+----------------+------------------------+-----------+-------------------+--------+
x$ps_digest_95th_percentile_by_avg_us
+--------+------------+
| avg_us | percentile |
+--------+------------+
|  34323 |     0.9501 |
+--------+------------+
x$ps_digest_avg_latency_distribution
+-----+--------+
| cnt | avg_us |
+-----+--------+
|  16 |     10 |
+-----+--------+
x$ps_schema_table_statistics_io
+--------------+------------+------------+--------------------------+----------------+-------------+---------------------------+-----------------+------------+----------------+
| table_schema | table_name | count_read | sum_number_of_bytes_read | sum_timer_read | count_write | sum_number_of_bytes_write | sum_timer_write | count_misc | sum_timer_misc |
+--------------+------------+------------+--------------------------+----------------+-------------+---------------------------+-----------------+------------+----------------+
| charsets     | Index      |          1 |                    23500 |      305690528 |           0 |                         0 |               0 |          2 |       44574816 |
+--------------+------------+------------+--------------------------+----------------+-------------+---------------------------+-----------------+------------+----------------+
x$schema_flattened_keys
+--------------+------------+------------+------------+----------------+---------------+
| table_schema | table_name | index_name | non_unique | subpart_exists | index_columns |
+--------------+------------+------------+------------+----------------+---------------+
| heartbeat    | heartbeat  | PRIMARY    |          0 |              0 | server_id     |
+--------------+------------+------------+------------+----------------+---------------+
x$schema_index_statistics
+--------------+----------------+------------------------+---------------+----------------------+---------------+----------------+--------------+----------------+--------------+----------------+
| table_schema | table_name     | index_name             | rows_selected | select_latency       | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
+--------------+----------------+------------------------+---------------+----------------------+---------------+----------------+--------------+----------------+--------------+----------------+
| wikidatawiki | wbt_item_terms | wbt_item_terms_item_id |  588946405484 | 10076703940876603888 |             0 |              0 |            0 |              0 |      4385285 |              0 |
+--------------+----------------+------------------------+---------------+----------------------+---------------+----------------+--------------+----------------+--------------+----------------+
x$schema_table_statistics
+--------------+----------------+----------------------+--------------+----------------------+---------------+-------------------+--------------+----------------+--------------+-----------------+------------------+--------------+-------------------+-------------------+--------------+------------------+------------------+------------------+
| table_schema | table_name     | total_latency        | rows_fetched | fetch_latency        | rows_inserted | insert_latency    | rows_updated | update_latency | rows_deleted | delete_latency  | io_read_requests | io_read      | io_read_latency   | io_write_requests | io_write     | io_write_latency | io_misc_requests | io_misc_latency  |
+--------------+----------------+----------------------+--------------+----------------------+---------------+-------------------+--------------+----------------+--------------+-----------------+------------------+--------------+-------------------+-------------------+--------------+------------------+------------------+------------------+
| wikidatawiki | wbt_item_terms | 10101487365624185960 | 588979311419 | 10078812769026572142 |     188038751 | 21842370465785298 |            0 |              0 |     15925210 | 832226131828520 |         60681622 | 497104939065 | 11676818609986816 |          26569820 | 217659965440 |  372601858848076 |         40251901 | 1318471917827350 |
+--------------+----------------+----------------------+--------------+----------------------+---------------+-------------------+--------------+----------------+--------------+-----------------+------------------+--------------+-------------------+-------------------+--------------+------------------+------------------+------------------+
x$schema_table_statistics_with_buffer
+--------------+----------------+--------------+----------------------+---------------+-------------------+--------------+----------------+--------------+-----------------+------------------+--------------+-------------------+-------------------+--------------+------------------+------------------+------------------+-------------------------+--------------------+--------------------+---------------------+----------------------------+-------------------------+---------------------------+
| table_schema | table_name     | rows_fetched | fetch_latency        | rows_inserted | insert_latency    | rows_updated | update_latency | rows_deleted | delete_latency  | io_read_requests | io_read      | io_read_latency   | io_write_requests | io_write     | io_write_latency | io_misc_requests | io_misc_latency  | innodb_buffer_allocated | innodb_buffer_data | innodb_buffer_free | innodb_buffer_pages | innodb_buffer_pages_hashed | innodb_buffer_pages_old | innodb_buffer_rows_cached |
+--------------+----------------+--------------+----------------------+---------------+-------------------+--------------+----------------+--------------+-----------------+------------------+--------------+-------------------+-------------------+--------------+------------------+------------------+------------------+-------------------------+--------------------+--------------------+---------------------+----------------------------+-------------------------+---------------------------+
| wikidatawiki | wbt_item_terms | 588979338632 | 10078812930563136760 |     188038754 | 21842370637965592 |            0 |              0 |     15925210 | 832226131828520 |         60681626 | 497104971833 | 11676819361861368 |          26569820 | 217659965440 |  372601858848076 |         40251901 | 1318471917827350 |             22111100928 |        30950957581 |        -8839856653 |             2699109 |                    2699109 |                 2699109 |                 356137881 |
+--------------+----------------+--------------+----------------------+---------------+-------------------+--------------+----------------+--------------+-----------------+------------------+--------------+-------------------+-------------------+--------------+------------------+------------------+------------------+-------------------------+--------------------+--------------------+---------------------+----------------------------+-------------------------+---------------------------+
x$schema_tables_with_full_table_scans
+---------------+---------------------+-------------------+-------------------+
| object_schema | object_name         | rows_full_scanned | latency           |
+---------------+---------------------+-------------------+-------------------+
| wikidatawiki  | wb_changes_dispatch |       42477749989 | 29326749949732664 |
+---------------+---------------------+-------------------+-------------------+
x$session
+------------+-----------+----------------------+--------------------+---------+-------+------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+-----------+-------------------+--------+
| thd_id     | conn_id   | user                 | db                 | command | state | time | current_statement | statement_latency | lock_latency | rows_examined | rows_sent | rows_affected | tmp_tables | tmp_disk_tables | full_scan | last_statement                                                                                                                                                                                                                                                                                                                                                                                                                                        | last_statement_latency | last_wait | last_wait_latency | source |
+------------+-----------+----------------------+--------------------+---------+-------+------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+-----------+-------------------+--------+
| 4736178362 | 614709641 | watchdog@10.64.0.122 | information_schema | Sleep   | NULL  | 3135 | NULL              |              NULL |    121000000 |             0 |         0 |             0 |          1 |               0 | YES       | SELECT `USER`, `TOTAL_CONNECTIONS`, `CONCURRENT_CONNECTIONS`, `CONNECTED_TIME`, `BUSY_TIME`, `CPU_TIME`, `BYTES_RECEIVED`, `BYTES_SENT`, `BINLOG_BYTES_WRITTEN`, `ROWS_READ`, `ROWS_SENT`, `ROWS_DELETED`, `ROWS_INSERTED`, `ROWS_UPDATED`, `SELECT_COMMANDS`, `UPDATE_COMMANDS`, `OTHER_COMMANDS`, `COMMIT_TRANSACTIONS`, `ROLLBACK_TRANSACTIONS`, `DENIED_CONNECTIONS`, `LOST_CONNECTIONS`, `ACCESS_DENIED`, `EMPTY_QUERIES` FROM `USER_STATISTICS` |              263789000 | NULL      | NULL              | NULL   |
+------------+-----------+----------------------+--------------------+---------+-------+------+-------------------+-------------------+--------------+---------------+-----------+---------------+------------+-----------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+-----------+-------------------+--------+
x$statement_analysis
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------------+--------------+-------------+--------------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
| query                                                                                                                                                                                                                                                                                                                                                                             | db           | full_scan | exec_count | err_count | warn_count | total_latency       | max_latency  | avg_latency | lock_latency       | rows_sent  | rows_sent_avg | rows_examined | rows_examined_avg | rows_affected | rows_affected_avg | tmp_tables | tmp_disk_tables | rows_sorted | sort_merge_passes | digest                           | first_seen          | last_seen           |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------------+--------------+-------------+--------------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
| SELECT `wbtl_id` , `wbtl_type_id` , `wbxl_language` , `wbx_text` , `wbit_item_id` FROM `wbt_term_in_lang` JOIN `wbt_text_in_lang` ON ( ( `wbtl_text_in_lang_id` = `wbxl_id` ) ) JOIN `wbt_text` ON ( ( `wbxl_text_id` = `wbx_id` ) ) JOIN `wbt_item_terms` ON ( ( `wbit_term_in_lang_id` = `wbtl_id` ) ) WHERE `wbit_item_id` = ? AND `wbtl_type_id` = ? AND `wbxl_language` = ?  | wikidatawiki |           | 2581390369 |         0 |          0 | 8473664548645985000 | 628425984000 |  3282597000 | 212074572782000000 | 1390362225 |             1 |  382310359162 |               148 |             0 |                 0 |          0 |               0 |           0 |                 0 | e6710becca6f731f082ec61199fa2f7d | 2021-06-14 11:32:22 | 2021-09-07 06:04:15 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------------+--------------+-------------+--------------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
x$statements_with_errors_or_warnings
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------+-----------+----------+-------------+---------------------+---------------------+----------------------------------+
| query                                                                                                                                                                                              | db           | exec_count | errors | error_pct | warnings | warning_pct | first_seen          | last_seen           | digest                           |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------+-----------+----------+-------------+---------------------+---------------------+----------------------------------+
| SELECT `page_id` , `page_len` , `page_is_redirect` , `page_latest` , `page_restrictions` , `page_content_model` , `page_lang` FROM `page` WHERE `page_namespace` = ? AND `page_title` = ? LIMIT ?  | wikidatawiki | 1378249222 |   2654 |    0.0002 |        0 |      0.0000 | 2021-04-05 13:04:50 | 2021-09-07 06:04:16 | 8d06129ff0b06526429e6fa04681c977 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------+-----------+----------+-------------+---------------------+---------------------+----------------------------------+
x$statements_with_full_table_scans
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------------------+---------------------+--------------------------+-------------------+------------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| query                                                                                                                                                                         | db           | exec_count | total_latency      | no_index_used_count | no_good_index_used_count | no_index_used_pct | rows_sent  | rows_examined | rows_sent_avg | rows_examined_avg | first_seen          | last_seen           | digest                           |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------------------+---------------------+--------------------------+-------------------+------------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| SELECT TIMESTAMPDIFF ( MICROSECOND , `ts` , UTC_TIMESTAMP (?) ) AS `us_ago` FROM `heartbeat` . `heartbeat` WHERE `shard` = ? AND `datacenter` = ? ORDER BY `ts` DESC LIMIT ?  | wikidatawiki | 4189487330 | 812907635242744000 |          4191895501 |                        0 |               100 | 4190171875 |    8482649402 |             1 |                 2 | 2021-05-05 19:19:33 | 2021-09-07 06:04:16 | 752ffd44d554202978a146a0b714dd21 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------------------+---------------------+--------------------------+-------------------+------------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
x$statements_with_runtimes_in_95th_percentile
+------------------------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+-------------------+-------------------+-------------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| query                                                                              | db           | full_scan | exec_count | err_count | warn_count | total_latency     | max_latency       | avg_latency       | rows_sent | rows_sent_avg | rows_examined | rows_examined_avg | first_seen          | last_seen           | digest                           |
+------------------------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+-------------------+-------------------+-------------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
| CREATE UNIQUE INDEX `page_name_title` ON PAGE ( `page_namespace` , `page_title` )  | wikidatawiki |           |          1 |         0 |          0 | 14855162304328000 | 14855162304328000 | 14855162304328000 |         0 |             0 |             0 |                 0 | 2021-06-15 09:02:50 | 2021-06-15 09:02:50 | 4cedbd9c825e94867ad9896d37837c09 |
+------------------------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+-------------------+-------------------+-------------------+-----------+---------------+---------------+-------------------+---------------------+---------------------+----------------------------------+
x$statements_with_sorting
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------------------+-------------------+-----------------+-------------------+------------------+-------------+-----------------+---------------------+---------------------+----------------------------------+
| query                                                                                                                                                                         | db           | exec_count | total_latency      | sort_merge_passes | avg_sort_merges | sorts_using_scans | sort_using_range | rows_sorted | avg_rows_sorted | first_seen          | last_seen           | digest                           |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------------------+-------------------+-----------------+-------------------+------------------+-------------+-----------------+---------------------+---------------------+----------------------------------+
| SELECT TIMESTAMPDIFF ( MICROSECOND , `ts` , UTC_TIMESTAMP (?) ) AS `us_ago` FROM `heartbeat` . `heartbeat` WHERE `shard` = ? AND `datacenter` = ? ORDER BY `ts` DESC LIMIT ?  | wikidatawiki | 4189491406 | 812908372739530000 |                 0 |               0 |        4191898880 |                0 |  4191903041 |               1 | 2021-05-05 19:19:33 | 2021-09-07 06:04:22 | 752ffd44d554202978a146a0b714dd21 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+--------------------+-------------------+-----------------+-------------------+------------------+-------------+-----------------+---------------------+---------------------+----------------------------------+
x$statements_with_temp_tables
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+-------------------+-------------------+-----------------+--------------------------+------------------------+---------------------+---------------------+----------------------------------+
| query                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | db           | exec_count | total_latency     | memory_tmp_tables | disk_tmp_tables | avg_tmp_tables_per_query | tmp_tables_to_disk_pct | first_seen          | last_seen           | digest                           |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+-------------------+-------------------+-----------------+--------------------------+------------------------+---------------------+---------------------+----------------------------------+
| SELECT * FROM ( SELECT `rev_id` , `rev_page` , `rev_timestamp` , `rev_minor_edit` , `rev_deleted` , `rev_len` , `rev_parent_id` , `rev_sha1` , `comment_rev_comment` . `comment_text` AS `rev_comment_text` , `comment_rev_comment` . `comment_data` AS `rev_comment_data` , `comment_rev_comment` . `comment_id` AS `rev_comment_cid` , `actor_rev_user` . `actor_user` AS `rev_user` , `actor_rev_user` . `actor_name` AS `rev_user_text` , `temp_rev_user` . `revactor_actor` AS `rev_actor` FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ( ( `temp_rev_comment` . `revcomment_rev` = `rev_id` ) ) JOIN `comment` `comment_rev_comment` ON ( ( `comment_rev_comment` . `comment_id` = `temp_rev_comment` . `revcomment_comment_id` ) ) JOIN `revision_actor_temp` `temp_rev_user` ON ( ( `temp_rev_user` . `revactor_rev` = `rev_id` ) ) JOIN `actor` `actor_rev_user` ON ( ( `actor_rev_user` . `actor_id` = `temp_rev_user` . `revactor_actor` ) ) WHERE `rev_page` = ? ORDER BY `rev_timestamp` DESC , `rev_id` DESC LIMIT ?, ... )  | wikidatawiki |    3132142 | 14181847022689000 |           3132121 |         3132104 |                        1 |                    100 | 2021-08-04 19:10:22 | 2021-09-07 06:04:19 | b70092435539822140e993e99673656b |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+------------+-------------------+-------------------+-----------------+--------------------------+------------------------+---------------------+---------------------+----------------------------------+
x$user_summary
+------------+------------+--------------------+-----------------------+-------------+------------+--------------------+---------------------+-------------------+--------------+
| user       | statements | statement_latency  | statement_avg_latency | table_scans | file_ios   | file_io_latency    | current_connections | total_connections | unique_hosts |
+------------+------------+--------------------+-----------------------+-------------+------------+--------------------+---------------------+-------------------+--------------+
| background | 2382345005 | 670469063528592000 |        281432396.2824 |        4170 | 8828320833 | 345153868112613560 |                 219 |           4632895 |            0 |
+------------+------------+--------------------+-----------------------+-------------+------------+--------------------+---------------------+-------------------+--------------+
x$user_summary_by_file_io
+------------+------------+--------------------+
| user       | ios        | io_latency         |
+------------+------------+--------------------+
| background | 8828320994 | 345153877245473296 |
+------------+------------+--------------------+
x$user_summary_by_file_io_type
+------------+-------------------------------------+------------+--------------------+--------------+
| user       | event_name                          | total      | latency            | max_latency  |
+------------+-------------------------------------+------------+--------------------+--------------+
| background | wait/io/file/innodb/innodb_log_file | 2447983545 | 190631717588664352 | 394448349438 |
+------------+-------------------------------------+------------+--------------------+--------------+
x$user_summary_by_stages
x$user_summary_by_statement_latency
+----------+-------------+----------------------+----------------+---------------------+-------------+---------------+---------------+------------+
| user     | total       | total_latency        | max_latency    | lock_latency        | rows_sent   | rows_examined | rows_affected | full_scans |
+----------+-------------+----------------------+----------------+---------------------+-------------+---------------+---------------+------------+
| wikiuser | 59422192975 | 11909536870766784384 | 93218201458000 | 2385663020671000000 | 91322217657 | 1858924153789 |             0 | 4743139217 |
+----------+-------------+----------------------+----------------+---------------------+-------------+---------------+---------------+------------+
x$user_summary_by_statement_type
+------------+-----------+------------+--------------------+--------------+-------------------+-----------+---------------+---------------+------------+
| user       | statement | total      | total_latency      | max_latency  | lock_latency      | rows_sent | rows_examined | rows_affected | full_scans |
+------------+-----------+------------+--------------------+--------------+-------------------+-----------+---------------+---------------+------------+
| background | insert    | 1251366101 | 291343617180337000 | 661093086000 | 55082762278000000 |         0 |             0 |             0 |          0 |
+------------+-----------+------------+--------------------+--------------+-------------------+-----------+---------------+---------------+------------+
x$wait_classes_global_by_avg_latency
+--------------+------------+--------------------+-------------+---------------+---------------+
| event_class  | total      | total_latency      | min_latency | avg_latency   | max_latency   |
+--------------+------------+--------------------+-------------+---------------+---------------+
| wait/io/file | 9225985961 | 409309640481671358 |           0 | 44364867.0410 | 1609620821094 |
+--------------+------------+--------------------+-------------+---------------+---------------+
x$wait_classes_global_by_latency
+---------------+---------------+---------------------+-------------+-------------+---------------+
| event_class   | total         | total_latency       | min_latency | avg_latency | max_latency   |
+---------------+---------------+---------------------+-------------+-------------+---------------+
| wait/io/table | 1884333560087 | 1588447596111041936 |       44330 | 842975.8031 | 1640202289440 |
+---------------+---------------+---------------------+-------------+-------------+---------------+
x$waits_by_host_by_latency
+--------------+---------------------------+-----------+------------------+-------------+-------------+
| host         | event                     | total     | total_latency    | avg_latency | max_latency |
+--------------+---------------------------+-----------+------------------+-------------+-------------+
| 10.192.0.113 | wait/io/table/sql/handler | 666101304 | 5063751130041032 |     7601880 | 41315661530 |
+--------------+---------------------------+-----------+------------------+-------------+-------------+
x$waits_by_user_by_latency
+--------+---------------------------+---------+----------------+-------------+--------------+
| user   | event                     | total   | total_latency  | avg_latency | max_latency  |
+--------+---------------------------+---------+----------------+-------------+--------------+
| nagios | wait/io/table/sql/handler | 5209385 | 13578467868966 |     2606318 | 157548807988 |
+--------+---------------------------+---------+----------------+-------------+--------------+
x$waits_global_by_latency
+---------------------------+---------------+---------------------+-------------+---------------+
| events                    | total         | total_latency       | avg_latency | max_latency   |
+---------------------------+---------------+---------------------+-------------+---------------+
| wait/io/table/sql/handler | 1884333953747 | 1588451839446362732 |    10632336 | 1640202289440 |
+---------------------------+---------------+---------------------+-------------+---------------+