viewtablelock for MariaDB Enterprise ColumnStore 5.6
This page is part of MariaDB's Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Enterprise ColumnStore 5.6
Topics on this page:
Overview
The viewtablelock
utility shows table locks currently held by MariaDB Enterprise ColumnStore 5.6.
Reference material is available for MariaDB Enterprise ColumnStore 5.6.
MariaDB Enterprise ColumnStore 5.6 is included with MariaDB Enterprise Server 10.5.
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