JFIF$        dd7 

Viewing File: /usr/local/cpanel/scripts/optimize_eximstats

#!/usr/local/cpanel/3rdparty/bin/perl

# cpanel - scripts/optimize_eximstats              Copyright 2022 cPanel, L.L.C.
#                                                           All rights reserved.
# copyright@cpanel.net                                         http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited

package scripts::optimize_eximstats;

use strict;
## no critic qw(TestingAndDebugging::RequireUseWarnings) -- not fully vetted for warnings

use parent qw( Cpanel::HelpfulScript );

our $VERSION  = 1.4;
our $PID_FILE = '/var/run/optimize_eximstats.pid';

use Cpanel::Alarm                ();
use Cpanel::DiskCheck            ();
use Cpanel::EximStats::ConnectDB ();
use Cpanel::EximStats::Constants ();
use Cpanel::PIDFile              ();
use Cpanel::Sys::Load            ();

use File::Basename ();

=encoding utf-8

=head1 NAME

scripts::optimize_eximstats

=head1 SYNOPSIS

    /usr/local/cpanel/scripts/optimize_eximstats

=head1 DESCRIPTION

This script is used to vacuum (defragment) the eximstats database.

=cut

__PACKAGE__->new(@ARGV)->run() if !caller();

sub _OPTIONS {
    return;
}

sub run {
    my ($self) = @_;

    $self->has_required_diskspace();

    Cpanel::PIDFile->do(
        $PID_FILE,
        sub {
            my $main_alarm = Cpanel::Alarm->new( 2 * 60**2, sub { die "optimize_eximstats ran for longer then two hours."; } );
            $self->vacuum_database();
        }
    );

    return;
}

sub vacuum_database {
    my ($self) = @_;

    local $ENV{'SQLITE_TMPDIR'} = File::Basename::dirname($Cpanel::EximStats::Constants::EXIMSTATS_SQLITE_DB);
    my $dbh = Cpanel::EximStats::ConnectDB::dbconnect();

    my ( $load_one, $load_five, $load_fifteen ) = Cpanel::Sys::Load::getloadavg($Cpanel::Sys::Load::ForceFloat);

    $load_one = sprintf( "%.05f", $load_one );    # Reduce precision on load_one to avoid divide by zero below (FPU fun)

    print "Optimizing eximstats (current load avg: $load_one)......";
    $dbh->do('VACUUM;');
    print "Done\n";
    my ( $post_load_one, $post_load_five, $post_load_fifteen ) = Cpanel::Sys::Load::getloadavg($Cpanel::Sys::Load::ForceFloat);

    print "Load before optimize: $load_one, Load after optimize: $post_load_one.\n";
    print "Optimization complete.\n";

    return;
}

sub has_required_diskspace {
    my ($self) = @_;

    # from: https://sqlite.org/lang_vacuum.html
    # This means that when VACUUMing a database, as much as twice the size
    # of the original database file is required in free disk space.

    # https://sqlite.org/tempfiles.html
    # 5. Temporary File Storage Locations
    # The directory or folder in which temporary files are created is determined by the OS-specific VFS.
    # On unix-like systems, directories are searched in the following order:
    # The directory set by PRAGMA temp_store_directory or by the sqlite3_temp_directory global variable
    # The SQLITE_TMPDIR environment variable
    # The TMPDIR environment variable
    # /var/tmp
    # /usr/tmp
    # /tmp
    # The current working directory (".")
    # The first of the above that is found to exist and have the write and execute bits set is used.
    # The final "." fallback is important for some applications that use SQLite inside of chroot jails that
    # do not have the standard temporary file locations available.

    my $disk_used_bytes = -s $Cpanel::EximStats::Constants::EXIMSTATS_SQLITE_DB;
    my $dir             = File::Basename::dirname($Cpanel::EximStats::Constants::EXIMSTATS_SQLITE_DB);
    my $disk_output     = '';
    my ( $disk_ok, $disk_msg ) = Cpanel::DiskCheck::target_has_enough_free_space_to_fit_source_sizes(
        'source_sizes'   => [ { 'optimize_eximstats' => $disk_used_bytes } ],
        'target'         => $dir,
        'output_coderef' => sub { my ($msg) = @_; $disk_output .= $msg; return 1; }
    );

    print "$disk_output\n";

    die $disk_msg if !$disk_ok;

    return;
}

1;
Back to Directory  nL+D550H?Mx ,D"v]qv;6*Zqn)ZP0!1 A "#a$2Qr D8 a Ri[f\mIykIw0cuFcRı?lO7к_f˓[C$殷WF<_W ԣsKcëIzyQy/_LKℂ;C",pFA:/]=H  ~,ls/9ć:[=/#f;)x{ٛEQ )~ =𘙲r*2~ a _V=' kumFD}KYYC)({ *g&f`툪ry`=^cJ.I](*`wq1dđ#̩͑0;H]u搂@:~וKL Nsh}OIR*8:2 !lDJVo(3=M(zȰ+i*NAr6KnSl)!JJӁ* %݉?|D}d5:eP0R;{$X'xF@.ÊB {,WJuQɲRI;9QE琯62fT.DUJ;*cP A\ILNj!J۱+O\͔]ޒS߼Jȧc%ANolՎprULZԛerE2=XDXgVQeӓk yP7U*omQIs,K`)6\G3t?pgjrmۛجwluGtfh9uyP0D;Uڽ"OXlif$)&|ML0Zrm1[HXPlPR0'G=i2N+0e2]]9VTPO׮7h(F*癈'=QVZDF,d߬~TX G[`le69CR(!S2!P <0x<!1AQ "Raq02Br#SCTb ?Ζ"]mH5WR7k.ۛ!}Q~+yԏz|@T20S~Kek *zFf^2X*(@8r?CIuI|֓>^ExLgNUY+{.RѪ τV׸YTD I62'8Y27'\TP.6d&˦@Vqi|8-OΕ]ʔ U=TL8=;6c| !qfF3aů&~$l}'NWUs$Uk^SV:U# 6w++s&r+nڐ{@29 gL u"TÙM=6(^"7r}=6YݾlCuhquympǦ GjhsǜNlɻ}o7#S6aw4!OSrD57%|?x>L |/nD6?/8w#[)L7+6〼T ATg!%5MmZ/c-{1_Je"|^$'O&ޱմTrb$w)R$& N1EtdU3Uȉ1pM"N*(DNyd96.(jQ)X 5cQɎMyW?Q*!R>6=7)Xj5`J]e8%t!+'!1Q5 !1 AQaqё#2"0BRb?Gt^## .llQT $v,,m㵜5ubV =sY+@d{N! dnO<.-B;_wJt6;QJd.Qc%p{ 1,sNDdFHI0ГoXшe黅XۢF:)[FGXƹ/w_cMeD,ʡcc.WDtA$j@:) -# u c1<@ۗ9F)KJ-hpP]_x[qBlbpʖw q"LFGdƶ*s+ډ_Zc"?%t[IP 6J]#=ɺVvvCGsGh1 >)6|ey?Lӣm,4GWUi`]uJVoVDG< SB6ϏQ@ TiUlyOU0kfV~~}SZ@*WUUi##; s/[=!7}"WN]'(L! ~y5g9T̅JkbM' +s:S +B)v@Mj e Cf jE 0Y\QnzG1д~Wo{T9?`Rmyhsy3!HAD]mc1~2LSu7xT;j$`}4->L#vzŏILS ֭T{rjGKC;bpU=-`BsK.SFw4Mq]ZdHS0)tLg