MySQL 8 Cookbook

Table statistics

mysql> SELECT * FROM sys.schema_table_statistics LIMIT 1\G*************************** 1. row ***************************     table_schema: employees       table_name: employees    total_latency: 14.03 h     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 io_read_requests: NULL          io_read: NULL  io_read_latency: NULLio_write_requests: NULL         io_write: NULL io_write_latency: NULL io_misc_requests: NULL  io_misc_latency: NULL1 row in set (0.01 sec)