inoodb should be used only in this following case

[bobbymc]

my vicidial_log table has gotten so big that it started to lock up.. i understand it should be archived and processed into a detailed table and etc.. but if that's not a option i found innodb for that specific table ONLY to be a perfect solutions.. So i recommend if you got over 10 million records in that table.. change it to innodb

[williamconley]

newer versions allow pushing to a report server, on which innodb would certainly be a good idea for a table this large.

[mflorell]

You could still have problems with InnoDB and that table. Any reason you are not using the archive script?

[bobbymc]

stuck on a old version 2.0.5rc5 =(

[mcargile]

InnoDB does not do table level locking. It does row level locking. This is why it performs so well. However Vicidial REQUIRES table level locking. Without it you will have concurrency problems. You are probably having them right now and just not noticing it. I recommend downloading a copy of the archive script and see what it is doing, and then manually perform those actions on your load tables.