MySQL 8 Administrator???s Guide

Benchmarks

To start with, let's fetch all the column names from all the InnoDB tables. The following is the query that we executed:

SELECT t.table_schema, t.table_name, c.column_nameFROM information_schema.tables t,information_schema.columns cWHERE t.table_schema = c.table_schemaAND t.table_name = c.table_nameAND t.engine='InnoDB';

The following figure shows how MySQL 8 performed a thousand times faster when having four instances:

Following this, we also performed a benchmark to find static table metadata. The following is the query that we executed:

SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, ROW_FORMAT FROM INFORMATION_SCHEMA.TABLES ...