Table Optimize query in Keep Alive perl file

All installation and configuration problems and questions

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

Table Optimize query in Keep Alive perl file

Postby OVS » 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.
OVS
 
Posts: 6
Joined: Thu Jul 01, 2010 6:55 am

Re: Table Optimize query in Keep Alive perl file

Postby mflorell » 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.
mflorell
Site Admin
 
Posts: 18383
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: MSN [Bot] and 47 guests