Vicidial list_table_lagged

[ruben23]

Multi Server- 2DBRelication M/S(HA,HearBeat/MON),Web(Proxmox_VMs-LoadBalance),3-telephony
ASterisk 1.4.27-vici
Dahdi-current
2.4 svntrunk
Ubuntu server 10.04 LTS
Scracth Install
VERSION: 2.6
© 2012 ViciDial Group


Hi guys i have issue for having huge data on my vicidial.list tables and somehow causing lagged and CPU core spike, how do i resolve this issue any script who can archive this somehow to lessen up the load.Thanks

[DomeDan]

I guess this is the script your looking for

/usr/share/astguiclient/ADMIN_archive_log_tables.pl:

Code: Select all

# ADMIN_archive_log_tables.pl
#
# This script is designed to put all  records from call_log, vicidial_log and
# vicidial_agent_log in relevant _archive tables and delete records in original
# tables older than X months from current date. Also, deletes old
# server_performance table records without archiving them as well as optimizing
# all involved tables.
#
# Place in the crontab and run every month after one in the morning, or whenever
# your server is not busy with other tasks
# 30 1 1 * * /usr/share/astguiclient/ADMIN_archive_log_tables.pl
#
# NOTE: On a high-load outbound dialing system, this script can take hours to
# run. While the script is running the system is unusable. Please schedule to
# run this script at a time when the system will not be used for several hours.


If the DB-server is running the cron-scripts then the mix and compress scripts might causing some load too,
do you record all calls etc? if yes, then you can reduce the load by using "Recording Delay" or consider some other recording option.

Are you using "System Performance" logging? disabling that will prevent a couple of inserts.

under phone settings there is "Fast Refresh" and "Fast Refresh Rate", if it is enabled and the value is low there will be more load on the system.

Is the load issue all the time? if not then find out when it happens and look what is being executed at that time.

have you enabled the option to let the slave-DB handle some report-querys?

keep an eye on similar post like this one viewtopic.php?f=3&t=26056

[williamconley]

Be sure the database is optimized nightly and archive the LOG tables as often as possible. Ordinarily the log tables are the problem more than the vicidial_list itself. If the vicidial_list table is a problem and you've optimized recently, the only solutions are to stop running the query that slows you down (if it's not part of the required vicidial background functions) or reduce the size of the list. There is another recent thread on this same topic with a more in-depth discussion. Have a google for it.

[ruben23]

@williamconley

Yes tried googling for some thread related to this but no success, so far any help on the link.Thanks

[williamconley]

Have you identified the query that lags you?