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 | language | 4682247504 | 146 | 4682247504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3738612768 | 0 | 0 | 0 | 5 | 52744032 | |
sakila | address | 4676850816 | 57 | 4676850816 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5467591536 | 0 | 0 | 0 | 5 | 34788864 | |
test19 | pilote | 4241030640 | 3 | 4241030640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2634502992 | 0 | 0 | 0 | 5 | 1902478512 | |
sakila | film | 3482159472 | 237 | 3482159472 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 344064 | 5130404400 | 0 | 0 | 0 | 5 | 89810160 | |
vedettfak | fa | 2929650768 | 3 | 2929650768 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4833049584 | 0 | 0 | 0 | 5 | 433851264 | |
sakila | city | 2002491744 | 380 | 2002491744 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1365001968 | 0 | 0 | 0 | 5 | 35550768 | |
sakila | country | 1753324848 | 151 | 1753324848 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 977161680 | 0 | 0 | 0 | 5 | 38029728 | |
sys | sys_config | 653367792 | 6 | 653367792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 719357760 | 0 | 0 | 0 | 5 | 48342624 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_keys | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | indexes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_partition_values | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | triggers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | view_routine_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|