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 | 582208680768 | 660000 | 582208680768 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1677288096 | 0 | 0 | 0 | 5 | 18929856 | |
sakila | film | 316243611024 | 616410 | 315617604192 | 1 | 626006832 | 0 | 0 | 0 | 0 | 19 | 360448 | 8093054640 | 6 | 98304 | 171122160 | 7 | 17504947152 | |
sakila | film_actor | 116081829600 | 660800 | 116081829600 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 2066568768 | 0 | 0 | 0 | 5 | 20175936 | |
sakila | category | 10884118080 | 20540 | 10884118080 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 813891936 | 0 | 0 | 0 | 5 | 18792048 | |
sakila | country | 4545646512 | 78 | 4545646512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4478864544 | 0 | 0 | 0 | 5 | 49126704 | |
sakila | customer | 3050483568 | 51 | 3050483568 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2893113168 | 0 | 0 | 0 | 5 | 59520912 | |
sakila | address | 2049840144 | 103 | 2049840144 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2170049376 | 0 | 0 | 0 | 5 | 83576064 | |
sys | sys_config | 1981464144 | 1 | 1981464144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1976912256 | 0 | 0 | 0 | 5 | 114897024 | |
sakila | city | 1812846288 | 75 | 1812846288 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1224794736 | 0 | 0 | 0 | 5 | 52231344 | |
sakila | language | 1686452064 | 100 | 1686452064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1085403792 | 0 | 0 | 0 | 5 | 55314864 | |
sakila | film_text | 1343894640 | 0 | 0 | 1 | 1343894640 | 0 | 0 | 0 | 0 | 2 | 442 | 1499027904 | 3 | 183 | 187869792 | 3 | 23169168 | |
sakila | actor | 1233542112 | 800 | 1233542112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1177688688 | 0 | 0 | 0 | 5 | 34877568 | |
sakila | payment | 1100501424 | 26 | 1100501424 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 5683425792 | 0 | 0 | 0 | 5 | 33294624 | |
sakila | staff | 1007391264 | 25 | 1007391264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 952686240 | 0 | 0 | 0 | 5 | 35056560 | |
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 |
|