inoodb should be used only in this following case

Discussions about development of VICIDIAL and astGUIclient

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

inoodb should be used only in this following case

Postby bobbymc » Tue Mar 03, 2009 5:56 pm

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
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am

Postby williamconley » Sun Dec 12, 2010 4:38 pm

newer versions allow pushing to a report server, on which innodb would certainly be a good idea for a table this large.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby mflorell » Mon Dec 13, 2010 10:28 am

You could still have problems with InnoDB and that table. Any reason you are not using the archive script?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: inoodb should be used only in this following case

Postby bobbymc » Mon Jul 16, 2012 4:56 pm

stuck on a old version 2.0.5rc5 =(
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am

Re: inoodb should be used only in this following case

Postby mcargile » Mon Aug 13, 2012 7:55 am

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.
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

The official source for VICIDIAL services and support. 1-888-894-VICI (8424)
mcargile
Site Admin
 
Posts: 614
Joined: Tue Jan 16, 2007 9:38 am


Return to Development

Who is online

Users browsing this forum: No registered users and 46 guests