Missing InnoDB information_schema Views in MariaDB

While working on a MariaDB 10.0.14 instance today I noticed the INNODB_% tables were missing from information_schema. I could tell the InnoDB plugin was loaded.

SHOW PLUGINS;
Name                         Status    Type                Library          License  
InnoDB                       ACTIVE    STORAGE ENGINE      ha_innodb.so     GPL      

Checking the documentation I could see that these views are supplied by the innodb plugin itself. So the solution should be in the form of an INSTALL PLUGIN statement. I executed the following query on another MariaDB instance, of the same version, that had the INNODB_% table in info schema…

SELECT CONCAT("INSTALL PLUGIN ", PLUGIN_NAME, " SONAME 'ha_innodb.so';") 
FROM information_schema.PLUGINS
WHERE PLUGIN_NAME LIKE 'INNODB_%';

This generated the following statements. I executed these on the other instance to create the INNODB tables…

INSTALL PLUGIN INNODB_TRX SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_LOCKS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_LOCK_WAITS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMP SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMP_RESET SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMPMEM SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMPMEM_RESET SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMP_PER_INDEX SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CMP_PER_INDEX_RESET SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_BUFFER_PAGE SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_BUFFER_PAGE_LRU SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_BUFFER_POOL_STATS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_METRICS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_FT_DEFAULT_STOPWORD SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_FT_DELETED SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_FT_BEING_DELETED SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_FT_CONFIG SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_FT_INDEX_CACHE SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_FT_INDEX_TABLE SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_TABLES SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_TABLESTATS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_INDEXES SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_COLUMNS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_FIELDS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_FOREIGN SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_FOREIGN_COLS SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_TABLESPACES SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_SYS_DATAFILES SONAME 'ha_innodb.so';
INSTALL PLUGIN INNODB_CHANGED_PAGES SONAME 'ha_innodb.so';

Leave a Reply