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: InnoDB
Support: DEFAULT
Comment: Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables
Transactions: YES
XA: YES
Savepoints: 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_innodb
plugin_load=innodb=ha_innodb.so
- Restart mariadb server
- Login to server
- Run following commands
show engines;
...
*************************** 8. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, foreign keys and encryption for tables
Transactions: YES
XA: YES
Savepoints: YES
...
use information_schema;
show tables like 'INNODB%';
EXPECTED to have INNODB tables
ACTUAL 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)