vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/das/umn/das_05_0042.html
Wang , Deng Ke 0f41701050 DAS UMN Initial version 
Reviewed-by: gtema <artem.goncharov@gmail.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-10-18 12:51:00 +00:00

2.0 KiB
Raw Permalink Blame History

InnoDB Locks

Overview

With this function, the system displays the lock waits generated before the DML operations on the database in real time. With these waits, you can quickly locate the session waits and blocks that happened when multiple sessions update the same piece of data at the same time, and can quickly terminate the source session that holds locks to restore blocked operations.

This feature does not support DDL locks. You view and analyze them on the Metadata Locks page.

Procedure

  1. Log in to the DAS console using your username and password.
  2. On the Overview page, click Go to Intelligent O&M.
  3. Select the required instance and click Details to go to the Intelligent O&M overview page.
  4. Choose Locks and Transactions > InnoDB Locks to check whether there are lock waits.
Parent topic: Locks and Transactions