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 | 5168852304 | 28 | 5168852304 | 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 | |
vedettfak | megye | 1773056208 | 15 | 1773056208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 906152016 | 0 | 0 | 0 | 5 | 891910800 | |
sakila | country | 1648933968 | 128 | 1648933968 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 957378048 | 0 | 0 | 0 | 5 | 69264096 | |
sakila | city | 1625824992 | 154 | 1625824992 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 901991904 | 0 | 0 | 0 | 5 | 238311216 | |
sakila | language | 1540245696 | 484 | 1540245696 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 756181008 | 0 | 0 | 0 | 5 | 22158576 | |
sakila | film | 1153946112 | 130 | 1153946112 | 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 | |
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 | |
sakila | customer | 98546976 | 26 | 98546976 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1605618960 | 0 | 0 | 0 | 5 | 24898368 | |
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 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 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 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_keys | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|