VICIdial database tables crash recovery : how to

[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.

[boybawang]

For a quick way you can install phpmyadmin and do a repair table

[mflorell]

Please don't double-post

[spaquet]

Easy. Here is what I'm doing:

1. Every night when my MySQL Servers are not loaded I'm running a cron job to repair all tables.

Repair command on MySQL also "compacts and reindexes" tables. So running it on a regular basis improves database performances.

2. Do not forget to do some mysqldump (backup actually). I let you see what's the best frequency for backup according to your data criticity.

Hope this will help you.

Bests