You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
use sqle;
ALTER TABLE sql_manages DROP COLUMN endpoint;
ALTER TABLE audit_plan_sqls_v2 DROP COLUMN endpoint;
ALTER TABLE `black_list_audit_plan_sqls` DROP INDEX `filter_sql`;
ALTER TABLE `black_list_audit_plan_sqls` CHANGE `filter_sql` `filter_content` VARCHAR(512) NOT NULL;
SET GLOBAL FOREIGN_KEY_CHECKS=0;
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
不兼容的变更内容
新版本的SQLE做了非兼容性变更,旧的SQLE升级到新SQLE需要额外的手动升级操作。相关issue:
actiontech/dms#120
https://github.com/actiontech/sqle-ee/issues/1229
https://github.com/actiontech/sqle-ee/issues/1272
#2154
版本升级方案
启动SQLE服务前
假设SQLE的元数据库名为"sqle",升级rpm包后,启动SQLE服务前,在元数据实例执行如下SQL:
修改配置文件,新增“auto_migrate”字段
启动SQLE服务后
启动SQLE服务后,在元数据实例执行如下SQL:
对于MySQL规则模板中启用了,索引优化标签下的 “索引创建建议” 的规则模板,需要手动编辑规则模板,将索引创建建议的 “列区分度最低值阈值(百分比)“ 修改为2
Beta Was this translation helpful? Give feedback.
All reactions