application:maintenance:database

Perform maintenance on the database.

warden --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, Bayes, Msg, Statistics, Txrep.
--date <string> Delete before the specified date. Date format: 2023-12-17

Examples

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

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

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