Issue Details (XML | Word | Printable)

Key: MDL-16955
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: moodle.com
Reporter: D P
Votes: 0
Watchers: 1
Operations

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

performance issue on oracle system

Created: 21/Oct/08 10:08 PM   Updated: 02/Jun/09 01:09 AM
Return to search
Component/s: Administration, Database activity module, Database SQL/XMLDB, General, Installation, Performance, Unknown
Affects Version/s: 1.9.2
Fix Version/s: None

Environment:
oracle 10.2.0.1.0
Solaris Coolstack

Database: Oracle
Participants: Angelo Rigo, D P and moodle.com
Security Level: None
Affected Branches: MOODLE_19_STABLE


 Description  « Hide
we use OCI8 1.2.5 (pecl), because of the curso leak problems in 1.2.4

BUT we have performance problems, maybe the problem with the cursor leaks again in version 1.2.5.....?!
suddenly the 4/5 normal sessions (60 users in one minute in moodle) on the database server expand to 700...and we have to start it up again...after half an hour...the webserver processes also rise to this levels...
when we restart the database, everything wents back to normal...

is there anything we can do?
maybe set a timetolive somewhere?
downgrade to oci8 1.2.3?

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
No commits have yet been performed on this issue.