Three system reserved databases are created in the MariaDB Server for operational purposes:
- calpontsys : Maintains table metadata about ColumnStore tables.
- infinidb_querystats: Maintains information about query performance, for the further details see Analyzing Queries in ColumnStore
- infinidb_vtable: This is used for the creation of temporary tables as part of query execution. Any user executing ColumnStore queries must have create temporary table permission on this database. For further details see Columnstore Database User Management