[MDEV-11416] AliSQL: [Feature] Issue#25 THROTTLE IOPS FOR SQL STATEMENT Created: 2016-11-29  Updated: 2021-11-02

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Sergey Vojtovich Assignee: Vladislav Vaintroub
Resolution: Unresolved Votes: 0
Labels: None

Epic Link: AliSQL patches

 Description   

Description:
------------
Export three status variables: logical_read, phsical_read and physical_async_read for buffer pool hit read,
buffer pool miss sync read, and buffer pool miss async read respectively
 
Export session variable rds_sql_max_iops to control the IO usage for single sql statement
 
ex:
set session rds_sql_max_iops=100;
 
When sql execution returning from innodb to server layer, it will check whether IOPS is oversubscribed,
if so it might sleep some delta time to prevent from overkilling I/O bandwith for single sql statement

https://github.com/alibaba/AliSQL/commit/97d77c95f86523427efc2b21b65372d6acfbdbcf


Generated at Thu Feb 08 07:49:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.