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 | 289099876032 | 330000 | 289099876032 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4280006544 | 0 | 0 | 0 | 5 | 40023984 | |
sakila | payment | 270824091648 | 128381 | 270824091648 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 18621386256 | 0 | 0 | 0 | 5 | 35929344 | |
sakila | film | 146493336000 | 308282 | 146493336000 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4056135072 | 0 | 0 | 0 | 5 | 30445536 | |
sakila | rental | 64980275184 | 165004 | 64980275184 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 409600 | 6651217056 | 0 | 0 | 0 | 5 | 47385360 | |
sakila | film_actor | 55464874608 | 330428 | 55464874608 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2350620624 | 0 | 0 | 0 | 5 | 57209328 | |
sakila | inventory | 13129055280 | 36690 | 13129055280 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 425984 | 8880153216 | 0 | 0 | 0 | 5 | 38424144 | |
vedettfak | megye | 8225154432 | 42 | 8225154432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 883049376 | 0 | 0 | 0 | 5 | 39903072 | |
sakila | staff | 7846216224 | 68 | 7846216224 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 7316028720 | 0 | 0 | 0 | 5 | 34007424 | |
sakila | category | 5831985984 | 10278 | 5831985984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 872185776 | 0 | 0 | 0 | 5 | 54442080 | |
test19 | voiture | 5343799824 | 18 | 5343799824 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5291095392 | 0 | 0 | 0 | 5 | 108800736 | |
vedettfak | fa | 4760513472 | 8 | 4760513472 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 5409615024 | 0 | 0 | 0 | 5 | 38155392 | |
Stefano | vulcano | 4678416336 | 33 | 4678416336 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4546568400 | 0 | 0 | 0 | 5 | 52496928 | |
sakila | country | 4044694896 | 274 | 4044694896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3979868112 | 0 | 0 | 0 | 5 | 41145456 | |
sakila | city | 3471606336 | 74 | 3471606336 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2973710256 | 0 | 0 | 0 | 5 | 36916704 | |
test19 | pilote | 3180319296 | 4 | 3180319296 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2911968048 | 0 | 0 | 0 | 5 | 45873696 | |
sakila | actor | 3022953120 | 703 | 3022953120 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2467991328 | 0 | 0 | 0 | 5 | 37110480 | |
sakila | store | 2741940960 | 40 | 2741940960 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2608158432 | 0 | 0 | 0 | 5 | 31212720 | |
sakila | language | 1410449568 | 81 | 1410449568 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 981064656 | 0 | 0 | 0 | 5 | 38584128 | |
sakila | customer | 1370034864 | 57 | 1370034864 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3157239888 | 0 | 0 | 0 | 5 | 38302704 | |
sakila | address | 1292955840 | 401 | 1292955840 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1375926816 | 0 | 0 | 0 | 5 | 39093648 | |
test19 | ecurie | 774338928 | 18 | 774338928 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 857025312 | 0 | 0 | 0 | 5 | 35060784 | |
sys | sys_config | 707589168 | 3 | 707589168 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 833383056 | 0 | 0 | 0 | 5 | 44206272 | |
world | CountryLanguage | 584622192 | 82 | 584622192 | 0 | 0 | 0 | 0 | 0 | 0 | 77 | 3332 | 2163343248 | 0 | 0 | 0 | 9 | 60282816 | |
world | Country | 344054832 | 4 | 344054832 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 1510723632 | 0 | 0 | 0 | 6 | 34831104 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|