vicidial.org

Hello,

I have a question regarding the Engine of the ViciDial tables, especially call_log, recording_log, vicidial_closer_log, vicidial_log and vicidial_list.

All the above mentioned tables are MyISAM , meaning that the tables will be locked for every select.
My question is, would it cause issue if I switch the tables to InnoDB ?

I have already change vicidial_list to InnoDB in one of my systems , until now I haven't face any error or been notified for a problem.

Further details.
DB Version: 10.5.8-MariaDB | MySQL 5.7.39-log.
VERSION: 2.14-854a | VERSION: 2.8-420a
BUILD: 220429-1111 | BUILD: 131210-1741
© 2022 ViciDial Group | © 2013 ViciDial Group


Thank you !

We strongly recommend you don't do this. InnoDB does NOT preserve Query Queue place-in-line NOR does it wait for queries to complete on busy systems so it just "deadlocks" and discards waiting queries under higher load. These can result in all kinds of problems on moderate to high load systems.

Thank you Matt.
I will keep the tables MyISAM.