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 | 3356119536 | 237 | 3356119536 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5496754032 | 0 | 0 | 0 | 5 | 34683792 | |
sys | sys_config | 1585549680 | 6 | 1585549680 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1385316768 | 0 | 0 | 0 | 5 | 45945504 | |
sakila | city | 1165731072 | 29 | 1165731072 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 978144288 | 0 | 0 | 0 | 5 | 77207856 | |
sakila | film_actor | 1148964432 | 3 | 1148964432 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1027451040 | 0 | 0 | 0 | 5 | 46596528 | |
sakila | language | 1104815712 | 169 | 1104815712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 584714592 | 0 | 0 | 0 | 5 | 35128368 | |
sakila | country | 852888960 | 225 | 852888960 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 524659872 | 0 | 0 | 0 | 5 | 38403552 | |
vedettfak | megye | 713957904 | 20 | 713957904 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 620724192 | 0 | 0 | 0 | 5 | 39169680 | |
sakila | actor | 694948320 | 200 | 694948320 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 561170016 | 0 | 0 | 0 | 5 | 35774640 | |
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 | |
rtk | work_schedule | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 886762272 | 0 | 0 | 0 | 5 | 20997504 | |
rtk | users | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1157462064 | 0 | 0 | 0 | 5 | 23185536 | |
rtk | role_requests | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2400487584 | 0 | 0 | 0 | 5 | 20555568 | |
rtk | roles | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 917120160 | 0 | 0 | 0 | 5 | 23527152 | |
rtk | locations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 571549440 | 0 | 0 | 0 | 5 | 25455936 | |
rtk | employee_locations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 646972128 | 0 | 0 | 0 | 5 | 44459712 | |
rtk | departments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 680537088 | 0 | 0 | 0 | 5 | 36895584 | |
performance_schema | events_statements_current | 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 | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_histogram_global | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_summary_by_digest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 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 | |
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 |
|