Meta table

The meta table is a table that maintains the information of the tables maintained by Machbase starting with m$.

Table of Contents

This table contains the names, columns, and indexes of logs and volatile tables created, modified, and deleted through Machbase DDL related operations. This meta table can not be arbitrarily changed by users and insertion, deletion and change of data are automatically performed internally in the system.
m$tables are top-level tables for holding metadata existing internally in Machbase.

Example of m$table;

mach> SELECT * FROM M$TABLES;
NAME                                      TYPE        ID                   USER_ID     COLCOUNT    
...............................................................................................
M$SYS_COLLECTOR_COLUMNS                   1           1000033              0           11
M$COLUMNS                                 1           1000028              0           12
M$SYS_COLUMNS                             1           1000027              0           12
M$SYS_INDEX_COLUMNS                       1           1000030              0           8
M$SYS_TABLESPACE_DISKS                    1           1000015              0           8
M$SYS_COLLECTORS                          1           1000032              0           20
M$SYS_TABLES                              1           1000023              0           7
M$TABLES                                  1           1000025              0           7
M$SYS_INDEXES                             1           1000029              0           8
M$SYS_USERS                               1           1000031              0           4
M$SYS_TABLESPACES                         1           1000012              0           5
[11] row(s) selected.

M$TABLES

It shows a list of all the metadata tables.

Table 1. Description of Column

Name of column Description
NAME Name of table
TYPE Data type
ID Serial ID
USER ID User ID
COLCOUNT Number of columns

M$SYS_TABLES

It shows a user's table list.

Table 2. Description of column

Name of column Description
NAME Name of table
TYPE Data type
ID Serial ID
USER ID User ID
COLCOUNT Number of columns

M$COLUMNS

It shows a list of all the columns consist of all the metadata tables.

Table 3. Description of column

Name of column Description
NAME Name of a column
TYPE Type of a column
ID Serial ID of a column
LENGTH Size of a column
TABLE_ID Table ID of the table
FLAG Internal use
PART_PAGE_COUNT Number of pages in a partition
PAGE_VALUE_COUNT Number of column values in a single page
MINMAX_CACHE_SIZE Buffer size for MINMAX cache
MAX_CACHE_PART_COUNT Maximum number of partition cache

M$SYS_COLUMNS

It shows a list of all the columns that comprise the user table.

Table 4. Description of column

Name of column
Description
NAME Name of a column
TYPE Type of a column
ID Serial ID of a column
LENGTH Size of a column
TABLE_ID Table ID of the table
FLAG Internal use
PART_PAGE_COUNT Number of pages in a partition
PAGE_VALUE_COUNT Number of column values in a single page
MINMAX_CACHE_SIZE Buffer size for MINMAX cache
MAX_CACHE_PART_COUNT Maximum number of partition cache

M$SYS_TABLESPACES

It shows a list of user tablespaces.

Table 5. Description of column

Name of column Description
NAME Name of tablespace
ID Tablespace ID
DISK_COUNT The number of disks in the tablespace

M$SYS_INDEXES

It shows the list of user indexes.

Table 6. Description of column

Name of column Description
NAME Name of a column
TYPE Data type of a column
ID Serial ID of a column
TABLE_ID ID of the table
COLCOUNT Number of columns
PART_VALUE_COUNT Number of columns in a partition
KEY_COMPRESS It checks whether to store the compressed key value of the index.

M$SYS_INDEX_COLUMNS

It shows the information of columns that comprise the index.


Table 7. Description of column

Name of column Description
INDEX_ID Index ID
INDEX_TYPE Index type
NAME Name of index
COL_ID Column ID
TABLE_ID Table ID
TYPE Index type

M$SYS_COLLECTORS

It displays the information of collectors registered in Machbase.

Table 8. Description of column

Name of column Name of column
COLLECTOR_ID Collector ID
COLLECTOR_NAME Name of collector
TABLE_NAME Name of log table
TEMPLATE_NAME Name of template file
COLLECTOR_TYPE Collector type
COLLECTOR_SOURCE Location of log file
COLLECTOR_LIB Library for collector
COL_COUNT Number of columns
APPEND_MODE Input mode
REGEX Regular expression
NEWLINE_REGEX Expression of beginning a newline character
DEFAULT_ADDR Default IP address
LANGUAGE Language setting (UTF.8)
DB_ADDR machbased Server IP address
DB_PORT machbased Server PORT
DB_USER machbased Server User Name
DB_PASS machbased Server User Password
RUN_FLAG Indicates whether the collector is running or not.

M$SYS_COLLECTOR_COLUMNS

It displays the column information of each collector registered in Machbase.

Table 9. Description of column

Name of column Description
COLLECTOR_ID Collector ID
COL_ID Column ID
NAME Column name
TYPE_NAME Name of column type
DATE_FORMAT Date format
TYPE_CODE Code type
SIZE Column length
USE_INDEX Whether to use the index or not
REGEX_NO Column number of results from regular expressions

M$SYS_TABLESPACE_DISKS

{#msystablespacedisks}

It displays the information of all the disks of Machbase.

Table 10. Description of column

Name of column Description
Name Name of disk
ID Disk ID
TABLESPACE_ID Tablespace ID of the disk
PATH Location of file system of disk
IO_THREAD_COUNT Number of I/O threads assigned to the disk

M$SYS_USERS

{#msysusers}

It displays the information about all the users in the Machbase.

Table 11. Description of column

Name of column Description
USER_ID User ID
NAME Name of ID

results matching ""

    No results matching ""