Reports take a long time and freeze calls

All installation and configuration problems and questions

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

Reports take a long time and freeze calls

Postby saulortega » Thu Jul 13, 2017 4:36 pm

In some reports, like Inbound by DID, the queries with a filter of only one day take a long time, until one or two minutes, and after first 30 seconds (aproximately) Asterisk freezes and inbound calls are dropped or remain silent for several seconds. The mysqld pid is in more than 100%.

I consider that the operation is soft for the server:

All campaigns in Inbound.
20 calls simultaneusly.
25 agents.
Intel 12 cores 2,2 GHz
8 GB ram
HDD 15K rpm.

VERSION: 2.14-601a
BUILD: 170315-0633

Is it possible to optimize this?
saulortega
 
Posts: 118
Joined: Mon Jul 29, 2013 11:46 am

Re: Reports take a long time and freeze calls

Postby mflorell » Thu Jul 13, 2017 5:36 pm

Either archive your old logs or get a separate slave database server to run your reports on.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

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