Issue Details (XML | Word | Printable)

Key: MDL-8092
Type: Bug Bug
Status: Resolved Resolved
Resolution: Incomplete
Priority: Major Major
Assignee: Eloy Lafuente (stronk7)
Reporter: Rich Schumaker
Votes: 1
Watchers: 2
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Backup Failure for Course with Large File Sizes or Large Number of Students

Created: 06/Jan/07 10:45 AM   Updated: 30/May/08 11:50 AM
Return to search
Component/s: Backup
Affects Version/s: 1.7
Fix Version/s: None

Environment:
Operating system Linux
Kernel version 2.6.17.11-grsechg
Machine Type i686
Apache version 1.3.34 (Unix)
PHP version 4.4.4
MySQL version 4.1.21-standard
Issue Links:
Dependency
 

Participants: Dan Marsden, Eloy Lafuente (stronk7), Rich Schumaker and Wen Hao Chuang
Security Level: None
Resolved date: 30/May/08
Affected Branches: MOODLE_17_STABLE


 Description  « Hide
When performing backups on courses with large sized files or a large number of users (700+), backup is timing out and not completing. Php max_execution_time has been adjusted to 150 with no improvement. Shared server host hesitant to go much higher. For access to example course write rich@rlsei.com.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Eloy Lafuente (stronk7) added a comment - 03/Mar/07 06:48 PM
Hi Rich,

did you fixed this with your hosting company? Backup and restore are, by definition, BIG scripts and server needs strong resources while the size of the info to backup grows. Apart from continue minor improvements performed to code, I really think we cannot do too much against hard hosting limits.


Wen Hao Chuang added a comment - 17/Jan/08 03:43 AM
Hi Eloy we all know that backup and restore are BIG scripts but is there any efforts to make it even more efficient? Here at SFSU we also have some courses that have 1000+ students, and currently we could only use mysql dump to backup/restore these courses. It would be great if the course-level backup/restore could work for these large courses as well. Thanks!

Dan Marsden added a comment - 30/May/08 11:50 AM
I'm closing this bug as "incomplete" - there's not really enough information - where is the backup failing? - what error messages are showing? - is debugging turned on?

a range of performance related changes have been implemented in the latest 1.9, and some error checking has improved. so this persons issue may have been fixed.

MDL-14550 makes massive improvements for large sites with large numbers of users. (SFSU - this will probably improve things for you dramatically!)

Backup/restore is heavy, and I don't think it will ever run "smoothly" under a shared host environment, but there has been improvement, and there is still room for improvement - see the other bugs in the tracker for the backup module.

If you have more specific information about an inefficient part of the backup/restore that is not currently logged in the tracker, or an area where backup is failing with no debug output, feel free to create a new report! (but please check that a tracker issues doesn't already exist for your problem.)

thanks,

Dan