Help Center > > User Guide> Intelligent O&M> Intelligent O&M for RDS for MySQL and GaussDB(for MySQL) DB Instances> SQL> SQL Statement Concurrency Control

SQL Statement Concurrency Control

Updated at: Jun 09, 2021 GMT+08:00

Scenarios

SQL statement concurrency control aims to keep MySQL DB instances running stably in the case of high SQL statement concurrency.

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. Locate your desired instance and click Details to go to the Intelligent O&M overview page.
  4. Choose SQL > SQL Statement Concurrency Control.

    Figure 1 SQL Statement Concurrency Control

  5. On the displayed page, enable SQL Statement Concurrency Control.
  6. Click Add Concurrency Control Rule. On the displayed page, select the SQL statement type and set the keyword and maximum concurrency.

    Figure 2 Add Concurrency Control Rule

    Keyword: Take SELECT~a>1 as an example. SELECT and a>1 are the two keywords contained in the concurrency control rule. The keywords are separated by ~. In this example, to trigger this concurrency rule, keywords SELECT and a>1 must be contained in the SQL command.

    Max. Concurrency: Maximum number of concurrent statements meeting the same rule. If the concurrent statements exceed the upper limit, they will not be executed.

  7. Confirm the settings and click OK.
  8. If a rule is no longer needed, click Delete to delete the rule. In the displayed dialog box, click OK.

    Figure 3 Prompt

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel