by williamconley » Sun May 19, 2019 3:06 pm
I'm gonna toss a "guess" into this thread.
You've found that loading the hopper takes a long time. So you've dramatically increased the size of your hopper to reduce the number of times it slows the system down. Now your hopper is at 5k and it still hammers the system, but not as often.
IF this is true: you're doing it backwards. Reducing the hopper to the number of leads you will dial in one minute, in an otherwise properly configured system, allows a small hit every minute that doesn't hammer the system. Set the hopper level to 50 (or 5) and set it to automatic. Watch the hopper level, and if it never even considers hitting "zero" before it reloads, consider changing the hopper multiplier to a lower number. The less leads in the hopper, the less leads it "searches for" every minute. If you can get that down low enough there is NO sysem disruption during that search to load the hopper. Back in the earlier days of robodialing, this was a constant battle until these methods were adopted.
Of course, there are other causes for slowness during hopper load. For instance: more than 5M leads in the vicidial_list table can be problematic (archive or delete those not needed right now). Lots of reports being run (replication server!). But continuing to increase the hopper level can be problematic over time.
The Hopper DOES have a maximum level. It's a memory table. MyISAM memory tables have limits. Also worthy of note: The reason the hopper table exists is to reduce mysql load during "dial the next number". The goal is to have a small list from which the dialer will grab "the next lead" to dial instead of having to search the entire Vicidial List table. Growing the hopper table to huge levels defeats this purpose and loads up the mysql server having the opposite effect of that goal. Thus if you have campaigns not in use that have huge hoppers, deactivate them and clear their hoppers.
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