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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film | 2722024800 | 53 | 2722024800 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3197289744 | 0 | 0 | 0 | 5 | 57239424 | |
sku | Attore | 2010541104 | 15 | 2010541104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1603789968 | 0 | 0 | 0 | 5 | 47820432 | |
sakila | language | 1192702368 | 50 | 1192702368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 947824416 | 0 | 0 | 0 | 5 | 62308752 | |
sys | sys_config | 118231872 | 4 | 118231872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1057671648 | 0 | 0 | 0 | 5 | 55460592 | |
pw | usuario | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1483183680 | 0 | 0 | 0 | 5 | 44044176 | |
sku | Programmato | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 857322576 | 0 | 0 | 0 | 5 | 25163424 | |
sku | Interpreta | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 998600592 | 0 | 0 | 0 | 5 | 59253744 | |
sku | Cinema | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2020518192 | 0 | 0 | 0 | 5 | 46741728 | |
sku | Film | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2400925824 | 0 | 0 | 0 | 5 | 53777328 | |
mysql | parameters | 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 | |
performance_schema | file_summary_by_instance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
pw | estudio | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4119290736 | 0 | 0 | 0 | 5 | 37266240 | |
pw | idioma | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4215188208 | 0 | 0 | 0 | 5 | 52608864 | |
performance_schema | threads | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
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 | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 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 | 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 | |
performance_schema | session_variables | 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 | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|