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';