GoAgent very slow and data doesn't appear in the form

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

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

GoAgent very slow and data doesn't appear in the form

Postby brando16 » Wed Jul 20, 2016 4:14 am

Hi All,

i have some slowdowns of working goagent when the call arrive to the telephone the web screen goagent doesn't populate the fields, or populate after 30 seconds.
This is big issue for us because the operator doesn't see any information of caller for 30 second and manage call is very difficult.

Someone have idea what happens?

Any help would be appreciated!!!
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: GoAgent very slow and data doesn't appear in the form

Postby brando16 » Thu Jul 21, 2016 3:58 am

I check the process of server and i find mysql to 270% and then i check the table and all log table are 2 milions and more of record, but in crontab i have the script for optimize mysql and archive all log table native of vicidial but doens't work because the tables are empty!!!

Any idea?
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: GoAgent very slow and data doesn't appear in the form

Postby lasthuman » Mon Aug 01, 2016 9:51 am

hello,

do you have voice break ups too?

did you check your process that are running.?

please check mysql indexes.

let me know.
Omar Aparicio
skype: omar.aparicio82
https://co.linkedin.com/in/oaparicioit
Vicidial - Goautodial - Asterisk Consultant.
Colombia.
lasthuman
 
Posts: 20
Joined: Thu Jan 24, 2013 2:33 pm
Location: colombia

Re: GoAgent very slow and data doesn't appear in the form

Postby brando16 » Mon Aug 01, 2016 10:25 am

I archivied vicidial_log table and the server go down to 20-30% of load !!! Because a lot of query relative to goautodial screen are in vicidial_log table and have 2 and more record!!!

i hope help anyone to understand that distro require a lot of developed because all query must do on _archive tables insted _log and the archive operation must be default.

Bye
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: GoAgent very slow and data doesn't appear in the form

Postby williamconley » Wed Aug 03, 2016 10:38 am

brando16 wrote:I archivied vicidial_log table and the server go down to 20-30% of load !!! Because a lot of query relative to goautodial screen are in vicidial_log table and have 2 and more record!!!

i hope help anyone to understand that distro require a lot of developed because all query must do on _archive tables insted _log and the archive operation must be default.

Bye

Consider upgrading to the latest version of Vicidial. It has a "Search Archived Data" checkbox on many reports.

If you re-install with Vicibox (Available at Vicibox.com) and then upgrade your database to match the new Vicidial version, you'll have the most recent Vicidial and all your data. 8-)
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!)


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: Google [Bot] and 38 guests