How to convert ar_activity table engine from MyIsam to InnoDB?

OpenEMR Development
, ,
#1

Hi All,

I’m facing slow query issues with ar_activity table huge data.
I’m trying to convert ar_activity table engine to InnoDB but sequence_no value not increment properly and getting issues.

Please help me to convert ar_activity table engine from MyIsam to InnoDB.

Thanks.

#2

hi @dorareddys, OpenEMR v5.0.0 is InnoDB, please see this link

#3

How to convert my existing ar_activity table to InnoDB.
My existing table had so much data. How can i change table engine to InnoDB without any impact to existing records.

#4

you can upgrade to 5.0.0 and beyond