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