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 | 274231168992 | 160443 | 274231168992 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 12781187232 | 0 | 0 | 0 | 5 | 42363552 | |
sakila | rental | 74256121632 | 206250 | 74256121632 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 12055883136 | 0 | 0 | 0 | 5 | 61149792 | |
sakila | inventory | 11007385488 | 45858 | 11007385488 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 6092011200 | 0 | 0 | 0 | 5 | 54907776 | |
sakila | city | 6934462128 | 97 | 6934462128 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 6789832896 | 0 | 0 | 0 | 5 | 51170592 | |
sakila | staff | 4897226400 | 23 | 4897226400 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 4819033824 | 0 | 0 | 0 | 5 | 38737248 | |
sakila | store | 4607973744 | 30 | 4607973744 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4554557040 | 0 | 0 | 0 | 5 | 60929088 | |
sakila | actor | 2797821312 | 28 | 2797821312 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2877054048 | 0 | 0 | 0 | 5 | 36458928 | |
world | CountryLanguage | 2670409104 | 38 | 2670409104 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 4001288016 | 0 | 0 | 0 | 11 | 98714880 | |
vedettfak | fa | 2188075824 | 4 | 2188075824 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2333847120 | 0 | 0 | 0 | 5 | 49291968 | |
sakila | address | 1987922640 | 183 | 1987922640 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2027811456 | 0 | 0 | 0 | 5 | 96653568 | |
sakila | film | 1732973616 | 181 | 1732973616 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1779364752 | 0 | 0 | 0 | 5 | 32456160 | |
sakila | language | 1703388192 | 154 | 1703388192 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 904070640 | 0 | 0 | 0 | 5 | 43208880 | |
sakila | country | 1620663264 | 125 | 1620663264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1269812544 | 0 | 0 | 0 | 5 | 64779792 | |
Stefano | vulcano | 1331990352 | 19 | 1331990352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1325813808 | 0 | 0 | 0 | 5 | 35024352 | |
sakila | customer | 1068906432 | 7 | 1068906432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1136553792 | 0 | 0 | 0 | 5 | 40732560 | |
sakila | category | 930690816 | 21 | 930690816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1005634080 | 0 | 0 | 0 | 5 | 50709648 | |
test19 | voiture | 849439008 | 3 | 849439008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1051913808 | 0 | 0 | 0 | 5 | 37197072 | |
vedettfak | megye | 847616352 | 4 | 847616352 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1091784672 | 0 | 0 | 0 | 5 | 37041312 | |
sys | sys_config | 677350608 | 16 | 677350608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 721574304 | 0 | 0 | 0 | 5 | 47980944 | |
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 |
|