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 | 1996833696 | 130 | 1996833696 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1618722336 | 0 | 0 | 0 | 5 | 267078240 | |
sakila | language | 1472863920 | 132 | 1472863920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 758562816 | 0 | 0 | 0 | 5 | 50715984 | |
sakila | staff | 1365685200 | 3 | 1365685200 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2313298416 | 0 | 0 | 0 | 5 | 39851856 | |
sys | sys_config | 631478496 | 1 | 631478496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1075666416 | 0 | 0 | 0 | 5 | 54363408 | |
sakila | country | 581345952 | 102 | 581345952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 778617840 | 0 | 0 | 0 | 5 | 31705344 | |
sakila | city | 490596480 | 52 | 490596480 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1523716656 | 0 | 0 | 0 | 5 | 46189968 | |
sakila | actor | 166569744 | 52 | 166569744 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1239830592 | 0 | 0 | 0 | 5 | 68221824 | |
sakila | address | 24945360 | 2 | 24945360 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2065708128 | 0 | 0 | 0 | 5 | 62463984 | |
sakila | film_actor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1721288448 | 0 | 0 | 0 | 5 | 32566512 | |
sakila | category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 896808528 | 0 | 0 | 0 | 5 | 39248352 | |
sakila | film_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1353947232 | 0 | 0 | 0 | 5 | 56114784 | |
sakila | inventory | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 278528 | 2226039552 | 0 | 0 | 0 | 5 | 41956464 | |
sakila | payment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 5437391520 | 0 | 0 | 0 | 5 | 53815344 | |
sakila | rental | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 10676902368 | 0 | 0 | 0 | 5 | 48991008 | |
sakila | store | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 778220784 | 0 | 0 | 0 | 5 | 31131936 | |
performance_schema | events_statements_summary_by_digest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
table | ameerah | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2037162864 | 0 | 0 | 0 | 5 | 976572960 | |
sakila | customer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1362852480 | 0 | 0 | 0 | 5 | 29932320 | |
Table_insertion | cours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4292362800 | 0 | 0 | 0 | 5 | 488849856 | |
sakila | film_text | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 627073920 | 0 | 0 | 0 | 4 | 36355440 | |
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 | |
performance_schema | events_statements_current | 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 | table_lock_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 |
|