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 | 169253390592 | 165002 | 169253390592 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2722413936 | 0 | 0 | 0 | 5 | 23896224 | |
sakila | film | 90474822240 | 154261 | 90474822240 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1605058224 | 0 | 0 | 0 | 5 | 45052128 | |
sakila | film_actor | 38955375888 | 165200 | 38955375888 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 4918855920 | 0 | 0 | 0 | 5 | 44617056 | |
sakila | category | 3550985328 | 5135 | 3550985328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 641869008 | 0 | 0 | 0 | 5 | 22348656 | |
sakila | actor | 3519756768 | 200 | 3519756768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3600706560 | 0 | 0 | 0 | 5 | 55087824 | |
sakila | address | 2961903120 | 25 | 2961903120 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2867614992 | 0 | 0 | 0 | 5 | 38633760 | |
sakila | customer | 2850307152 | 26 | 2850307152 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3205784208 | 0 | 0 | 0 | 5 | 44052096 | |
INFS1200_RELEASE | Policy | 2385386256 | 243 | 1768050768 | 48 | 617335488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 588037824 | 10 | 115350323088 | |
sakila | language | 2175885888 | 150 | 2175885888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 940879104 | 0 | 0 | 0 | 5 | 80280816 | |
INFS1200_RELEASE | Vehicle | 1568078688 | 194 | 1271676384 | 33 | 296402304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 663204960 | 9 | 62359062480 | |
sys | sys_config | 1495024080 | 12 | 1495024080 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 802476048 | 0 | 0 | 0 | 5 | 721403760 | |
INFS1200_RELEASE | Customer | 1491145392 | 154 | 1212441120 | 14 | 278704272 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 5608119792 | 9 | 86798985504 | |
sakila | country | 1140974736 | 102 | 1140974736 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 833771664 | 0 | 0 | 0 | 5 | 41806512 | |
products | customers | 1137398592 | 741 | 1137398592 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 145296096 | 7 | 58733998224 | |
sakila | inventory | 1111976448 | 26 | 1111976448 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2850387408 | 0 | 0 | 0 | 5 | 60572688 | |
sakila | city | 1091440416 | 52 | 1091440416 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1130088432 | 0 | 0 | 0 | 5 | 67163712 | |
products | employees | 963669696 | 204 | 963669696 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 213202176 | 6 | 53925095664 | |
products | suppliers | 852159264 | 164 | 852159264 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 265047024 | 6 | 41525411136 | |
products | shippers | 787707888 | 143 | 787707888 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 202952112 | 6 | 46783660176 | |
Table_insertion | pilote | 721422768 | 5 | 721422768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 830255184 | 0 | 0 | 0 | 5 | 40902048 | |
products | categories | 645814752 | 106 | 645814752 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 243911184 | 6 | 40433255808 | |
products | orders | 377134032 | 118 | 377134032 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 162451344 | 11 | 94025130672 | |
INFS1200_RELEASE | VehicleCodeMapping | 254646480 | 5 | 14946096 | 19 | 239700384 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 186998064 | 8 | 85670310000 | |
INFS1200_RELEASE | VehicleValue | 191475504 | 0 | 0 | 19 | 191475504 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 13596814176 | 6 | 56015215344 | |
products | products | 187026048 | 82 | 187026048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 4834476768 | 10 | 78298646448 |
|