ColumnStore System Databases
When using ColumnStore, MariaDB Server creates a series of system databases used for operational purposes.
| Database | Description |
|---|---|
calpontsys |
Database maintains table metadata about ColumnStore tables. |
infinidb_querystats |
Database maintains information about query performance. For more information, see Query Analysis. |
infinidb_vtable |
Database used in creation of temporary tables in query execution. This database only exists in ColumnStore 1.2 and below. In those versions, users executing ColumnStore queries must have CREATE TEMPORARY TABLE privilege on this database. For more information, see User Management. |
columnstore_info |
Database for stored procedures used to retrieve information about ColumnStore usage. For more information, see the ColumnStore Information Schema tables. |
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/columnstore-system-databases/