You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@inlong.apache.org by he...@apache.org on 2022/06/07 16:35:44 UTC

[incubator-inlong] branch master updated: [INLONG-4552][Manager] Add composite index for some tables in DDL (#4553)

This is an automated email from the ASF dual-hosted git repository.

healchow pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-inlong.git


The following commit(s) were added to refs/heads/master by this push:
     new 3c35b9922 [INLONG-4552][Manager] Add composite index for some tables in DDL (#4553)
3c35b9922 is described below

commit 3c35b9922c8634b4576664e6dd518998c94edc90
Author: kipshi <48...@users.noreply.github.com>
AuthorDate: Wed Jun 8 00:35:38 2022 +0800

    [INLONG-4552][Manager] Add composite index for some tables in DDL (#4553)
    
    * Add composite index for some tables in DDL
    
    * Add the limitation for the result set
    
    Co-authored-by: healchow <he...@gmail.com>
---
 .../src/main/resources/mappers/InlongGroupEntityMapper.xml       | 2 ++
 .../src/main/resources/sql/apache_inlong_manager.sql             | 9 ++++++---
 inlong-manager/manager-web/sql/apache_inlong_manager.sql         | 9 ++++++---
 3 files changed, 14 insertions(+), 6 deletions(-)

diff --git a/inlong-manager/manager-dao/src/main/resources/mappers/InlongGroupEntityMapper.xml b/inlong-manager/manager-dao/src/main/resources/mappers/InlongGroupEntityMapper.xml
index e66783ede..ddf861337 100644
--- a/inlong-manager/manager-dao/src/main/resources/mappers/InlongGroupEntityMapper.xml
+++ b/inlong-manager/manager-dao/src/main/resources/mappers/InlongGroupEntityMapper.xml
@@ -156,6 +156,7 @@
             </if>
         </where>
         order by modify_time desc
+        limit 100
     </select>
     <select id="selectBriefList" parameterType="org.apache.inlong.manager.common.pojo.group.InlongGroupPageRequest"
             resultType="org.apache.inlong.manager.common.pojo.group.InlongGroupBriefInfo">
@@ -183,6 +184,7 @@
             </if>
         </where>
         order by modify_time desc
+        limit 100
     </select>
 
     <update id="updateByPrimaryKey" parameterType="org.apache.inlong.manager.dao.entity.InlongGroupEntity">
diff --git a/inlong-manager/manager-test/src/main/resources/sql/apache_inlong_manager.sql b/inlong-manager/manager-test/src/main/resources/sql/apache_inlong_manager.sql
index 410a01962..09dca36ef 100644
--- a/inlong-manager/manager-test/src/main/resources/sql/apache_inlong_manager.sql
+++ b/inlong-manager/manager-test/src/main/resources/sql/apache_inlong_manager.sql
@@ -48,7 +48,8 @@ CREATE TABLE IF NOT EXISTS `inlong_group`
     `create_time`            timestamp    NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Create time',
     `modify_time`            timestamp    NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modify time',
     PRIMARY KEY (`id`),
-    UNIQUE KEY `unique_inlong_group` (`inlong_group_id`, `is_deleted`)
+    UNIQUE KEY `unique_inlong_group` (`inlong_group_id`, `is_deleted`),
+    INDEX group_status_deleted_idx (`status`, `is_deleted`)
 );
 
 -- ----------------------------
@@ -634,7 +635,8 @@ CREATE TABLE IF NOT EXISTS `workflow_event_log`
     `end_time`             datetime      DEFAULT NULL COMMENT 'Listener end time',
     `remark`               text COMMENT 'Execution result remark information',
     `exception`            text COMMENT 'Exception information',
-    PRIMARY KEY (`id`)
+    PRIMARY KEY (`id`),
+    INDEX group_status_idx (`inlong_group_id`, `status`)
 );
 
 -- ----------------------------
@@ -679,7 +681,8 @@ CREATE TABLE IF NOT EXISTS `workflow_task`
     `start_time`           datetime      NOT NULL COMMENT 'Start time',
     `end_time`             datetime      DEFAULT NULL COMMENT 'End time',
     `ext_params`           text COMMENT 'Extended information-json',
-    PRIMARY KEY (`id`)
+    PRIMARY KEY (`id`),
+    INDEX process_status_idx (`process_id`, `status`)
 );
 
 -- ----------------------------
diff --git a/inlong-manager/manager-web/sql/apache_inlong_manager.sql b/inlong-manager/manager-web/sql/apache_inlong_manager.sql
index 3557194e4..8e92b7abe 100644
--- a/inlong-manager/manager-web/sql/apache_inlong_manager.sql
+++ b/inlong-manager/manager-web/sql/apache_inlong_manager.sql
@@ -54,7 +54,8 @@ CREATE TABLE IF NOT EXISTS `inlong_group`
     `create_time`            timestamp    NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Create time',
     `modify_time`            timestamp    NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modify time',
     PRIMARY KEY (`id`),
-    UNIQUE KEY `unique_inlong_group` (`inlong_group_id`, `is_deleted`)
+    UNIQUE KEY `unique_inlong_group` (`inlong_group_id`, `is_deleted`),
+    INDEX group_status_deleted_idx (`status`, `is_deleted`)
 ) ENGINE = InnoDB
   DEFAULT CHARSET = utf8mb4 COMMENT ='Inlong group table';
 
@@ -675,7 +676,8 @@ CREATE TABLE IF NOT EXISTS `workflow_event_log`
     `end_time`             datetime      DEFAULT NULL COMMENT 'Listener end time',
     `remark`               text COMMENT 'Execution result remark information',
     `exception`            text COMMENT 'Exception information',
-    PRIMARY KEY (`id`)
+    PRIMARY KEY (`id`),
+    INDEX group_status_idx (`inlong_group_id`, `status`)
 ) ENGINE = InnoDB
   DEFAULT CHARSET = utf8mb4 COMMENT ='Workflow event log table';
 
@@ -722,7 +724,8 @@ CREATE TABLE IF NOT EXISTS `workflow_task`
     `start_time`           datetime      NOT NULL COMMENT 'Start time',
     `end_time`             datetime      DEFAULT NULL COMMENT 'End time',
     `ext_params`           text COMMENT 'Extended information-json',
-    PRIMARY KEY (`id`)
+    PRIMARY KEY (`id`),
+    INDEX process_status_idx (`process_id`, `status`)
 ) ENGINE = InnoDB
   DEFAULT CHARSET = utf8mb4 COMMENT ='Workflow task table';