ColumnStore System Databases

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

When using ColumnStore, MariaDB Server creates a series of system databases used for operational purposes.

DatabaseDescription
calpontsysDatabase maintains table metadata about ColumnStore tables.
infinidb_querystatsDatabase maintains information about query performance. For more information, see Query Analysis.
infinidb_vtableDatabase 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_infoDatabase for stored procedures used to retrieve information about ColumnStore usage. For more information, see the ColumnStore Information Schema tables.

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.