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 | film_category | 165003 | 202790679168 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1050647136 | 0 | 0 | 0 | 5 | 35085600 | 81920 | 33036 | 48884 | 5 | 0 | 3 | 1002 | |
sakila | film | 154427 | 109874261376 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1252899648 | 0 | 0 | 0 | 5 | 36465264 | 212992 | 155213 | 57779 | 13 | 11 | 10 | 1006 | |
sakila | film_actor | 165200 | 47397497664 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1390792656 | 0 | 0 | 0 | 5 | 35159520 | 196608 | 142155 | 54453 | 12 | 10 | 12 | 5473 | |
sakila | category | 5199 | 4682802432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 968366784 | 0 | 0 | 0 | 5 | 41739456 | 16384 | 487 | 15897 | 1 | 1 | 1 | 16 | |
sakila | inventory | 28 | 1850365440 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4305311472 | 0 | 0 | 0 | 5 | 47417568 | 212992 | 136174 | 76818 | 13 | 0 | 11 | 2684 | |
sakila | language | 25 | 1387395504 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1381409568 | 0 | 0 | 0 | 5 | 37587264 | 16384 | 264 | 16120 | 1 | 0 | 1 | 6 | |
sakila | store | 6 | 1190021712 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1169912304 | 0 | 0 | 0 | 5 | 104135328 | 16384 | 14 | 16370 | 1 | 0 | 0 | 2 | |
sakila | staff | 4 | 890562288 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1012962720 | 0 | 0 | 0 | 5 | 42479184 | 32768 | 267 | 32501 | 2 | 0 | 2 | 2 | |
vedettfak | megye | 2 | 761686992 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1262013456 | 0 | 0 | 0 | 5 | 38885088 | 16384 | 655 | 15729 | 1 | 0 | 1 | 19 | |
sakila | address | 100 | 735872016 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 963458496 | 0 | 0 | 0 | 5 | 53952096 | 16384 | 5427 | 10957 | 1 | 0 | 1 | 603 | |
sakila | actor | 200 | 721080096 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 797856576 | 0 | 0 | 0 | 5 | 36320592 | 16384 | 7507 | 8877 | 1 | 0 | 1 | 200 | |
mysql | component | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
pw | credenciales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 806425488 | 0 | 0 | 0 | 5 | 51638400 | 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 | 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 | 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 | table_partition_values | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | innodb_table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 3911 | 12473 | 1 | 0 | 0 | 60 | |
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 | 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 | columns_priv | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
аа | Поставщик | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 0 | 16384 | 1 | 0 | 1 | 0 | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 8983 | 7401 | 1 | 0 | 0 | 90 | |
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 | |
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 |
|