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?