Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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