ColumnStore System Databases

You are viewing an old version of this article. View the current version here.

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

Comments

Comments loading...
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.