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 | 182163711840 | 96265 | 182163711840 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 15265134192 | 0 | 0 | 0 | 5 | 34137840 | |
sakila | rental | 46068289872 | 123754 | 46068289872 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 8153203872 | 0 | 0 | 0 | 5 | 96968256 | |
sakila | inventory | 8311553184 | 27498 | 8311553184 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 4985412432 | 0 | 0 | 0 | 5 | 32539584 | |
Stefano | vulcano | 4293282048 | 4 | 4293282048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4549175136 | 0 | 0 | 0 | 5 | 36716592 | |
sakila | staff | 4029879744 | 22 | 4029879744 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3923478240 | 0 | 0 | 0 | 5 | 35072400 | |
sakila | city | 4024499952 | 14 | 4024499952 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 4115641728 | 0 | 0 | 0 | 5 | 31192656 | |
sakila | store | 3782113104 | 28 | 3782113104 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3547805184 | 0 | 0 | 0 | 5 | 105203472 | |
sakila | language | 3621295920 | 3 | 3621295920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3711373776 | 0 | 0 | 0 | 5 | 37516512 | |
sakila | address | 1820877696 | 213 | 1820877696 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1873951728 | 0 | 0 | 0 | 5 | 49416576 | |
world | CountryLanguage | 1691767968 | 54 | 1691767968 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 2357 | 1851823248 | 0 | 0 | 0 | 8 | 52439376 | |
vedettfak | fa | 1559636496 | 6 | 1559636496 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 2266443696 | 0 | 0 | 0 | 5 | 32920272 | |
test19 | ecurie | 1409323872 | 4 | 1409323872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1435554912 | 0 | 0 | 0 | 5 | 105289536 | |
sakila | category | 1159550304 | 61 | 1159550304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1050029376 | 0 | 0 | 0 | 5 | 44176176 | |
vedettfak | megye | 1088630400 | 41 | 1088630400 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1021377456 | 0 | 0 | 0 | 5 | 38191824 | |
sakila | customer | 975959424 | 3 | 975959424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1089335280 | 0 | 0 | 0 | 5 | 36242976 | |
test19 | voiture | 966076320 | 1 | 966076320 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1220656800 | 0 | 0 | 0 | 5 | 40899936 | |
sakila | film | 934342464 | 2 | 934342464 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1048533552 | 0 | 0 | 0 | 5 | 35611488 | |
sakila | actor | 878603616 | 2 | 878603616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1099106976 | 0 | 0 | 0 | 5 | 36257232 | |
sakila | country | 863894064 | 13 | 863894064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 976567680 | 0 | 0 | 0 | 5 | 54441024 | |
test19 | pilote | 845100960 | 4 | 845100960 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 956095008 | 0 | 0 | 0 | 5 | 32393328 | |
sys | sys_config | 587683536 | 1 | 587683536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 837777600 | 0 | 0 | 0 | 5 | 45488256 | |
world | Country | 41624880 | 4 | 41624880 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 512955696 | 0 | 0 | 0 | 6 | 41288016 | |
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 |
|