[MDEV-12991] INNODB_% tables missing in INFORMATION_SCHEMA when using oracle InnoDb instead of XtraDb Created: 2017-06-05  Updated: 2017-06-05  Resolved: 2017-06-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.1.24
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Peter Shchuchkin Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

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)



 Comments   
Comment by Sergei Golubchik [ 2017-06-05 ]

This is not a bug. With the

plugin_load=innodb=ha_innodb.so

you tell the server to load innodb plugin from the file ha_innodb.so. Naturally no information_schema plugins are loaded, because you didn't ask for it.
Use

plugin_load=ha_innodb.so

which means load all plugins from ha_innodb.so.

Comment by Peter Shchuchkin [ 2017-06-05 ]

Thank you, it really works!

May be you should consider to update documentation, I've taken ini parameters from the docs here

https://mariadb.com/kb/en/mariadb/using-innodb-instead-of-xtradb/

Comment by Sergei Golubchik [ 2017-06-05 ]

Right. I've updated it, thanks.

Generated at Thu Feb 08 08:02:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.