Bug #3287
redmine dreadfully slow
100%
Description
it's consistently taking 10-15 seconds to open an issue, making it difficult to use.
Other views don't seem to be as slow, such as opening up the Backlogs sprint list (https://redmine.dataone.org/rb/master_backlogs/d1#)
do we do any load balancing?
http://posterous.adambard.com/why-is-redmine-so-slow
History
#1 Updated by Rob Nahf over 11 years ago
- Category set to Support Operations
- Assignee set to Dave Vieglais
#2 Updated by Dave Vieglais over 11 years ago
- Status changed from New to In Progress
No load balancing is done, nor should it be necessary.
VM has 4 CPUs and 32GB RAM.
When accessing a ticket on the DataONE project, CPUs get pegged at 100%.
Investigating which component might be causing the problem.
#3 Updated by Dave Vieglais over 11 years ago
- Target version deleted (
Sprint-2012.39-Block.5.4) - Project changed from Infrastructure to Operations
- Category deleted (
Support Operations)
#4 Updated by Dave Vieglais over 11 years ago
Blocked some crawlers for now by setting the following in default-ssl apache config:
<Directory /var/www/redmine> SetEnvIfNoCase User-Agent "^Baiduspider" bad_bots SetEnvIfNoCase User-Agent "^Sogou" bad_bots SetEnvIfNoCase User-Agent "^gsa-crawler" bad_bots SetEnvIf Remote_Addr "212\.100\.254\.105" bad_bot deny from env=bad_bots
#5 Updated by Dave Vieglais over 11 years ago
Mysql queries are completing within a second, so it appears that the slow processing is within the redmine scripts.
Perhaps it's processing access control?
#6 Updated by Dave Vieglais over 11 years ago
- Project changed from Operations to Redmine Test
#7 Updated by Dave Vieglais over 11 years ago
- Status changed from In Progress to Closed
- translation missing: en.field_remaining_hours set to 0.0
Upgraded redmine and associated plugins to redmine version 1.4.2 and backlogs 0.9.26
Seems to have resolved the issue, but some chaff appearing on the backlogs page that will be checked into.
