How to convert ar_activity table engine from MyIsam to InnoDB?

feature
billing
question

(Dora Reddy) #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.


(Stephen Waite) #2

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


(Dora Reddy) #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.


(Stephen Waite) #4

you can upgrade to 5.0.0 and beyond