SELECT * FROM `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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
INFS1200_RELEASE | Policy | 11594369424 | 105 | 11594369424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1423029168 | 0 | 0 | 0 | 5 | 9858320736 | |
INFS1200_RELEASE | Address | 2578684416 | 336 | 2578684416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 440514096 | 0 | 0 | 0 | 5 | 362607168 | |
sakila | language | 2383881456 | 421 | 2383881456 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 488009280 | 0 | 0 | 0 | 5 | 88539264 | |
sakila | film | 2357144064 | 299 | 2357144064 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2226037440 | 0 | 0 | 0 | 5 | 70663824 | |
sakila | film_category | 2241745440 | 3 | 2241745440 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2077876416 | 0 | 0 | 0 | 5 | 54098352 | |
INFS1200_RELEASE | Customer | 1837113696 | 133 | 1837113696 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 386807520 | 0 | 0 | 0 | 5 | 275542608 | |
sys | sys_config | 1752217632 | 2 | 1752217632 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 407570064 | 0 | 0 | 0 | 5 | 93103824 | |
INFS1200_RELEASE | Vehicle | 1719219744 | 70 | 1719219744 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1084374192 | 0 | 0 | 0 | 5 | 184919856 | |
sakila | category | 1238110896 | 81 | 1238110896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 473283360 | 0 | 0 | 0 | 5 | 338807040 | |
sakila | customer | 1173144720 | 26 | 1173144720 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 922061712 | 0 | 0 | 0 | 5 | 19692816 | |
sakila | address | 896561952 | 53 | 896561952 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 742748688 | 0 | 0 | 0 | 5 | 19643712 | |
sakila | city | 769011936 | 35 | 769011936 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 620766960 | 0 | 0 | 0 | 5 | 22836528 | |
sakila | country | 430827936 | 10 | 430827936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 342223200 | 0 | 0 | 0 | 5 | 40724640 | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | memory_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_statistics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|