O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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)

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required