MokoConsulting/MokoSuiteClient
0
0
Fork 0
Code Issues 109 Pull Requests Releases 1 Wiki Activity

feat(devtools): database table optimizer and repair tool #252

New Issue
Open
opened 2026-06-23 16:54:12 +00:00 by jmiller · 1 comment
jmiller commented 2026-06-23 16:54:12 +00:00
Owner
Copy Link
Copy Source

Database Table Optimizer and Repair

Overview

One-click database maintenance from DevTools — optimize, repair, and analyze MySQL tables without phpMyAdmin.

Features

  • Table list — show all Joomla tables with size, rows, engine, overhead
  • Optimize — run OPTIMIZE TABLE on selected or all tables
  • Repair — run REPAIR TABLE on corrupted MyISAM/Aria tables
  • Analyze — run ANALYZE TABLE to update index statistics
  • Overhead display — highlight tables with significant overhead
  • Scheduled optimization — optional task plugin for periodic auto-optimize
  • Export table list — CSV export of table sizes for reporting

Architecture

  • View in com_mokosuiteclient component (or DevTools plugin settings page)
  • AJAX endpoints for optimize/repair/analyze operations
  • Uses SHOW TABLE STATUS for metadata
  • Respects MySQL permissions (OPTIMIZE requires ALTER privilege)
## Database Table Optimizer and Repair ### Overview One-click database maintenance from DevTools — optimize, repair, and analyze MySQL tables without phpMyAdmin. ### Features - **Table list** — show all Joomla tables with size, rows, engine, overhead - **Optimize** — run OPTIMIZE TABLE on selected or all tables - **Repair** — run REPAIR TABLE on corrupted MyISAM/Aria tables - **Analyze** — run ANALYZE TABLE to update index statistics - **Overhead display** — highlight tables with significant overhead - **Scheduled optimization** — optional task plugin for periodic auto-optimize - **Export table list** — CSV export of table sizes for reporting ### Architecture - View in com_mokosuiteclient component (or DevTools plugin settings page) - AJAX endpoints for optimize/repair/analyze operations - Uses `SHOW TABLE STATUS` for metadata - Respects MySQL permissions (OPTIMIZE requires ALTER privilege)
jmiller added this to the v03.00.00 milestone 2026-06-23 16:54:12 +00:00
jmiller commented 2026-06-23 16:54:21 +00:00
Author
Owner
Copy Link
Copy Source

Branch created: feature/252-feat-devtools-database-table-optimizer-a

git fetch origin
git checkout feature/252-feat-devtools-database-table-optimizer-a
Branch created: [`feature/252-feat-devtools-database-table-optimizer-a`](https://git.mokoconsulting.tech/MokoConsulting/MokoSuiteClient/src/branch/feature/252-feat-devtools-database-table-optimizer-a) ```bash git fetch origin git checkout feature/252-feat-devtools-database-table-optimizer-a ```
Sign in to join this conversation.
Labels
Clear labels
architecture
automation
Automated processes or scripts
 breaking-change
Breaking API or functionality change
 bug
build
Build system changes
 ci-cd
CI/CD pipeline changes
 config
Configuration file changes
 css
CSS/styling changes
 dependencies
Dependency updates
 deploy-failure
Automated deploy failure tracking
 docker
Docker configuration changes
 documentation
Documentation changes
 dolibarr
Dolibarr module or extension
 duplicate
enhancement
generic
Generic project or library
 good first issue
Good for newcomers
 health-check
Repository health check results
 health: excellent
Health score 90-100
 health: fair
Health score 50-69
 health: good
Health score 70-89
 health: poor
Health score below 50
 help wanted
Extra attention needed
 html
HTML template changes
 invalid
javascript
JavaScript code changes
 joomla
Joomla extension or component
 major-release
Major version release (breaking changes)
 minor-release
Minor version release (XX.YY.00)
 mokostandards
MokoStandards compliance
 needs-review
Awaiting code review
 needs-testing
Requires manual or automated testing
 patch-release
Patch version release (XX.YY.ZZ)
 php
PHP code changes
 priority: critical
priority: high
priority: low
priority: medium
push-failure
File push failure requiring attention
 python
Python code changes
 question
regression
Regression from a previous working state
 release-candidate
Release candidate build
 security
Security-related changes
 size/l
Large change (101-300 lines)
 size/m
Medium change (31-100 lines)
 size/s
Small change (11-30 lines)
 size/xl
Extra large change (301-1000 lines)
 size/xs
Extra small change (1-10 lines)
 size/xxl
Extremely large change (1000+ lines)
 standards-drift
Repository drifted from MokoStandards
 standards-update
MokoStandards sync update
 standards-violation
Standards compliance failure
 status: blocked
status: in-progress
status: needs-review
status: on-hold
Temporarily on hold
 status: pending
Pending action or decision
 status: wontfix
This will not be worked on
 sync-failure
Bulk sync failure requiring attention
 sync-report
Bulk sync run report
 template-validation-failure
Template workflow validation failure
 test-failure
Automated test failure
 tests
Test suite changes
 type: bug
Something isn't working
 type: chore
Maintenance tasks
 type: enhancement
Enhancement to existing feature
 type: feature
New feature or request
 type: refactor
Code refactoring
 type: release
Release preparation or tracking
 type: test
Test suite additions or changes
 type: version
Version-related change
 typescript
TypeScript code changes
 version
Version bump or release
 version-branch
Version branch related
 version-drift
Version mismatch detected
 work-in-progress
Work in progress, not ready for merge
No labels
Priority Medium
Type Feature
Milestone
No items
No Milestone v03.00.00
Assignees
Clear assignees
jmiller (Jonathan Miller)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: MokoConsulting/MokoSuiteClient#252
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?