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 | 557255011104 | 660000 | 557255011104 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 979978032 | 0 | 0 | 0 | 5 | 23267904 | |
sakila | film | 307796090448 | 616330 | 307796090448 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3745965696 | 0 | 0 | 0 | 5 | 25232592 | |
sakila | film_actor | 112909436112 | 660800 | 112909436112 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 2456190000 | 0 | 0 | 0 | 5 | 49355328 | |
sakila | category | 10649128512 | 20540 | 10649128512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 841665264 | 0 | 0 | 0 | 5 | 30549552 | |
TlapaleriaMalfoy | Registro | 4109948304 | 3 | 4109948304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2446604688 | 0 | 0 | 0 | 5 | 1869471120 | |
sakila | language | 3666572448 | 25 | 3666572448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3498684816 | 0 | 0 | 0 | 5 | 60365184 | |
sakila | address | 1923284352 | 75 | 1923284352 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1560607488 | 0 | 0 | 0 | 5 | 57724656 | |
sakila | customer | 1286958288 | 78 | 1286958288 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1523169120 | 0 | 0 | 0 | 5 | 184299984 | |
sakila | city | 1115756400 | 26 | 1115756400 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1277661264 | 0 | 0 | 0 | 5 | 35174832 | |
vedettfak | megye | 1040650512 | 3 | 1040650512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1000866768 | 0 | 0 | 0 | 5 | 298718640 | |
sakila | country | 997779024 | 25 | 997779024 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2291503104 | 0 | 0 | 0 | 5 | 55570416 | |
sys | sys_config | 708824688 | 1 | 708824688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 905758656 | 0 | 0 | 0 | 5 | 57945888 | |
sakila | actor | 405407904 | 803 | 405407904 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 778554480 | 0 | 0 | 0 | 5 | 41125392 | |
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 | |
mysql | indexes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|