New Agent to perform System Cleanup and Optimize Performance
Components
Labels
Description
Context Information
Additional information (do not use)
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
Attachments
Activity

Alex July 25, 2012 at 10:33 AM
Since 5.2.0 version was released.

Alex October 5, 2011 at 3:41 PM
Fix committed to [b]5.2.x branch/b. Commit Message:
Fixes #0000939: New Agent to perform System Cleanup and Optimize Performance
Commit on behalf of Erik

Erik S. October 5, 2011 at 3:06 PM
optimize_performance_939.2.patch attached - needs testing

Alex October 5, 2011 at 2:28 PM
1. please assign sql to a temporary variable (e.g. $sql) and then pass such variable to $this->Conn object method; sql should be properly formatted.
2. Remove "@" symbol before php function calls, since it could hide important error (e.g. that incorrect permissions are set to /system/restricted folder).
3. No empty line needed after opening brace of "foreach" statement, but the one is needed before "foreach" statement.
Interesting idea to check for debugger reports, that were created after agent start.

Erik S. October 5, 2011 at 12:52 PM
patch attached - needs testing
Priority
Assignee

Reporter

Developer

Change Log Message
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).