SELECT * FROM `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 | customer | 26 | 4.73 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 5.29 ms | 0 | 0 bytes | 0 ps | 5 | 43.01 us | 96.00 KiB | 51.96 KiB | 44.04 KiB | 6 | 0 | 4 | 601 | |
sakila | country | 26 | 2.39 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.51 ms | 0 | 0 bytes | 0 ps | 5 | 82.69 us | 16.00 KiB | 3.65 KiB | 12.35 KiB | 1 | 0 | 0 | 110 | |
sakila | address | 25 | 1.61 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.67 ms | 0 | 0 bytes | 0 ps | 5 | 54.05 us | 32.00 KiB | 7.33 KiB | 24.67 KiB | 2 | 0 | 2 | 102 | |
vedettfak | megye | 3 | 1.48 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.49 ms | 0 | 0 bytes | 0 ps | 5 | 324.03 us | 16.00 KiB | 655 bytes | 15.36 KiB | 1 | 0 | 0 | 19 | |
mysql | index_column_usage | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 272.00 KiB | 143.96 KiB | 128.04 KiB | 17 | 3 | 6 | 1579 | |
mysql | help_relation | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 80.00 KiB | 41.76 KiB | 38.24 KiB | 5 | 0 | 2 | 1646 | |
mysql | column_statistics | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 48.00 KiB | 0 bytes | 48.00 KiB | 3 | 0 | 0 | 0 | |
mysql | proxies_priv | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 32.00 KiB | 1.16 KiB | 30.84 KiB | 2 | 0 | 0 | 1 | |
mysql | password_history | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 0 | 0 | |
sys | sys_config | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 872.23 us | 0 | 0 bytes | 0 ps | 5 | 49.03 us | 16.00 KiB | 338 bytes | 15.67 KiB | 1 | 0 | 0 | 6 | |
mysql | table_stats | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 8.47 KiB | 7.53 KiB | 1 | 0 | 0 | 87 | |
PRUEBA | MATERIAL | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 915.16 us | 0 | 0 bytes | 0 ps | 5 | 61.31 us | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 0 | 0 | |
performance_schema | events_statements_current | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_instance | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_keyword | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 160.00 KiB | 90.06 KiB | 69.94 KiB | 10 | 0 | 4 | 562 | |
mysql | global_grants | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 64.00 KiB | 26.20 KiB | 37.80 KiB | 4 | 0 | 2 | 79 | |
mysql | foreign_key_column_usage | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 48.00 KiB | 8.32 KiB | 39.68 KiB | 3 | 0 | 1 | 86 | |
mysql | view_routine_usage | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 32.00 KiB | 5.32 KiB | 26.68 KiB | 2 | 0 | 1 | 66 | |
mysql | servers | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 0 | 0 | |
mysql | default_roles | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 0 | 0 | |
wisedb | login | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.56 ms | 0 | 0 bytes | 0 ps | 5 | 1.77 ms | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 | |
mysql | time_zone_name | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16.00 KiB | 0 bytes | 16.00 KiB | 1 | 0 | 1 | 0 | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_partitions | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 112.00 KiB | 0 bytes | 112.00 KiB | 7 | 0 | 3 | 0 | |
mysql | innodb_index_stats | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 64.00 KiB | 31.45 KiB | 32.55 KiB | 4 | 0 | 2 | 330 |
|