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 | 449241681504 | 331125 | 449241681504 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1370594544 | 0 | 0 | 0 | 5 | 39934224 | |
sakila | film | 266188825584 | 309558 | 266188825584 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 43655416992 | 0 | 0 | 0 | 5 | 67390752 | |
sakila | film_actor | 90966322656 | 330400 | 90966322656 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1443423696 | 0 | 0 | 0 | 5 | 31264464 | |
sakila | category | 57267715296 | 10312 | 57267715296 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 752438016 | 0 | 0 | 0 | 5 | 50520624 | |
sakila | city | 13255795872 | 3 | 13255795872 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1135422288 | 0 | 0 | 0 | 5 | 12625525968 | |
INFS1200_RELEASE | Vehicle | 4389749232 | 135 | 1185729600 | 33 | 3204019632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 155065152 | 9 | 63494471040 | |
INFS1200_RELEASE | VehicleCodeMapping | 4388480976 | 0 | 0 | 19 | 4388480976 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 180939792 | 8 | 90005683152 | |
sakila | language | 4175945136 | 1240 | 4175945136 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 606666720 | 0 | 0 | 0 | 5 | 39114240 | |
sys | sys_config | 3743932896 | 15 | 3743932896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1069292400 | 0 | 0 | 0 | 5 | 61676736 | |
INFS1200_RELEASE | Customer | 3365949840 | 100 | 903026784 | 14 | 2462923056 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 221485968 | 11 | 98505557040 | |
sakila | actor | 2810819616 | 403 | 2810819616 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2876783712 | 0 | 0 | 0 | 5 | 35123088 | |
INFS1200_RELEASE | Policy | 2623665264 | 104 | 504884688 | 48 | 2118780576 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 4587633600 | 10 | 108199459632 | |
sakila | country | 2285316528 | 3 | 2285316528 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2464511280 | 0 | 0 | 0 | 5 | 45876336 | |
sakila | customer | 2141814576 | 254 | 2141814576 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2391622992 | 0 | 0 | 0 | 5 | 43126512 | |
vedettfak | megye | 1659615936 | 5 | 1659615936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 811172736 | 0 | 0 | 0 | 5 | 488854608 | |
sakila | payment | 1507071984 | 29 | 1507071984 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 5462468352 | 0 | 0 | 0 | 5 | 258996144 | |
INFS1200_RELEASE | Address | 1350017856 | 0 | 0 | 14 | 1350017856 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 187046640 | 7 | 57126656400 | |
sakila | address | 1311181344 | 30 | 1311181344 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1767528048 | 0 | 0 | 0 | 5 | 36774672 | |
sakila | staff | 1031232048 | 35 | 1031232048 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 907977840 | 0 | 0 | 0 | 5 | 38244624 | |
world | City | 1021164672 | 1 | 1021164672 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 230006304 | 0 | 0 | 0 | 4 | 51779376 | |
sakila | rental | 938128752 | 200 | 938128752 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 13497002640 | 0 | 0 | 0 | 5 | 48963552 | |
sakila | store | 790446624 | 3 | 790446624 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 881692944 | 0 | 0 | 0 | 5 | 34146816 | |
INFS1200_RELEASE | VehicleExcessRange | 728109360 | 0 | 0 | 19 | 728109360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 148052256 | 6 | 60913016736 | |
INFS1200_RELEASE | VehicleValue | 167721840 | 0 | 0 | 19 | 167721840 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 204565152 | 6 | 40135834464 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|