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 | customer | 13972706352 | 56 | 13972706352 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 15824977344 | 0 | 0 | 0 | 5 | 57312816 | |
sakila | film_actor | 4668779280 | 2 | 4668779280 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2825881344 | 0 | 0 | 0 | 5 | 1984144800 | |
sakila | city | 4388635152 | 105 | 4388635152 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4371486240 | 0 | 0 | 0 | 5 | 53681760 | |
sakila | address | 3298193712 | 52 | 3298193712 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2991013344 | 0 | 0 | 0 | 5 | 40436880 | |
sakila | country | 2392677936 | 56 | 2392677936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2411618352 | 0 | 0 | 0 | 5 | 57857712 | |
sakila | film | 1387385472 | 30 | 1387385472 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1961146704 | 0 | 0 | 0 | 5 | 43261680 | |
sakila | store | 1110086208 | 2 | 1110086208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 854107056 | 0 | 0 | 0 | 5 | 415976880 | |
sku | Attore | 966670848 | 4 | 966670848 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 852224736 | 0 | 0 | 0 | 5 | 47949264 | |
sakila | language | 905893824 | 32 | 905893824 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 843958368 | 0 | 0 | 0 | 5 | 62500944 | |
sakila | category | 839588640 | 6 | 839588640 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 966797040 | 0 | 0 | 0 | 5 | 42950160 | |
test19 | voiture | 686809200 | 1 | 686809200 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 849039312 | 0 | 0 | 0 | 5 | 36104640 | |
sakila | actor | 645056016 | 4 | 645056016 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 808522176 | 0 | 0 | 0 | 5 | 33732864 | |
vedettfak | fa | 77947584 | 1 | 77947584 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 1805436864 | 0 | 0 | 0 | 5 | 266437776 | |
test19 | pilote | 18450432 | 1 | 18450432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4058137776 | 0 | 0 | 0 | 5 | 44432784 | |
test19 | ecurie | 18179568 | 1 | 18179568 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2521466640 | 0 | 0 | 0 | 5 | 2087012928 | |
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 |
|