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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Stefano | vulcano | 4177907712 | 2 | 4177907712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4451923344 | 0 | 0 | 0 | 5 | 59330832 | |
sku | Attore | 3953974992 | 2 | 3953974992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4094436720 | 0 | 0 | 0 | 5 | 36358608 | |
test19 | pilote | 3903700416 | 28 | 3903700416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4129597824 | 0 | 0 | 0 | 5 | 39018144 | |
sakila | film | 3602658576 | 57 | 3602658576 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4285642416 | 0 | 0 | 0 | 5 | 40983888 | |
sakila | staff | 1864141488 | 2 | 1864141488 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1938206688 | 0 | 0 | 0 | 5 | 57955920 | |
test19 | voiture | 1842197808 | 2 | 1842197808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2072794416 | 0 | 0 | 0 | 5 | 43351440 | |
sakila | language | 1128870336 | 122 | 1128870336 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 891630960 | 0 | 0 | 0 | 5 | 33262416 | |
sakila | inventory | 1094052432 | 1 | 1094052432 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1264967088 | 0 | 0 | 0 | 5 | 50138880 | |
sakila | film_category | 1085942352 | 4 | 1085942352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1074983184 | 0 | 0 | 0 | 5 | 73412064 | |
sakila | customer | 967153440 | 2 | 967153440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1087369536 | 0 | 0 | 0 | 5 | 49856400 | |
Table_insertion | voiture | 677635728 | 2 | 677635728 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 840078096 | 0 | 0 | 0 | 5 | 45764400 | |
sakila | film_text | 610281408 | 26 | 610281408 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 865768992 | 0 | 0 | 0 | 32 | 50112480 | |
sakila | actor | 73965936 | 3 | 73965936 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1340128944 | 0 | 0 | 0 | 5 | 54115776 | |
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 |
|