Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11416

AliSQL: [Feature] Issue#25 THROTTLE IOPS FOR SQL STATEMENT

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

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            wlad Vladislav Vaintroub
            svoj Sergey Vojtovich
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.