MySQL 8 Cookbook

Table statistics with buffer

mysql> SELECT * FROM sys.schema_table_statistics_with_buffer LIMIT 1\G*************************** 1. row ***************************              table_schema: employees                table_name: employees              rows_fetched: 731760045             fetch_latency: 14.03 h             rows_inserted: 300025            insert_latency: 2.81 s              rows_updated: 0            update_latency: 0 ps              rows_deleted: 0            delete_latency: 0 ps~   innodb_buffer_allocated: 6.80 MiB        innodb_buffer_data: 6.23 MiB        innodb_buffer_free: 582.77 KiB       innodb_buffer_pages: 435innodb_buffer_pages_hashed: 0   innodb_buffer_pages_old: 435 innodb_buffer_rows_cached: 1477341 row in set (0.13 sec)