INFORMATION_SCHEMA Thread Pool Tables always number 0. As the third column in the table, the ordinal position of the virtual generated column is 2. Ordinal positions are counted from 0. • BASE_POS The ordinal position of the columns upon which a virtual generated column is based. Example mysql>  CREATE TABLE ‘t1‘ ( ‘a‘ int(11) DEFAULT NULL, ‘b‘ int(11) DEFAULT NULL, ‘c‘ int(11) GENERATED ALWAYS AS (a+b) VIRTUAL, ‘h‘ varchar(10) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_VIRTUAL WHERE TABLE_ID IN (SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE "test/t1"); +----------+-------+----------+ | TABLE_ID | POS | BASE_POS | +----------+-------+----------+ | 98 | 65538 | 0 | | 98 | 65538 | 1 | +----------+-------+----------+ Notes 26.5 INFORMATION_SCHEMA Thread Pool Tables Note •If a constant value is assigned to a virtual generated column, as in the following table, an entry for the column does not appear in the  INNODB_VIRTUAL  table. For an entry to appear, a virtual generated column must have a base column. •You must have the  PROCESS  privilege to query this table. •Use the  INFORMATION_SCHEMA COLUMNS  table or the  SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. CREATE TABLE ‘t1‘ ( ‘a‘ int(11) DEFAULT NULL, ‘b‘ int(11) DEFAULT NULL, ‘c‘ int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; However, metadata for such a column does appear in the  INNODB_COLUMNS  table. As of MySQL 8.0.14, the  INFORMATION_SCHEMA  thread pool tables are also available as Performance Schema tables. (See Section 27.12.16, “Performance Schema Thread Pool Tables” .) The  INFORMATION_SCHEMA  tables are deprecated; expect them be removed in a future version of MySQL. Applications should transition away from the old tables to the new tables. For example, if an application uses this query: The application should use this query instead: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; 4885