application:maintenance:database

Perform maintenance on the database.

juggernaut --task=application:maintenance:database --oper=<delete|delete_all|optimize|optimize_all>
Option Value Description
--oper <string> The operation you want to perform. Operations: delete, delete_all, optimize, optimize_all
--type <string> The database table type to perform the operation on. Types: Log_Action, Log_Application.
--date <string> Delete before the specified date. Date format: 2023-12-17

Examples

// delete data from the action log before 2023-12-17
juggernaut --task=application:geolocation --oper=delete --type=Log_Action --date=2023-12-17

// optimize the action log table
juggernaut --task=application:geolocation --oper=optimize --type=Log_Action

// optimize all tables
juggernaut --task=application:geolocation --oper=optimize_all