Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.24
-
None
-
Centos 7.0 and Centos 7.3
Description
When using InnoDb instead of XtraDb INNODB_% tables are totally missing in INFORMATION_SCHEMA
Steps to reproduce:
- Install MariaDb-server 10.1.24 from rpm on a fresh server.
- Run mysql_install_db
- Start server
- Login to server.
- Run following commands
show engines;.....*************************** 6. row ***************************Engine: InnoDBSupport: DEFAULTComment: Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tablesTransactions: YESXA: YESSavepoints: YES.....use information_schema;show tables like 'INNODB%';+----------------------------------------+| Tables_in_information_schema (INNODB%) |+----------------------------------------+| INNODB_SYS_DATAFILES || INNODB_SYS_TABLESTATS || INNODB_SYS_INDEXES |............| INNODB_CHANGED_PAGES || INNODB_FT_DELETED || INNODB_TABLESPACES_SCRUBBING |+----------------------------------------+33 rows in set (0.00 sec)
- Edit /etc/my.cnf.d/server.cnf
[mysqld]ignore_builtin_innodbplugin_load=innodb=ha_innodb.so
- Restart mariadb server
- Login to server
- Run following commands
show engines;...*************************** 8. row ***************************Engine: InnoDBSupport: DEFAULTComment: Supports transactions, row-level locking, foreign keys and encryption for tablesTransactions: YESXA: YESSavepoints: YES...use information_schema;show tables like 'INNODB%';EXPECTED to have INNODB tablesACTUAL RESULT:Empty set (0.00 sec)
This does not affect 10.2
According to docs at least some of INNODB_% tables in INFORMATION_SCHEMA should exists in version 10.1 for InnoDb plugin (Oracle)