VICI dial tables backup

[fredrick]

Hello all,

I have a BPO setup, where thousands of calls are initiated per day.

everything is fine about calls but i'm afraid of mysql tables in asterisk/vtigercrm databases which will have lacks of rows and i expect on one fine day one or more tables will be crashed !!!

my call_log table for 4 days have 118,026 rows !!!

Please let me know is there any mechanism to fix/monitor/avoid this problem.

[mflorell]

We recommend rolling the call_log/vicidial_log tables into archive tables periodically. We have some clients that have placed hundreds of millions of calls without issues of their databases crashing. Of course their systems were properly sized to the applications and were built by us.