28 lines
1.3 KiB
SQL
28 lines
1.3 KiB
SQL
-- 第三方支付日志分页索引；在 pjcloudx_thirdparty 库执行。
|
|
-- 默认列表按租户、逻辑删除标识和创建时间查询；组合筛选增加发起方、接口类型。
|
|
-- req/res/header 等内容的 LIKE '%关键字%' 不使用 B-tree 定位，请配合请求时间缩小范围。
|
|
|
|
SET @tpl_index_ddl = IF(
|
|
(SELECT COUNT(*) FROM information_schema.statistics
|
|
WHERE table_schema = DATABASE() AND table_name = 'third_pay_log'
|
|
AND index_name = 'idx_tpl_tenant_del_ct_id') = 0,
|
|
'ALTER TABLE third_pay_log ADD INDEX idx_tpl_tenant_del_ct_id (tenant_id, del_flag, create_time, id), ALGORITHM=INPLACE, LOCK=NONE',
|
|
'SELECT 1'
|
|
);
|
|
PREPARE tpl_index_stmt FROM @tpl_index_ddl;
|
|
EXECUTE tpl_index_stmt;
|
|
DEALLOCATE PREPARE tpl_index_stmt;
|
|
|
|
SET @tpl_index_ddl = IF(
|
|
(SELECT COUNT(*) FROM information_schema.statistics
|
|
WHERE table_schema = DATABASE() AND table_name = 'third_pay_log'
|
|
AND index_name = 'idx_tpl_tenant_del_source_biz_ct_id') = 0,
|
|
'ALTER TABLE third_pay_log ADD INDEX idx_tpl_tenant_del_source_biz_ct_id (tenant_id, del_flag, pay_source_type, biz_type, create_time, id), ALGORITHM=INPLACE, LOCK=NONE',
|
|
'SELECT 1'
|
|
);
|
|
PREPARE tpl_index_stmt FROM @tpl_index_ddl;
|
|
EXECUTE tpl_index_stmt;
|
|
DEALLOCATE PREPARE tpl_index_stmt;
|
|
|
|
SET @tpl_index_ddl = NULL;
|