luxutils/laravel-table-optimize

Package for performing OPTIMIZE queries from Laravel app

0.0.1 2020-09-17 05:55 UTC

Requires

• php: >=7.3.0
• doctrine/dbal: ^2.10
• illuminate/database: ^8.0

Requires (Dev)

• orchestra/testbench: ^6.0
• php-coveralls/php-coveralls: ^2.1
• phpunit/phpunit: ^9.3

MIT

• Saulius Kazokas

• laravel
• optimize
• vacuum

README

Use with caution!

Database tables with lots of insert / delete operations sometimes grows in size. For example, Laravel's jobs table could be empty and still take few GB's in size. That's because databases don't actually delete the data, it just marks it for deletion. Running OPTIMIZE or VACUUM commands on databases takes that space back. This package makes optimization easier.

Supported database engines

Currently only MySql and MariaDB are supported.

Installation

composer require luxutils/laravel-table-optimize

License

This package is released under the MIT license (MIT).