vicidial.org

Posted: **Tue Oct 01, 2024 4:54 am**

SCRATCH INSTALL| Single Server | No Extra Software After Installation |Intel Xeon Quad Core | 16GiB RAM |
OS- CentOS 7.10
Vicidial Version installed : VERSION: 2.14-871a
Asterisk : Asterisk 13.29.2
DAHDI : DAHDI Version: 3.3.0

While going through keepalive perl file we found that it is optimizing table. Wanted to know whether this will impact the DB while optimizing the table and calls will be stuck when the perl file is run.

Posted: **Tue Oct 01, 2024 7:37 am**

There are a lot of table optimizes in that script, which specific one are you concerned about?

These table optimizes are usually either run at the Timeclock-end-of-day or the ones that are run during the day are for small tables, so they shouldn't have any performance impact.

vicidial.org

Table Optimize query in Keep Alive perl file

Table Optimize query in Keep Alive perl file

Re: Table Optimize query in Keep Alive perl file