In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
939 [In-Portal CMS] Optimization feature request always 2010-11-30 12:23 2012-07-25 05:33
Reporter: Dmitry Platform:  
Assigned To: alex OS:  
Priority: normal OS Version:  
Status: closed Product Version: 5.1.1  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.2.0-B1  
Reference: http://groups.google.com/group/in-portal-dev/browse_thread/thread/2b9d1ec963542bf8
Change Log Message: Added System cleanup and DB optimizzation
Estimate Points: 1
Summary: 0000939: New Agent to perform System Cleanup and Optimize Performance
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).
Steps To Reproduce:
Additional Information: 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
Relationships
Attached Files: patch optimize_performance_939.patch (1,962) 2011-10-05 07:51
http://tracker.in-portal.org/file_download.php?file_id=1211&type=bug
patch optimize_performance_939.2.patch (1,953) 2011-10-05 10:06
http://tracker.in-portal.org/file_download.php?file_id=1217&type=bug
patch optimize_performance_agent_v3.patch (2,103) 2011-10-05 10:41
http://tracker.in-portal.org/file_download.php?file_id=1219&type=bug
Issue History
Date Modified Username Field Change
2012-07-25 05:33 alex Note Added: 0005109
2012-07-25 05:33 alex Status resolved => closed
2011-10-22 05:30 alex Estimate Points => 1
2011-10-05 10:41 alex Changeset attached 5.2.x r14642
2011-10-05 10:41 alex Note Added: 0004029
2011-10-05 10:41 alex Status reviewed and tested => resolved
2011-10-05 10:41 alex Fixed in Version => 5.2.0-B1
2011-10-05 10:41 alex Resolution open => fixed
2011-10-05 10:41 alex Assigned To !COMMUNITY => alex
2011-10-05 10:41 alex Assigned To alex => !COMMUNITY
2011-10-05 10:41 alex Status needs testing => reviewed and tested
2011-10-05 10:41 alex File Added: optimize_performance_agent_v3.patch
2011-10-05 10:06 erik Note Added: 0004026
2011-10-05 10:06 erik Assigned To erik => alex
2011-10-05 10:06 erik Status needs work => needs testing
2011-10-05 10:06 erik File Added: optimize_performance_939.2.patch
2011-10-05 09:28 alex Note Added: 0004025
2011-10-05 09:28 alex Assigned To alex => erik
2011-10-05 09:28 alex Status needs testing => needs work
2011-10-05 07:52 erik Time Estimate Removed 1 =>
2011-10-05 07:52 erik Note Added: 0004018
2011-10-05 07:52 erik Assigned To erik => alex
2011-10-05 07:52 erik Developer => erik
2011-10-05 07:52 erik Status needs work => needs testing
2011-10-05 07:51 erik File Added: optimize_performance_939.patch
2011-10-05 02:14 alex Description Updated bug_revision_view_page.php?rev_id=860#r860
2011-10-05 02:14 alex Additional Information Updated bug_revision_view_page.php?rev_id=862#r862
2011-10-04 21:03 Dmitry Assigned To => erik
2011-10-04 21:03 Dmitry Status active => needs work
2011-09-26 04:47 alex Time Estimate Added 1
2011-09-26 04:47 alex Note Added: 0003910
2011-09-23 21:27 Dmitry Target Version Icebox => 5.2.0
2010-11-30 12:34 Dmitry Change Log Message => Added System cleanup and DB optimizzation
2010-11-30 12:23 Dmitry Type task => feature request
2010-11-30 12:23 Dmitry New Issue
2010-11-30 12:23 Dmitry Reference => http://groups.google.com/group/in-portal-dev/browse_thread/thread/2b9d1ec963542bf8

Notes
(0003910)
alex   
2011-09-26 04:47   
Really needed stuff. I have a lot of debugger reports.
(0004018)
erik   
2011-10-05 07:52   
patch attached - needs testing
(0004025)
alex   
2011-10-05 09:28   
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.
(0004026)
erik   
2011-10-05 10:06   
optimize_performance_939.2.patch attached - needs testing
(0004029)
alex   
2011-10-05 10:41   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0000939: New Agent to perform System Cleanup and Optimize Performance
Commit on behalf of Erik
(0005109)
alex   
2012-07-25 05:33   
Since 5.2.0 version was released.