[INP-754] New Agent to perform System Cleanup and Optimize Performance - In-Portal Issue Tracker

XML

Word

Printable

External issue URL:
http://tracker.in-portal.org/view.php?id=939
Additional information:

Hide

Plan:

1. this will be a new event "adm:OnSystemCleanup"
2. event should be registered as a "regular event" in "admin_config.php" (see how it's done in "users_config.php" (unit config cache must be reset for this new regular event to be shown in "Agents" grid)
3. this event regular event should invoked once a day and have reAFTER type (to be executed after page is displayed to user, when CRON isn't use)
4. debug files from active sessions shouldn't be deleted

Show
Plan: 1. this will be a new event "adm:OnSystemCleanup" 2. event should be registered as a "regular event" in "admin_config.php" (see how it's done in "users_config.php" (unit config cache must be reset for this new regular event to be shown in "Agents" grid) 3. this event regular event should invoked once a day and have reAFTER type (to be executed after page is displayed to user, when CRON isn't use) 4. debug files from active sessions shouldn't be deleted
Change Log Message:
Added System cleanup and DB optimizzation
Story Points:
1
External issue ID:
939
Copy Issue Key:
Patch Instructions:
Patches must be submitted through Phabricator.
- To submit patch via Command Line use Patches Workflow (via Arcanist) tutorial
- To submit patch via Web Interface use Patches Workflow (via Web Interface) tutorial

Create a new Agent (regular event) to perform System Cleanup and Optimize Performance.

1. System Cleanup - once a day delete all Debug files from system/.restricted folder(format debug_@977827436@.txt)

2. Performance Optimization - once a day run MySQL OPTIMIZE SQL one by one on all In-Portal tables (found by prefix).