royallthefourth / psh-innodb-shrink
Provides a cron to shrink InnoDB tables with lots of free space
Installs: 38
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 2
Forks: 0
Open Issues: 0
Type:project
Requires
- php: ^7.2
- platformsh/config-reader: ^2.3
- royallthefourth/smooth-pdo: ^2.0
Requires (Dev)
- phpunit/phpunit: ^9
This package is auto-updated.
Last update: 2025-02-18 05:26:09 UTC
README
This package provides a command-line tool that can be used to shrink InnoDB tables in a PHP application running on Platform.sh.
Installation
composer require royallthefourth/psh-innodb-shrink
Usage
Add a cron to your .platform.app.yaml that invokes the program with a ratio of free space as its argument.
For example, this will only run on tables that are at least 75% empty:
vendor/bin/shrink 0.75
Tests
This package has tests. Use this command to run the them:
vendor/bin/phpunit tests