Flowable v6.5.0 Mysql Version Upgrade from 5.7 to 8

Flowable Engine
1

I am using Flowable v6.5.0 and recently upgraded the version of mysql database from v5.7 to v8.0.33 which linked to flowable app.

While upgrading database version it updated the existing charset i.e utf8mb3 for 40 tables.

Also I added some manual indexes on flowable tables to optimise queries, indexes are listed below:

  1. CREATE INDEX idx_id_rev ON ACT_GE_BYTEARRAY (ID_, REV_);

  2. CREATE INDEX idx_ref_scope_id_type_link_type ON ACT_RU_ENTITYLINK (REF_SCOPE_ID_, REF_SCOPE_TYPE_, LINK_TYPE_);

  3. CREATE INDEX idx_id_rev ON ACT_RU_HISTORY_JOB (ID_, REV_);

  4. CREATE INDEX idx_scope_type_lock_exp_time ON ACT_RU_HISTORY_JOB (SCOPE_TYPE_, LOCK_EXP_TIME_, CREATE_TIME_);

Questions:

Q1. Does this update of mysql version and up-gradation of charset cause any issue in flowable?

Q2. Manually adding indexes to flowable tables can have a affect on flowable?

2

Hey @ali.dal,

Flowable shouldn’t really be affected by this.

Depending on the added index there can be an impact on the insert, i.e. it might slow it down. The first and third index don’t really make sense to me, as the ID_ is the primary key, so adding an additional index on ID_ and REV_ does not really bring any benefits.

The 2nd index was already added in 6.7.0.

The 4th index shouldn’t be needed really. Can you explain why you needed it?

Cheers,
Filip