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 | inventory | 5205954864 | 78 | 5205954864 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4175313120 | 0 | 0 | 0 | 5 | 2073963936 | |
test19 | pilote | 4932694272 | 4 | 4932694272 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4942104816 | 0 | 0 | 0 | 5 | 125670864 | |
sakila | customer | 4741445808 | 106 | 4741445808 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5041717824 | 0 | 0 | 0 | 5 | 50071296 | |
sakila | country | 4638652128 | 156 | 4638652128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4046154288 | 0 | 0 | 0 | 5 | 46886400 | |
sakila | film | 3047536272 | 359 | 3047536272 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3849381888 | 0 | 0 | 0 | 5 | 57806496 | |
world | Country | 3038565024 | 4 | 3038565024 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 2188441200 | 0 | 0 | 0 | 6 | 132360096 | |
sakila | payment | 2849795520 | 3 | 2849795520 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 7911577344 | 0 | 0 | 0 | 5 | 18891241248 | |
sakila | staff | 2601992976 | 14 | 2601992976 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2442634656 | 0 | 0 | 0 | 5 | 58052016 | |
sakila | city | 2403280176 | 130 | 2403280176 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1864684272 | 0 | 0 | 0 | 5 | 74238912 | |
sakila | film_actor | 2383784832 | 3 | 2383784832 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 7884307728 | 0 | 0 | 0 | 5 | 25815504 | |
sakila | rental | 2307972480 | 4 | 2307972480 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 8808989904 | 0 | 0 | 0 | 5 | 32559648 | |
sakila | address | 2098049184 | 361 | 2098049184 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1452248688 | 0 | 0 | 0 | 5 | 38567760 | |
sakila | language | 1618852224 | 171 | 1618852224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1106431392 | 0 | 0 | 0 | 5 | 68712864 | |
sakila | actor | 1385049072 | 576 | 1385049072 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1367949792 | 0 | 0 | 0 | 5 | 40531920 | |
sys | sys_config | 1234157760 | 10 | 1234157760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 630663264 | 0 | 0 | 0 | 5 | 744142608 | |
sakila | store | 1188385440 | 17 | 1188385440 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1061919936 | 0 | 0 | 0 | 5 | 94901664 | |
vedettfak | megye | 955530576 | 47 | 955530576 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 848904672 | 0 | 0 | 0 | 5 | 232847472 | |
test19 | ecurie | 820258560 | 4 | 820258560 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 972495744 | 0 | 0 | 0 | 5 | 58917936 | |
test19 | voiture | 729184896 | 3 | 729184896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 935406912 | 0 | 0 | 0 | 5 | 46790832 | |
Husan Preet Singh | Products | 248596656 | 0 | 0 | 15 | 248596656 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Husan Preet Singh | Suppliers | 189006048 | 0 | 0 | 4 | 189006048 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | fa | 174115392 | 9 | 174115392 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 1647535824 | 0 | 0 | 0 | 5 | 607896960 | |
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 |
|