PHPackages                             loadsys/cakephp-tablemaintenanceshell - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. loadsys/cakephp-tablemaintenanceshell

ActiveCakephp-plugin[Database & ORM](/categories/database)

loadsys/cakephp-tablemaintenanceshell
=====================================

A CakePHP console tool to run common MySQL database maintenance queries

1.0.0(8y ago)06.0k↓26.2%MITPHPPHP >=5.3.0

Since Feb 16Pushed 8y ago6 watchersCompare

[ Source](https://github.com/loadsys/CakePHP-TableMaintenanceShell)[ Packagist](https://packagist.org/packages/loadsys/cakephp-tablemaintenanceshell)[ Docs](https://github.com/loadsys/CakePHP-TableMaintenanceShell)[ RSS](/packages/loadsys-cakephp-tablemaintenanceshell/feed)WikiDiscussions master Synced yesterday

READMEChangelog (1)Dependencies (1)Versions (3)Used By (0)

CakePHP-TableMaintenanceShell
=============================

[](#cakephp-tablemaintenanceshell)

A CakePHP v2.x console tool to run common MySQL database maintenance queries, including:

- CHECK
- ANALYZE
- OPTIMIZE
- REPAIR

Tables are locked with a `READ` lock for the `check` action, or `WRITE` locks for all other actions. This is to mimic the behavior of `mysqlcheck` as described [here](https://dev.mysql.com/doc/refman/5.6/en/mysqlcheck.html).

Requirements
------------

[](#requirements)

- CakePHP 2.x
- PHP 5.3+

Installation
------------

[](#installation)

```
$ composer require loadsys/cakephp-tablemaintenanceshell
```

Usage
-----

[](#usage)

```
Console/cake TableMaintenance.table_maintenance run {action} {table|ALL}
```

The `{action}` param can be any one of:

- `check`
- `analyze`
- `optimize`
- `repair`

The `{table}` param can be any valid table name, or the special word `ALL` meaning all tables.

Adding the `--quiet` or `-q` flag will suppress output unless an error exists.

Contributing
------------

[](#contributing)

### Reporting Issues

[](#reporting-issues)

Please use [GitHub Isuses](https://github.com/loadsys/CakePHP-TableMaintenanceShell/issues) for listing any known defects or issues.

### Development

[](#development)

When developing this plugin, please fork and issue a PR for any new development.

License
-------

[](#license)

[MIT](https://github.com/loadsys/CakePHP-TableMaintenanceShell/blob/master/LICENSE.md)

Copyright
---------

[](#copyright)

[Loadsys Solutions](http://www.loadsys.com) 2018

###  Health Score

31

—

LowBetter than 66% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity22

Limited adoption so far

Community12

Small or concentrated contributor base

Maturity59

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 66.7% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

3059d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/2380c6ad9546e6c8ce5c5b641f5a4bce0c4d3e7f3a377dc287936dff50cc3064?d=identicon)[ricog](/maintainers/ricog)

![](https://avatars.githubusercontent.com/u/57735?v=4)[Gregory Gaskill](/maintainers/chronon)[@chronon](https://github.com/chronon)

---

Top Contributors

[![chronon](https://avatars.githubusercontent.com/u/57735?v=4)](https://github.com/chronon "chronon (2 commits)")[![leeforkenbrock](https://avatars.githubusercontent.com/u/16821?v=4)](https://github.com/leeforkenbrock "leeforkenbrock (1 commits)")

---

Tags

databasemysqlcakephp

### Embed Badge

![Health badge](/badges/loadsys-cakephp-tablemaintenanceshell/health.svg)

```
[![Health](https://phpackages.com/badges/loadsys-cakephp-tablemaintenanceshell/health.svg)](https://phpackages.com/packages/loadsys-cakephp-tablemaintenanceshell)
```

###  Alternatives

[helsingborg-stad/municipio

A bootstrap theme for creating municipality sites.

4028.5k10](/packages/helsingborg-stad-municipio)[olliejones/index-wp-mysql-for-speed

Speed up your WordPress site by adding high-performance keys (database indexes) to your MySQL database tables.

1491.9k](/packages/olliejones-index-wp-mysql-for-speed)[rah/danpu

Zero-dependency MySQL dump library for easily exporting and importing databases

62414.3k11](/packages/rah-danpu)[imsamurai/cakephp-serializable-behaviour

Behavior for saving and reading serialized data from/into database

147.7k3](/packages/imsamurai-cakephp-serializable-behaviour)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)