Redmine running extremely slow.

Added by Brian Hollenbeck almost 11 years ago

I'm running Redmine on Dreamhost shared hosting @ http://redmine.elsewares.org to manage my clients, who are all over the US. When I first installed it, I was able to set up fine. Since then, however, the wait times have gotten longer until now the site times out almost every time it's accessed. I checked the production log, and saw:

Processing AccountController#login (for 24.30.142.69 at 2010-01-17 18:01:57) [GET]
Session ID: 73f6e926800f2589314c13e8bb3968bf
Parameters: {"back_url"=>"http://redmine.elsewares.org/", "action"=>"login", "controller"=>"account"}
Rendering template within layouts/base
Rendering account/login
Completed in 24.48616 (0 reqs/sec) | Rendering: 2.75116 (11%) | DB: 2.09961 (8%) | 200 OK [http://redmine.elsewares.org/login?back_url=http%3A%2F%2Fredmine.elsewares.org%2F]

Processing AccountController#login (for 24.30.142.69 at 2010-01-17 18:02:26) [GET]
Session ID: af0aaaa6a9cfff7266757899eba53575
Parameters: {"back_url"=>"http://redmine.elsewares.org/", "action"=>"login", "controller"=>"account"}
Rendering template within layouts/base
Rendering account/login
Completed in 3.92834 (0 reqs/sec) | Rendering: 2.76957 (70%) | DB: 0.96632 (24%) | 200 OK [http://redmine.elsewares.org/login?back_url=http%3A%2F%2Fredmine.elsewares.org%2F]

Processing AccountController#login (for 24.30.142.69 at 2010-01-17 18:01:56) [GET]
Session ID: cb217fe33c9073c05ec7e45e4901fb14
Parameters: {"back_url"=>"http://redmine.elsewares.org/", "action"=>"login", "controller"=>"account"}
Rendering template within layouts/base
Rendering account/login
Completed in 37.34738 (0 reqs/sec) | Rendering: 3.07820 (8%) | DB: 2.50551 (6%) | 200 OK [http://redmine.elsewares.org/login?back_url=http%3A%2F%2Fredmine.elsewares.org%2F]

Processing AccountController#login (for 24.30.142.69 at 2010-01-17 18:02:37) [GET]
Session ID: 9d34ae415238f82022231d9fdf06a7bd
Parameters: {"back_url"=>"http://redmine.elsewares.org/", "action"=>"login", "controller"=>"account"}
Rendering template within layouts/base
Rendering account/login
Completed in 0.88289 (1 reqs/sec) | Rendering: 0.21849 (24%) | DB: 0.49926 (56%) | 200 OK [http://redmine.elsewares.org/login?back_url=http%3A%2F%2Fredmine.elsewares.org%2F]

Processing AccountController#login (for 24.30.142.69 at 2010-01-17 18:02:38) [GET]
Session ID: 8e26fa3c91c51a338cdcda64051c15a1
Parameters: {"back_url"=>"http://redmine.elsewares.org/", "action"=>"login", "controller"=>"account"}
Rendering template within layouts/base
Rendering account/login
Completed in 10.17468 (0 reqs/sec) | Rendering: 0.00704 (0%) | DB: 0.13642 (1%) | 200 OK [http://redmine.elsewares.org/login?back_url=http%3A%2F%2Fredmine.elsewares.org%2F]

The site is running on a Dreamhost shared hosting server with Phusion Passenger. I have no idea why this is happening, and restarting the application doesn't seem to help. I've also deleted the production log, since that was getting large-ish (236k) and I thought that was the issue. Two tickets to support later, they can't seem to reproduce the problem, but all of my clients (from California to Atlanta, literally) can't use the site, so it must not be a network issue.

Any suggestions?