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 | actor | 16120947216 | 1296 | 16120947216 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2115723984 | 0 | 0 | 0 | 5 | 59821872 | |
sakila | city | 4945849392 | 202 | 4945849392 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 2830651824 | 0 | 0 | 0 | 5 | 130866384 | |
sakila | address | 4788494832 | 3769 | 4788494832 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1808554704 | 0 | 0 | 0 | 5 | 45460272 | |
tuff | Instructors | 2585993520 | 55 | 2538884832 | 5 | 47108688 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 368993328 | 7 | 61083336864 | |
sakila | film | 2149037088 | 208 | 2149037088 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1867322160 | 0 | 0 | 0 | 5 | 230196912 | |
sakila | language | 1649294064 | 125 | 1649294064 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 992944656 | 0 | 0 | 0 | 5 | 72655440 | |
sakila | inventory | 1463572704 | 26 | 1463572704 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3721309152 | 0 | 0 | 0 | 5 | 49208544 | |
sakila | country | 1069316160 | 50 | 1069316160 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 874253952 | 0 | 0 | 0 | 5 | 57496560 | |
sys | sys_config | 697068240 | 1 | 697068240 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 709038528 | 0 | 0 | 0 | 5 | 212236464 | |
sakila | category | 630749328 | 2 | 630749328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 776746608 | 0 | 0 | 0 | 5 | 66959904 | |
tuff | Teaches | 595241856 | 27 | 388932720 | 5 | 206309136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 294912 | 5447873904 | 9 | 111376438272 | |
agenda2024 | agenda2024 | 422061024 | 19 | 293557968 | 1 | 128503056 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 241227360 | 7 | 65045935152 | |
tuff | Courses | 404322336 | 41 | 350651136 | 5 | 53671200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 734634912 | 7 | 109132804176 | |
tuff | Students | 345074400 | 23 | 285360768 | 5 | 59713632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 270123744 | 7 | 68968447680 | |
tuff | Enrollments | 159011424 | 2 | 22947408 | 10 | 136064016 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 294912 | 665014944 | 9 | 126365843472 | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_status | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | innodb_index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
test19 | speciale | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2033083008 | 0 | 0 | 0 | 5 | 764995968 | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|