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 | 545878169760 | 660000 | 545878169760 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1278319680 | 0 | 0 | 0 | 5 | 29751216 | |
sakila | film | 292201131552 | 616381 | 292201131552 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2057103840 | 0 | 0 | 0 | 5 | 23365584 | |
sakila | film_actor | 107738826096 | 660800 | 107738826096 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1899241872 | 0 | 0 | 0 | 5 | 18222864 | |
sakila | category | 9483623424 | 20540 | 9483623424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1022334720 | 0 | 0 | 0 | 5 | 30495168 | |
vedettfak | megye | 3963580368 | 3 | 3963580368 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 973996848 | 0 | 0 | 0 | 5 | 3207097872 | |
sys | sys_config | 1936498608 | 1 | 1936498608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1162435296 | 0 | 0 | 0 | 5 | 996781632 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 1715174736 | 25 | 1715174736 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | city | 1670708160 | 51 | 1670708160 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1461679296 | 0 | 0 | 0 | 5 | 51318960 | |
sakila | country | 1246425840 | 25 | 1246425840 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1106337408 | 0 | 0 | 0 | 5 | 54796368 | |
sakila | address | 1003837824 | 28 | 1003837824 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2058714240 | 0 | 0 | 0 | 5 | 41827632 | |
sakila | inventory | 661278288 | 26 | 661278288 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2675191728 | 0 | 0 | 0 | 5 | 31058544 | |
sakila | language | 386748912 | 57 | 386748912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 806009952 | 0 | 0 | 0 | 5 | 33615648 | |
sakila | store | 356785968 | 3 | 356785968 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1174327440 | 0 | 0 | 0 | 5 | 21164352 | |
sakila | actor | 303128496 | 800 | 303128496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1939657632 | 0 | 0 | 0 | 5 | 33309408 | |
sakila | staff | 35035440 | 2 | 35035440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1081248432 | 0 | 0 | 0 | 5 | 23983344 | |
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 |
|