|
|
|
We had some reports of slowness on one of our moodle sites. It turned out the school had my moodle redirect switched on.
Upon investigating the performance log I discovered for a single user /my/ page was causing 12401 database queries.
Here is a perf log line from my dev machine (artificially fast due to front/backend being the same).
[Tue Feb 10 19:38:55 2009] [error] [client 10.0.0.5] PERF: /my/ time: 5.407977s memory_total: 21916276B (20.9MB) memory_growth: 21626784B (20.6MB) memory_peak: 22259484B (21.2MB) includecount: 80 dbqueries: 12401 ticks: 541 user: 211 sys: 144 cuser: 0 csys: 0 serverload: 0.11 rcache: 0/0
I want to investigate this and search and destroy whatever is causing it. This obviously cripples a moodle site with my moodle redirection.
|
|
Description
|
We had some reports of slowness on one of our moodle sites. It turned out the school had my moodle redirect switched on.
Upon investigating the performance log I discovered for a single user /my/ page was causing 12401 database queries.
Here is a perf log line from my dev machine (artificially fast due to front/backend being the same).
[Tue Feb 10 19:38:55 2009] [error] [client 10.0.0.5] PERF: /my/ time: 5.407977s memory_total: 21916276B (20.9MB) memory_growth: 21626784B (20.6MB) memory_peak: 22259484B (21.2MB) includecount: 80 dbqueries: 12401 ticks: 541 user: 211 sys: 144 cuser: 0 csys: 0 serverload: 0.11 rcache: 0/0
I want to investigate this and search and destroy whatever is causing it. This obviously cripples a moodle site with my moodle redirection. |
Show » |
made changes - 14/Feb/09 07:35 AM
| Field |
Original Value |
New Value |
|
Assignee
|
Martín Langhoff
[ martinlanghoff
]
|
Dan Poltawski
[ poltawski
]
|
made changes - 14/Feb/09 07:43 AM
|
Attachment
|
|
queries-mymoodle.log
[ 16275
]
|
made changes - 14/Feb/09 08:34 AM
made changes - 14/Feb/09 10:31 AM
|
Comment
|
[ Attaching querylog (4MB!)
]
|
|
made changes - 14/Feb/09 10:31 AM
|
Attachment
|
queries-mymoodle.log
[ 16275
]
|
|
made changes - 16/Feb/09 03:09 AM
|
Attachment
|
|
0001-performance-mymoodle-MDL-18241-Assigments-were-ver.patch
[ 16284
]
|
made changes - 16/Feb/09 03:27 AM
|
Attachment
|
0001-performance-mymoodle-MDL-18241-Assigments-were-ver.patch
[ 16284
]
|
|
made changes - 16/Feb/09 03:28 AM
made changes - 16/Feb/09 10:19 PM
|
Resolution
|
|
Fixed
[ 1
]
|
|
Status
|
Open
[ 1
]
|
Resolved
[ 5
]
|
made changes - 17/Feb/09 12:04 PM
made changes - 17/Feb/09 12:19 PM
|
Status
|
Resolved
[ 5
]
|
Closed
[ 6
]
|
|
Bug
Closed
Blocker
My Moodle generating 12,000 database queries per pageload
