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 | 109912942128 | 48132 | 109912942128 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 5878750944 | 0 | 0 | 0 | 5 | 61415376 | |
sakila | rental | 20531718240 | 61875 | 20531718240 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 1163264 | 7412006976 | 0 | 0 | 0 | 5 | 57417360 | |
sakila | inventory | 6151574880 | 16743 | 6151574880 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 2345721840 | 0 | 0 | 0 | 5 | 38625312 | |
Stefano | vulcano | 4351312416 | 16 | 4351312416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4104761232 | 0 | 0 | 0 | 5 | 53308464 | |
sakila | customer | 4334604384 | 78 | 4334604384 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 5601320208 | 0 | 0 | 0 | 5 | 50154720 | |
sakila | film | 3543632928 | 3062 | 3543632928 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2059806144 | 0 | 0 | 0 | 5 | 32837376 | |
sys | sys_config | 2338907472 | 5 | 2338907472 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2517476544 | 0 | 0 | 0 | 5 | 40496016 | |
sakila | city | 2158052160 | 70 | 2158052160 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 5050079760 | 0 | 0 | 0 | 5 | 63950304 | |
Table_insertion | voiture | 1010149008 | 15 | 1010149008 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2145521664 | 0 | 0 | 0 | 5 | 40171824 | |
sakila | address | 779276784 | 131 | 779276784 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2111751840 | 0 | 0 | 0 | 5 | 38505984 | |
sakila | film_category | 585129072 | 3048 | 585129072 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1251266016 | 0 | 0 | 0 | 5 | 38889312 | |
sakila | language | 342550032 | 98 | 342550032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 954324624 | 0 | 0 | 0 | 5 | 39785328 | |
Table_insertion | ecurie | 162943968 | 24 | 162943968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1221747648 | 0 | 0 | 0 | 5 | 56401488 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 141331872 | 75 | 141331872 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | pilote | 78864192 | 29 | 78864192 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1194237792 | 0 | 0 | 0 | 5 | 45057408 | |
sakila | category | 57311760 | 51 | 57311760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1993942368 | 0 | 0 | 0 | 5 | 37535520 | |
sakila | country | 54353904 | 20 | 54353904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1302879072 | 0 | 0 | 0 | 5 | 63590736 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 25855632 | 4 | 25855632 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
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 | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|