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 | 40203568416 | 130 | 40203568416 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3159636480 | 0 | 0 | 0 | 5 | 600378768 | |
sakila | address | 4436643552 | 51 | 4436643552 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4748112336 | 0 | 0 | 0 | 5 | 57057264 | |
sakila | customer | 1966823232 | 51 | 1966823232 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1825498224 | 0 | 0 | 0 | 5 | 39205584 | |
sakila | city | 1706365056 | 52 | 1706365056 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1588715568 | 0 | 0 | 0 | 5 | 59131248 | |
sakila | language | 1641546720 | 125 | 1641546720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 903506208 | 0 | 0 | 0 | 5 | 64642512 | |
sakila | rental | 1357268880 | 26 | 1357268880 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 13369171728 | 0 | 0 | 0 | 5 | 38354448 | |
sku | Attore | 1029053520 | 2 | 1029053520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 836567424 | 0 | 0 | 0 | 5 | 47818320 | |
sakila | country | 954935520 | 51 | 954935520 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 948935856 | 0 | 0 | 0 | 5 | 48278208 | |
sakila | staff | 932054640 | 25 | 932054640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 942786768 | 0 | 0 | 0 | 5 | 30498336 | |
TlapaleriaMalfoy | Registro | 871461360 | 5 | 871461360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 912076704 | 0 | 0 | 0 | 5 | 274537824 | |
sys | sys_config | 831181296 | 4 | 831181296 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1054588128 | 0 | 0 | 0 | 5 | 47334672 | |
world | Country | 35180112 | 2 | 35180112 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 462597696 | 0 | 0 | 0 | 5 | 25773264 | |
world | CountryLanguage | 19229232 | 2 | 19229232 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 391554768 | 0 | 0 | 0 | 4 | 25674528 | |
sakila | category | 14971440 | 1 | 14971440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1086433392 | 0 | 0 | 0 | 5 | 43208880 | |
world | City | 14582304 | 2 | 14582304 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 1203684768 | 0 | 0 | 0 | 5 | 27883152 | |
performance_schema | events_statements_summary_by_digest | 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 | |
students | record 2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_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 | events_transactions_summary_by_host_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
StdMdDB | score | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2309319408 | 0 | 0 | 0 | 5 | 319093632 | |
performance_schema | events_statements_current | 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 |
|