PHP download

Download the PHP package gigerit/laravel-mysql-optimizer without Composer

On this page you can find all versions of the php package gigerit/laravel-mysql-optimizer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download gigerit/laravel-mysql-optimizer
More information about gigerit/laravel-mysql-optimizer
Files in gigerit/laravel-mysql-optimizer

Vendor gigerit
Package laravel-mysql-optimizer
Short Description A laravel package that optimizes mysql database tables.
License MIT

Keywords database mysql laravel optimize table

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of gigerit/laravel-mysql-optimizer

Informations about the package laravel-mysql-optimizer

MySQL Optimizer

A Laravel package for optimizing MySQL/MariaDB database tables with support for both synchronous and queued execution.

Why use this package?

MySQL's OPTIMIZE TABLE statement reorganizes tables and compacts wasted space, resulting in:

Faster queries through improved data packing and reduced fragmentation
Less disk I/O for full table scans
Reduced storage footprint via better space utilization

Ideal for tables with frequent INSERT, UPDATE, and DELETE operations.

Requirements

Laravel 8.x – 12.x (auto-discovered service provider)
MySQL 5.7+/8.0+ or MariaDB (uses INFORMATION_SCHEMA and OPTIMIZE TABLE)

Installation

Publish the configuration (optional):

Configuration

The package reads the default database to optimize from config/mysql-optimizer.php:

Set DB_DATABASE in your .env, or override mysql-optimizer.database at runtime.
When the --database=default option is used, the action resolves to config('mysql-optimizer.database').

CLI usage

Options:

--database=default: Database name to optimize. Use default to use config('mysql-optimizer.database').
--table=*: Repeatable. If omitted, all tables in the target database are optimized.
--queued: Queue the optimization as a job instead of running synchronously.
--no-log: Disable job logging; only applies when --queued is used.

Examples

Optimize all tables in the default database:

Optimize specific tables:

Optimize a specific database:

Queue optimization for all tables:

Queue optimization for selected tables with logging disabled:

Using the Job directly

When using queued execution, ensure a worker is running:

Scheduling

Optimize all tables weekly on Sunday at 02:00 as a queued job:

Optimize selected high-traffic tables daily at 03:00 as a queued job:

Or schedule the console command to run synchronously:

Behavior and logging

Synchronous runs show a progress bar and success counts in the console.
Queued runs log start/completion, and per-table results (unless --no-log is used).

Exceptions

MySQLOptimizer\Exceptions\DatabaseNotFoundException
MySQLOptimizer\Exceptions\TableNotFoundException

Operational notes

OPTIMIZE TABLE may lock tables. Prefer running during low-traffic windows.
Ensure the DB user has sufficient privileges to run OPTIMIZE TABLE and access INFORMATION_SCHEMA.

Testing

Compatibility

Laravel 8.x – 12.x

Contributing

We welcome contributions! Please see:

Contributing Guidelines
Code of Conduct

Standards

This package follows:

License

This package is open-sourced software licensed under the MIT license.

Credits

Updated, Extended & Maintained by gigerIT

Original idea for Laravel 8 by Zak Rahman

💡 Pro tip: schedule regular optimizations using Laravel's task scheduler for automated maintenance.

All versions of laravel-mysql-optimizer with dependencies

PHP Build Version

Package Version

Version v1.2.0 Release 23. Jun 2025
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of laravel-mysql-optimizer from vendor gigerit

Requires illuminate/console Version ^8.0|^9.0|^10.0|^11.0|^12.0
illuminate/database Version ^8.0|^9.0|^10.0|^11.0|^12.0
illuminate/bus Version ^8.0|^9.0|^10.0|^11.0|^12.0
illuminate/queue Version ^8.0|^9.0|^10.0|^11.0|^12.0
illuminate/support Version ^8.0|^9.0|^10.0|^11.0|^12.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package gigerit/laravel-mysql-optimizer contains the following files

Loading the files please wait ....