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 | 631994598670 | 320895 | 631994598670 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 10318661160 | 0 | 0 | 0 | 5 | 39359390 | |
sakila | film_category | 303138440130 | 330000 | 303138440130 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1811280300 | 0 | 0 | 0 | 5 | 42022110 | |
sakila | rental | 161361886170 | 412539 | 161361886170 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 18741997800 | 0 | 0 | 0 | 5 | 32152450 | |
sakila | film | 155094203690 | 308370 | 155094203690 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 344064 | 1697617030 | 0 | 0 | 0 | 5 | 41467730 | |
sakila | film_actor | 63010797410 | 330404 | 63010797410 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 4991574450 | 0 | 0 | 0 | 5 | 66019980 | |
sakila | inventory | 21299018310 | 91692 | 21299018310 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 6626831680 | 0 | 0 | 0 | 5 | 422516000 | |
sakila | customer | 9196168330 | 60 | 9196168330 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 8816156210 | 0 | 0 | 0 | 5 | 44960960 | |
sakila | category | 6736744670 | 10305 | 6736744670 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1384776050 | 0 | 0 | 0 | 5 | 72008980 | |
Stefano | vulcano | 4852992170 | 21 | 4852992170 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2464347360 | 0 | 0 | 0 | 5 | 2105781690 | |
test19 | voiture | 4688066240 | 9 | 4688066240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2836924640 | 0 | 0 | 0 | 5 | 2044909600 | |
sakila | store | 4516355250 | 74 | 4516355250 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4093981290 | 0 | 0 | 0 | 5 | 43399050 | |
sakila | staff | 4244997900 | 83 | 4244997900 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 3690871770 | 0 | 0 | 0 | 5 | 49785020 | |
sakila | city | 3769920740 | 117 | 3769920740 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3149029450 | 0 | 0 | 0 | 5 | 25156450 | |
sakila | address | 3510312960 | 117 | 3510312960 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5496285500 | 0 | 0 | 0 | 5 | 27608230 | |
sakila | actor | 2622208920 | 2159 | 2622208920 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1026876590 | 0 | 0 | 0 | 5 | 42195420 | |
vedettfak | fa | 2439084910 | 6 | 2439084910 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4395751100 | 0 | 0 | 0 | 5 | 912526440 | |
sys | sys_config | 1730458480 | 35 | 1730458480 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1332542430 | 0 | 0 | 0 | 5 | 75525530 | |
sakila | language | 1622839860 | 194 | 1622839860 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 683628450 | 0 | 0 | 0 | 5 | 41482570 | |
sakila | country | 1210128330 | 713 | 1210128330 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 621358750 | 0 | 0 | 0 | 5 | 25256090 | |
test19 | pilote | 956245080 | 9 | 956245080 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1041879830 | 0 | 0 | 0 | 5 | 59981160 | |
test19 | ecurie | 890892900 | 9 | 890892900 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1078940080 | 0 | 0 | 0 | 5 | 42040660 | |
world | CountryLanguage | 526703930 | 42 | 526703930 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 579794560 | 0 | 0 | 0 | 11 | 110335400 | |
sakila | film_text | 383841370 | 3 | 383841370 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 815978460 | 0 | 0 | 0 | 8 | 65130640 | |
vedettfak | megye | 62070420 | 5 | 62070420 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1013729940 | 0 | 0 | 0 | 5 | 49542280 | |
world | Country | 52447740 | 5 | 52447740 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 611595620 | 0 | 0 | 0 | 7 | 41803750 |
|