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
|