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 | store | 15178545888 | 8 | 15178545888 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1341896160 | 0 | 0 | 0 | 5 | 86578800 | |
Table_insertion | voiture | 12024795552 | 4 | 12024795552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 12125776608 | 0 | 0 | 0 | 5 | 55328592 | |
test19 | ecurie | 3879753504 | 2 | 3879753504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4086811872 | 0 | 0 | 0 | 5 | 37638480 | |
sakila | customer | 3614700144 | 89 | 3614700144 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 4084252128 | 0 | 0 | 0 | 5 | 34064448 | |
sakila | city | 2810251488 | 30 | 2810251488 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3567321648 | 0 | 0 | 0 | 5 | 22569888 | |
vedettfak | megye | 2344538592 | 2 | 2344538592 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2695946352 | 0 | 0 | 0 | 5 | 40367184 | |
sakila | rental | 1938348192 | 2 | 1938348192 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 15905981520 | 0 | 0 | 0 | 5 | 39255744 | |
sakila | address | 1842895824 | 77 | 1842895824 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2084676000 | 0 | 0 | 0 | 5 | 24126432 | |
sakila | inventory | 1357930992 | 3 | 1357930992 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2223471888 | 0 | 0 | 0 | 5 | 42238416 | |
test19 | pilote | 1327858224 | 5 | 1327858224 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1157733456 | 0 | 0 | 0 | 5 | 420809136 | |
sakila | film | 1284372144 | 278 | 1284372144 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1539304272 | 0 | 0 | 0 | 5 | 36381312 | |
sakila | actor | 1265394240 | 116 | 1265394240 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1083923280 | 0 | 0 | 0 | 5 | 35728176 | |
sakila | language | 1255846416 | 80 | 1255846416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 814323312 | 0 | 0 | 0 | 5 | 42718896 | |
sakila | country | 953306112 | 27 | 953306112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 852640800 | 0 | 0 | 0 | 5 | 38906736 | |
Stefano | vulcano | 645765648 | 2 | 645765648 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 908134128 | 0 | 0 | 0 | 5 | 47744928 | |
world | CountryLanguage | 559190016 | 26 | 559190016 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 1256144736 | 0 | 0 | 0 | 6 | 38241984 | |
SKY | Users | 264937728 | 0 | 0 | 3 | 264937728 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 293949744 | 7 | 83789831136 | |
SKY | Orders | 199555488 | 0 | 0 | 3 | 199555488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 393152496 | 8 | 99632794272 | |
sakila | category | 61869984 | 18 | 61869984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 824616144 | 0 | 0 | 0 | 5 | 43039920 | |
world | Country | 27995616 | 2 | 27995616 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 393977760 | 0 | 0 | 0 | 6 | 33890208 | |
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 |
|