Insights from Alibaba Cloud Experts: 3 Ways to Deal with High Concurrency

1) Thread Pool

1.1) Model

1.2) Applicable Scenarios

1.3) Summary

2) Throttling

2.1) Statement Concurrency Control

# High-cost slow queries
select count(*)
from jacky.mytab
where cid = 90363
or uid = ???
# Add a throttling rule to allow a maximum of one concurrent execution
call dbms_ccl.add_ccl_rule('select','jacky','mytab',1,'cid=;uid=');
# Display the current throttling rule
call dbms_ccl.show_ccl_rule();
+------+--------+--------+-------+-------+-------+-------------------+---------+---------+----------+-----------+
| ID | TYPE | SCHEMA | TABLE | STATE | ORDER | CONCURRENCY_COUNT | MATCHED | RUNNING | WAITTING | KEYWORDS |
+------+--------+--------+-------+-------+-------+-------------------+---------+---------+----------+-----------+
| 2 | SELECT | jacky | mytab | Y | N | 1 | 116 | 1 | 26 | cid=;uid= |
+------+--------+--------+-------+-------+-------+-------------------+---------+---------+----------+-----------+

2.2) DAS Throttling

3) Keep the Enemy Outside

3.1) Terminology

3.2) Short-lived Connection Optimization

Original Source:

--

--

--

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Flutter is no longer a cross-platform framework — it is something more.

How to Disable iOS/iPad App availability on Mac Store, Silicon?

Demystifying Linux 101: File System and the permission conflict.

MongoDB Authentication in a React and Nodejs project

Recap of AMA with Anatoly and SolRazr on 14th October 2021

Basic Fiori Customization App and Launchpad Configuration

Is it a bug? Change via defects

My approach to Xamarin architecture explained with Asimov References ☀️ 🚀

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

More from Medium

Using Athena Views As A Source In Glue

Challenges that I faced during working with AWS Neptune and Gremlin on 20 GB data, and how I…

SALESFORCE DATA EXTRACT INTO S3 BUCKET WITH USING AWS GLUE ETL JOB AND VIEW WITH ATHENA

DevOps Practices