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 | 458094319056 | 498052 | 458094319056 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1429151856 | 0 | 0 | 0 | 5 | 320124288 | |
sakila | film | 256055052528 | 465307 | 256055052528 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3903843504 | 0 | 0 | 0 | 5 | 39329136 | |
sakila | payment | 200646975408 | 96266 | 200646975408 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 15351886704 | 0 | 0 | 0 | 5 | 45979296 | |
sakila | film_actor | 96140250096 | 495602 | 96140250096 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 1946938752 | 0 | 0 | 0 | 5 | 67845360 | |
sakila | rental | 48041299152 | 123778 | 48041299152 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 16385051760 | 0 | 0 | 0 | 5 | 44689920 | |
sakila | inventory | 9305061216 | 30520 | 9305061216 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 475136 | 2299098912 | 0 | 0 | 0 | 5 | 45328800 | |
sakila | category | 9240238128 | 15458 | 9240238128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 758257104 | 0 | 0 | 0 | 5 | 48394368 | |
sakila | customer | 7381732512 | 82 | 7381732512 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 7028819424 | 0 | 0 | 0 | 5 | 23219328 | |
sku | Attore | 4287306672 | 2 | 4287306672 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2377415568 | 0 | 0 | 0 | 5 | 1822512384 | |
sys | sys_config | 3915378720 | 10 | 3915378720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2367161808 | 0 | 0 | 0 | 5 | 1792437504 | |
sakila | store | 3844693776 | 11 | 3844693776 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3895464672 | 0 | 0 | 0 | 5 | 48165216 | |
sakila | staff | 2051083056 | 36 | 2051083056 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1919823312 | 0 | 0 | 0 | 5 | 62950272 | |
sakila | address | 1608357696 | 118 | 1608357696 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1350753360 | 0 | 0 | 0 | 5 | 22029744 | |
sakila | city | 1082963376 | 100 | 1082963376 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 864030816 | 0 | 0 | 0 | 5 | 18896064 | |
sakila | actor | 1011670176 | 602 | 1011670176 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1006400736 | 0 | 0 | 0 | 5 | 43027776 | |
sakila | language | 1003527360 | 52 | 1003527360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 766744176 | 0 | 0 | 0 | 5 | 46838880 | |
sakila | country | 918289680 | 49 | 918289680 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 809489472 | 0 | 0 | 0 | 5 | 47032128 | |
Colossal | users | 528949872 | 2 | 473664048 | 1 | 55285824 | 0 | 0 | 0 | 0 | 6 | 744 | 476637216 | 23 | 801 | 42026688 | 22 | 126815568 | |
sakila | film_text | 331436160 | 2 | 331436160 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 3326065776 | 0 | 0 | 0 | 8 | 53973744 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 92553120 | 4 | 92553120 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
dsap | teacher_id | 77952864 | 6 | 77952864 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 932489712 | 6 | 69601191792 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 51068160 | 4 | 51068160 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Colossal | cheat | 16868016 | 0 | 0 | 1 | 16868016 | 0 | 0 | 0 | 0 | 2 | 328 | 11958672 | 9 | 444 | 42280128 | 16 | 115223328 | |
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 |
|