viewtablelock for MariaDB Enterprise ColumnStore 22.08

This page is part of MariaDB's Documentation.

The parent of this page is: Command-Line Interfaces for MariaDB Enterprise ColumnStore 22.08

Topics on this page:

Overview
USAGE
DETAILS
EXAMPLES
- View All Table Locks
- View Table Locks for Specific Table

Overview

The viewtablelock utility shows table locks currently held by MariaDB Enterprise ColumnStore 22.08.

Reference material is available for MariaDB Enterprise ColumnStore 22.08.

MariaDB Enterprise ColumnStore 22.08 is included with MariaDB Enterprise Server 10.6.

USAGE

The syntax for the viewtablelock utility is:

$ viewtablelock [DATABASE TABLE]

If a database and table are not specified, the utility shows table locks held for all databases and tables.

DETAILS

The viewtablelock utility shows table locks currently held by MariaDB Enterprise ColumnStore.

cleartablelock is a similar utility that clears table locks.

For additional information, see "MariaDB Enterprise ColumnStore Viewing and Clearing Table Locks".

EXAMPLES

View All Table Locks

To view all table locks:

$ viewtablelock
 There is 1 table lock

  Table                     LockID  Process   PID    Session   Txn  CreationTime               State    DBRoots
  hq_sales.invoices         1       cpimport  16301  BulkLoad  n/a  Wed April 7 14:20:42 2021  LOADING  1

View Table Locks for Specific Table

To view table locks for a specific table, specify the database and table:

$ viewtablelock hq_sales invoices
 There is 1 table lock

  Table                     LockID  Process   PID    Session   Txn  CreationTime               State    DBRoots
  hq_sales.invoices         1       cpimport  16301  BulkLoad  n/a  Wed April 7 14:20:42 2021  LOADING  1