Switching ViciDial tables from MyISAM to InnoDB

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Switching ViciDial tables from MyISAM to InnoDB

Postby basha04 » Mon Feb 27, 2023 3:49 am

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 !
basha04
 
Posts: 11
Joined: Tue Oct 18, 2022 3:14 am
Location: Tirana , Albania

Re: Switching ViciDial tables from MyISAM to InnoDB

Postby mflorell » Mon Feb 27, 2023 7:30 am

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Switching ViciDial tables from MyISAM to InnoDB

Postby basha04 » Mon Feb 27, 2023 7:53 am

Thank you Matt.
I will keep the tables MyISAM.
basha04
 
Posts: 11
Joined: Tue Oct 18, 2022 3:14 am
Location: Tirana , Albania


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 73 guests