SELECT * FROM `x$schema_table_statistics_with_buffer`
|
table_schema | table_name | 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 | innodb_buffer_allocated | innodb_buffer_data | innodb_buffer_free | innodb_buffer_pages | innodb_buffer_pages_hashed | innodb_buffer_pages_old | innodb_buffer_rows_cached | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | inventory | 26 | 4391219712 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5221608480 | 0 | 0 | 0 | 5 | 40423680 | 212992 | 136174 | 76818 | 13 | 0 | 13 | 2684 | |
sakila | film | 25 | 1005561744 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 920482992 | 0 | 0 | 0 | 5 | 31120848 | 32768 | 7635 | 25133 | 2 | 0 | 2 | 61 | |
sakila | actor | 201 | 977315856 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1138286688 | 0 | 0 | 0 | 5 | 38998608 | 32768 | 10353 | 22415 | 2 | 0 | 2 | 200 | |
Stefano | vulcano | 2 | 845609952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1137667872 | 0 | 0 | 0 | 5 | 35043360 | 16384 | 344 | 16040 | 1 | 0 | 1 | 4 | |
sakila | language | 7 | 631018608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 696417744 | 0 | 0 | 0 | 5 | 74720448 | 16384 | 264 | 16120 | 1 | 0 | 1 | 6 | |
world | City | 2 | 45913296 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 272456976 | 0 | 0 | 0 | 5 | 22793232 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_worker_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | time_zone_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | engine_cost | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 112 | 16272 | 1 | 0 | 1 | 2 | |
Table_insertion | cours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1018717392 | 0 | 0 | 0 | 5 | 34487904 | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
PRUEBA | MATERIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2122847760 | 0 | 0 | 0 | 5 | 94213680 | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | time_zone_leap_second | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | role_edges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | default_roles | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
students | record 2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | time_zone | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | columns_priv | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 0 | 0 | |
mysql | gtid_executed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 47 | 16337 | 1 | 0 | 1 | 1 | |
Table_insertion | voiture | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 921111312 | 0 | 0 | 0 | 5 | 35447280 | 16384 | 646 | 15738 | 1 | 0 | 1 | 14 | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 8684 | 7700 | 1 | 0 | 0 | 87 | |
mysql | slave_relay_log_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
Table_insertion | speciale | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 7488029472 | 0 | 0 | 0 | 5 | 48228048 | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_instance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|