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 | film_category | 429349591440 | 495026 | 429349591440 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1081632288 | 0 | 0 | 0 | 5 | 331064448 | |
sakila | film | 243772202784 | 462358 | 243772202784 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 6640599504 | 0 | 0 | 0 | 5 | 47611344 | |
sakila | film_actor | 89633109984 | 495600 | 89633109984 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1314006144 | 0 | 0 | 0 | 5 | 29633472 | |
sakila | category | 8455896240 | 15433 | 8455896240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 960163776 | 0 | 0 | 0 | 5 | 45691008 | |
vedettfak | megye | 7303611216 | 5 | 7303611216 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1896154128 | 0 | 0 | 0 | 5 | 5622380016 | |
test19 | pilote | 5802888432 | 2 | 5802888432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1457489088 | 0 | 0 | 0 | 5 | 4449408480 | |
sakila | country | 5119510704 | 28 | 5119510704 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5061036288 | 0 | 0 | 0 | 5 | 106854528 | |
sakila | payment | 4768780368 | 2 | 4768780368 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 9312824400 | 0 | 0 | 0 | 5 | 40829712 | |
sakila | address | 4732316160 | 684 | 4732316160 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5175541008 | 0 | 0 | 0 | 5 | 34960464 | |
Stefano | vulcano | 4729851984 | 4 | 4729851984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1735231872 | 0 | 0 | 0 | 5 | 3113742720 | |
test19 | ecurie | 3857114448 | 5 | 3857114448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4008363216 | 0 | 0 | 0 | 5 | 64241232 | |
sakila | customer | 2455626096 | 4 | 2455626096 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3447412848 | 0 | 0 | 0 | 5 | 48753408 | |
sakila | rental | 2036347632 | 2 | 2036347632 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 13947513360 | 0 | 0 | 0 | 5 | 36246672 | |
vedettfak | fa | 2024500368 | 2 | 2024500368 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1192259904 | 0 | 0 | 0 | 5 | 1017887904 | |
sakila | city | 1719560304 | 75 | 1719560304 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1251305616 | 0 | 0 | 0 | 5 | 65706432 | |
sakila | inventory | 1338899232 | 26 | 1338899232 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2103991824 | 0 | 0 | 0 | 5 | 57657072 | |
sakila | language | 1180357200 | 75 | 1180357200 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 884060496 | 0 | 0 | 0 | 5 | 46954512 | |
sys | sys_config | 877914576 | 9 | 877914576 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 705662496 | 0 | 0 | 0 | 5 | 223765872 | |
test19 | voiture | 816288528 | 2 | 816288528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 705520464 | 0 | 0 | 0 | 5 | 302990688 | |
world | Country | 708820464 | 4 | 708820464 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 466769952 | 0 | 0 | 0 | 4 | 786428016 | |
sakila | actor | 284133696 | 600 | 284133696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 972827328 | 0 | 0 | 0 | 5 | 51735552 | |
sku | Attore | 98345280 | 7 | 98345280 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 958237632 | 0 | 0 | 0 | 5 | 58150752 | |
world | City | 31010496 | 2 | 31010496 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 159762240 | 0 | 0 | 0 | 4 | 33974160 | |
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 |
|