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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Table_insertion | pilote | 10479403968 | 3 | 10479403968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3836962272 | 0 | 0 | 0 | 5 | 111117072 | |
sakila | actor | 6104346864 | 81 | 6104346864 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5340159264 | 0 | 0 | 0 | 5 | 122168640 | |
Table_insertion | ecurie | 4243363344 | 3 | 4243363344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4374886032 | 0 | 0 | 0 | 5 | 54683376 | |
sys | sys_config | 1818789984 | 60 | 1818789984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 852329280 | 0 | 0 | 0 | 5 | 53633712 | |
sakila | film | 1163177136 | 53 | 1163177136 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3002366928 | 0 | 0 | 0 | 5 | 30283968 | |
sakila | country | 971871120 | 77 | 971871120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 849471744 | 0 | 0 | 0 | 5 | 85306320 | |
sakila | inventory | 780855504 | 26 | 780855504 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3167682144 | 0 | 0 | 0 | 5 | 25417920 | |
sakila | city | 720731088 | 51 | 720731088 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3293440656 | 0 | 0 | 0 | 5 | 29344128 | |
sakila | address | 478467792 | 26 | 478467792 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3861279840 | 0 | 0 | 0 | 5 | 43159776 | |
sakila | language | 145094400 | 25 | 145094400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 936264384 | 0 | 0 | 0 | 5 | 22967472 | |
Ristorante | Menu | 79996224 | 0 | 0 | 9 | 79996224 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 367793184 | 6 | 70934577648 | |
Ristorante | IngredientiPortata | 64479360 | 0 | 0 | 16 | 64479360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 247095024 | 6 | 64414907040 | |
Ristorante | Cliente | 54435744 | 0 | 0 | 5 | 54435744 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 484557744 | 6 | 81722264976 | |
vedettfak | fa | 52797888 | 1 | 52797888 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4243264080 | 0 | 0 | 0 | 5 | 710274048 | |
world | CountryLanguage | 46810368 | 1 | 46810368 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 407 | 404704080 | 0 | 0 | 0 | 4 | 33260832 | |
test19 | pilote | 42532512 | 3 | 42532512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 987813552 | 0 | 0 | 0 | 5 | 43671936 | |
world | City | 21901440 | 1 | 21901440 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 279365328 | 0 | 0 | 0 | 5 | 31154640 | |
test19 | ecurie | 17704368 | 1 | 17704368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1729893792 | 0 | 0 | 0 | 5 | 143752224 | |
sku | Attore | 16623024 | 1 | 16623024 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1021308288 | 0 | 0 | 0 | 5 | 46599168 | |
world | Country | 14408592 | 1 | 14408592 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 346290384 | 0 | 0 | 0 | 5 | 35592480 | |
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 |
|