Analyse the performance issues from mysql 5.6 to mysql 5.7

Description

As part of BAH-1051 card, we added a provision to install mysql either 5.6/5.7 with bahmni 0.92 installation. The version can be passed as parameter from setup.yml file.

As part of this card we have to analyse why the performance has gone down from mysql 5.6 to 5.7. And this analysis would be useful for upgrading to latest mysql version 8 for upcoming bahmni releases.

We have not seen performance impact on all the implementation but specific to few where we have so much of obs data. Below is one such example where we have performance impact with mysql 5.7

Assignee

Unassigned

Reporter

Himabindu Thungathurty

Labels

None

Units

None

PercentDone

None

DueTime

None

Clients

None

External issue ID

None

UAT Assignee

None

Reviewer

None

Sprint

0.93 Product M3

Fix versions

Configure