1Click upgrade server performance

[Gipielle]

• Server performance. Some shared hosted offer poor performance, which might hinder the performance of the upgrade process, or even make it fail. "Low" is thus selected by default, but if you know you have a powerful server, you can choose "Medium" or even "High".

 

 

Powerful server .... this below is powerful ?

 

CPU Intel® Xeon® CPU E3-1245 V2 @ 3.40GHz

Core : 8

Cache : 8192KB RAM 4x 8192MB (32GB)

Disk 2 x 120 GB SSD

Edited July 7, 2017 by Gipielle (see edit history)

[Scully]

I'd say yes.

However, we did test upgrades and don't know where the performance parameter takes effect.

[bellini13]

The performance settings in the upgrade module control the following...

 

        $perf_array = array(
            'loopBackupFiles' => array(400, 800, 1600),
            'maxBackupFileSize' => array(15728640, 31457280, 62914560),
            'loopBackupDbTime' => array(6, 12, 25),
            'max_written_allowed' => array(4194304, 8388608, 16777216),
            'loopUpgradeFiles' => array(600, 1200, 2400),
            'loopRestoreFiles' => array(400, 800, 1600),
            'loopRestoreQueryTime' => array(6, 12, 25),
            'loopUpgradeModulesTime' => array(6, 12, 25),
            'loopRemoveSamples' => array(400, 800, 1600)
        );
 

the value for each array key is in the order of low to high

 

For example, this controls how many files are backed up at a time.  Choosing low would do 400 files at a time, choosing high would do 1600 files at a time.

            'loopBackupFiles' => array(400, 800, 1600),

[Scully]

@bellini13: Thanks for this explanation. I've learned something new.

[Gipielle]

Can I safely set to high ?

[Scully]

If you're unsure, let it on default value. It only affects to upgrade procedure which anyway doesn't take much time.

[pogio]

I've used medium on dedicated server and backing up the DB with 1-click upgrade is very very slow, seems it takes records by 200.... so hitting my connections, connection_pages and guest tables takes hours... Where could y change that parameter?

Edited July 18, 2017 by pogio (see edit history)

[bellini13]

Don't use the backup feature of the module.  There is no reason to use it.  Do your own backups using your hosting control panel. 

[El Patron]

I've used medium on dedicated server and backing up the DB with 1-click upgrade is very very slow, seems it takes records by 200.... so hitting my connections, connection_pages and guest tables takes hours... Where could y change that parameter?

 

you can drop or export(re-import) then drop connections tables.  The size of tables probably causes more upgrades to fail than anything.  I agree with bellini13, don't use upgrade back up's, you should have done a full manual backup from hosting and more importantly know how to restore in-case of failure.  That being said 'all' upgrades should be done on a copy of your existing shop, most often we would then use that copy to replace production.

 

I personally have big horking dedicated server so I run 'high performance option' and it goes zoom zoom...lol