MOT Usage

PublishedApril 26, 2023

MOT Usage

Using MOT tables is quite simple and is described in the few short sections below.

openGauss enables an application to use of MOT tables and standard disk-based tables. You can use MOT tables for your most active, high-contention and throughput-sensitive application tables or you can use MOT tables for all your application's tables.

The following commands describe how to create MOT tables and how to convert existing disk-based tables into MOT tables in order to accelerate an application's database-related performance. MOT is especially beneficial when applied to tables that have proven to be bottlenecks.

Workflow Overview

The following is a simple overview of the tasks related to working with MOT tables –

#opengauss

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Default Permission Mechanism

Default Permission Mechanism A user who creates an object is the owner of this object. By default, Separation of Duties is disabled after database installation. A database system administrator has the same permissions as object owners. After an objec...

Apr 26, 20232 min read

Replacing Certificates

Replacing Certificates Scenarios Default security certificates and private keys required for SSL connection are configured in openGauss. You can change them as needed. Prerequisites The formal certificates and keys for the server and client have been...

Apr 26, 20232 min read

Generating Certificates

Generating Certificates Scenarios In the test environment, users can use either of the following methods to test digital certificates. In a customer's operating environment, only a digital certificate obtained from a CA can be used. Prerequisites The...

Apr 26, 20237 min read

Checking the Number of Database Connections

Checking the Number of Database Connections Background If the number of connections reaches its upper limit, new connections cannot be created. Therefore, if a user fails to connect a database, the administrator must check whether the number of conne...

Apr 26, 20233 min read

Establishing Secure TCP/IP Connections in SSH Tunnel Mode

Establishing Secure TCP/IP Connections in SSH Tunnel Mode Background To ensure secure communication between the database server and its clients, secure SSH tunnels can be established between the database server and clients. SSH is a reliable security...

Apr 26, 20232 min read

Untitled Publication

133 posts

Command Palette

MOT Usage

Comments

More from this blog