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 | 293227688688 | 330000 | 293227688688 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 979978032 | 0 | 0 | 0 | 5 | 23267904 | |
sakila | film | 165880375584 | 308178 | 165880375584 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3745965696 | 0 | 0 | 0 | 5 | 25232592 | |
sakila | film_actor | 61870141344 | 330400 | 61870141344 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 2456190000 | 0 | 0 | 0 | 5 | 49355328 | |
sakila | category | 5955497856 | 10270 | 5955497856 | 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 | |
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 | 248202768 | 403 | 248202768 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 778554480 | 0 | 0 | 0 | 5 | 41125392 | |
mysql | parameter_type_elements | 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 | |
performance_schema | events_waits_summary_by_host_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_transactions_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | general_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 371877792 | 0 | 0 | 0 | 4 | 82167888 | |
performance_schema | file_summary_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | innodb_table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_errors_summary_by_host_by_error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 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 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|