New Agent to perform System Cleanup and Optimize Performance

Components

Labels

Description

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).

Context Information

None

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

3

Activity

Show:

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

Fixed

Priority

Assignee

Reporter

Developer

Change Log Message

Patch Instructions

Patches must be submitted through Phabricator.

External issue ID

Story Points

Fix versions

Affects versions

Created November 30, 2010 at 6:23 PM
Updated December 29, 2024 at 9:11 PM
Resolved July 25, 2012 at 10:33 AM
Loading...