* [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly #7061 (#7139)
1、I found that the SQL behind this interface is very slow. The main table is large, but there is no index to use. By add the index, the all mode in the query plan can be changed into a more efficient ref mode. If this optimization still fails to meet the requirements, please contact me and I will continue to optimize。
2、modify index start_time_index in init script and upgrade scripts.
* [BUG][SQL] fix the process list page load slowly. (#7166)
* fix#7601 move ddl to 2.0.1
* fix#7601 move ddl to 2.0.1
* [2.0.1] remove unused foreign_key
* [2.0.1] add version in sql
* [2.0.1] change serial for postgre
* [2.0.1] set h2 for default DATABASE_TYPE for standalone-server
Co-authored-by: GaoTianDuo <gaotianduo_yewu@cmss.chinamobile.com>
* [Fix-7291][datasource] Compatible with different versions of MySQL data source loading (#7291)
* [Fix-7291][datasource] Compatible with different versions of MySQL data source loading (#7291)
* [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly #7061 (#7139)
1、I found that the SQL behind this interface is very slow. The main table is large, but there is no index to use. By add the index, the all mode in the query plan can be changed into a more efficient ref mode. If this optimization still fails to meet the requirements, please contact me and I will continue to optimize。
2、modify index start_time_index in init script and upgrade scripts.
* [BUG][SQL] fix the process list page load slowly. (#7166)
* fix#7601 move ddl to 2.0.1
* fix#7601 move ddl to 2.0.1
* [2.0.1] remove unused foreign_key
* [2.0.1] add version in sql
* [2.0.1] change serial for postgre
Co-authored-by: GaoTianDuo <gaotianduo_yewu@cmss.chinamobile.com>
For now when we create new user, it would see homepage
statisic info as admin user like, cause `projectCodeArray`
would not filter when we render sql. So I add prefix condition
to handle this situation.
fix#7182
Kerwin
uh001
lenboo
mask
BaoLiang
wind
Kirs
songjianet
jon-qj
JinYong Li
kezhenxu94
Jiajie Zhong
CalvinKirs