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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys | sys_config | 5206622784 | 30 | 5206622784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4763858880 | 0 | 0 | 0 | 5 | 55228800 | |
sakila | actor | 4279939488 | 104 | 4279939488 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4357995840 | 0 | 0 | 0 | 5 | 47754960 | |
sakila | country | 1815712272 | 153 | 1815712272 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 957378048 | 0 | 0 | 0 | 5 | 69264096 | |
vedettfak | megye | 1773056208 | 15 | 1773056208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 906152016 | 0 | 0 | 0 | 5 | 891910800 | |
sakila | language | 1677411648 | 509 | 1677411648 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 756181008 | 0 | 0 | 0 | 5 | 22158576 | |
sakila | city | 1657046688 | 180 | 1657046688 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 901991904 | 0 | 0 | 0 | 5 | 238311216 | |
sakila | film | 1209748320 | 156 | 1209748320 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2268405216 | 0 | 0 | 0 | 5 | 24060960 | |
Table_insertion | pilote | 844396608 | 26 | 844396608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 909467856 | 0 | 0 | 0 | 5 | 40044048 | |
Table_insertion | ecurie | 834330816 | 16 | 834330816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 828420384 | 0 | 0 | 0 | 5 | 38523936 | |
sakila | address | 736083216 | 77 | 736083216 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2285638080 | 0 | 0 | 0 | 5 | 32398080 | |
sakila | film_actor | 729297888 | 2 | 729297888 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2568494544 | 0 | 0 | 0 | 5 | 19697568 | |
Table_insertion | voiture | 649846032 | 3 | 649846032 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 804773904 | 0 | 0 | 0 | 5 | 31893840 | |
Księgarnia | klienci | 551602128 | 0 | 0 | 10 | 551602128 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | customer | 98546976 | 26 | 98546976 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1605618960 | 0 | 0 | 0 | 5 | 24898368 | |
Księgarnia | zamowienia | 66796752 | 0 | 0 | 10 | 66796752 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | Country | 45413808 | 2 | 45413808 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 238941120 | 0 | 0 | 0 | 4 | 32524272 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 42317088 | 25 | 42317088 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Księgarnia | ksiazki | 35962608 | 0 | 0 | 5 | 35962608 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 32212224 | 4 | 32212224 | 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 |
|