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 | 298149457584 | 330000 | 298149457584 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 892396032 | 0 | 0 | 0 | 5 | 26513520 | |
sakila | film | 150497681664 | 308204 | 150497681664 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2580078864 | 0 | 0 | 0 | 5 | 30611856 | |
sakila | city | 67191516480 | 83 | 67191516480 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 65423581872 | 0 | 0 | 0 | 5 | 1439533920 | |
sakila | film_actor | 59560656144 | 330400 | 59560656144 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1656542448 | 0 | 0 | 0 | 5 | 20637936 | |
vedettfak | megye | 6144157536 | 113 | 6144157536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2428061328 | 0 | 0 | 0 | 5 | 1915877040 | |
sakila | category | 5765637504 | 10270 | 5765637504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 793296768 | 0 | 0 | 0 | 5 | 17608800 | |
sakila | staff | 4300624944 | 32 | 4300624944 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4249118016 | 0 | 0 | 0 | 5 | 46488816 | |
test19 | ecurie | 3843921312 | 2 | 3843921312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4049678160 | 0 | 0 | 0 | 5 | 34355904 | |
vedettfak | fa | 3189752016 | 29 | 3189752016 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 4188843648 | 0 | 0 | 0 | 5 | 39337584 | |
sakila | customer | 1714176288 | 25 | 1714176288 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1564373184 | 0 | 0 | 0 | 5 | 51801024 | |
sakila | rental | 1517912880 | 26 | 1517912880 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 16898393952 | 0 | 0 | 0 | 5 | 39416256 | |
sakila | country | 1468304112 | 82 | 1468304112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1084593840 | 0 | 0 | 0 | 5 | 71566704 | |
sakila | language | 1229262144 | 50 | 1229262144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1026864960 | 0 | 0 | 0 | 5 | 63767088 | |
sakila | address | 1207257216 | 32 | 1207257216 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1931739216 | 0 | 0 | 0 | 5 | 39299040 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1074486864 | 12 | 1074486864 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | actor | 891442992 | 400 | 891442992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 949818144 | 0 | 0 | 0 | 5 | 35302080 | |
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 |
|