README

Magento 2 module for optimization of database fragmentation.

Install

Git

Locate the /app/code directory which should be under the magento root installation.
If the code folder is not there, create it.
Create a folder Monogo inside the code folder.
Change to the Monogo folder and clone the Git repository (https://github.com/MonogoPolska/monogo-m2-optimize-database.git) into Monogo specifying the local repository folder to be OptimizeDatabase e.g.

git clone https://github.com/MonogoPolska/monogo-m2-optimize-database.git OptimizeDatabase

Composer

composer require monogo/optimizedatabase

Magento Setup

Run Magento commands

php bin/magento setup:upgrade

php bin/magento setup:di:compile

php bin/magento setup:static-content:deploy

App Configuration Options

Go to Stores->Configuration->Monogo->Optimize database

Enable module Default value is 1 (Yes)
Minimal fragmentation ratio - Optimize tables for which fragmentation ratio is higher than this value. Default value is 1
Use Magento Cron - You can disable Magento cron and run Optimization from shell Default value is 0 (No)
Cron schedule - Use Crontab Format (Eg. "05 1 * * *" every day at 01:05)

Default values:

Shell

Usage:  php bin/magento monogo:optimize:database [--mode MODE]
   
     print                             Print all tables
     optimize                          Optimize tables       
     help                              This help

for example:

php bin/magento monogo:optimize:database --mode print

Possible output:

Module is disabled in Stores->Configuration->Monogo->Optimize database

monogo / optimizedatabase

Maintainers

Details