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 | payment | 156266225280 | 32088 | 156266225280 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 47651229120 | 0 | 0 | 0 | 5 | 43475520 | |
sakila | rental | 41234666880 | 41250 | 41234666880 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 20540990448 | 0 | 0 | 0 | 5 | 47500464 | |
sakila | city | 28650305904 | 306 | 28650305904 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 25673908656 | 0 | 0 | 0 | 5 | 2238030432 | |
sakila | country | 22389329952 | 56 | 22389329952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 22221054768 | 0 | 0 | 0 | 5 | 72638016 | |
sakila | inventory | 11049576384 | 9192 | 11049576384 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 10163602944 | 0 | 0 | 0 | 5 | 60347232 | |
sakila | customer | 4248492864 | 2 | 4248492864 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4362729888 | 0 | 0 | 0 | 5 | 44198352 | |
Table_insertion | pilote | 4002705168 | 26 | 4002705168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4191633600 | 0 | 0 | 0 | 5 | 43290192 | |
sakila | staff | 2498904144 | 7 | 2498904144 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1962768192 | 0 | 0 | 0 | 5 | 516546624 | |
sakila | address | 2068410432 | 88 | 2068410432 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2248181760 | 0 | 0 | 0 | 5 | 26351424 | |
sakila | film | 1567431888 | 103 | 1567431888 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1890488160 | 0 | 0 | 0 | 5 | 41091072 | |
sakila | language | 1199933856 | 75 | 1199933856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 888072240 | 0 | 0 | 0 | 5 | 52178016 | |
Table_insertion | ecurie | 800988144 | 2 | 800988144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 839276592 | 0 | 0 | 0 | 5 | 248888640 | |
sys | sys_config | 764114208 | 7 | 764114208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1085266512 | 0 | 0 | 0 | 5 | 68663232 | |
sakila | store | 450819600 | 6 | 450819600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 576840000 | 0 | 0 | 0 | 5 | 26253216 | |
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 |
|