Project

General

Profile

Forums » Help »

Application is very slow

Added by Bryan Serad over 11 years ago

Hello,

I've been trying to fix this problem which I inherited from the previous guys who set this up.
After a couple of months our redmine application becomes very slow.
To give you the details, here's what we have from production.log

Processing IssuesController#show (for 122.52.117.41 at 2013-08-15 19:39:31) [GET]
  Parameters: {"id"=>"3697", "controller"=>"issues", "action"=>"show"}
Rendering template within layouts/base
Rendering issues/show
Completed in 13222ms (View: 8537, DB: 305) | 200 OK [http://www.abc.com/issues/3697]

Processing AttachmentsController#download (for 122.52.117.41 at 2013-08-15 19:40:01) [GET]
  Parameters: {"id"=>"2839", "controller"=>"attachments", "action"=>"download"}
Completed in 152ms (View: 13, DB: 9) | 200 OK [http://www.abc.com/attachments/download/2839]

Our environment:
CentOS release 5.8 (Final)
Redmine 1.4.1
Ruby 1.8.7 (2011-02-18 patchlevel 334) [x86_64-linux]
WEBrick/1.3.1
Rails 2.3.14
Gem 1.8.11

Hardware:
CPU: Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
Memory: 12298564k/13238272k available

Anyone can share some advice? Thanks!


Replies (2)

RE: Application is very slow - Added by Kuniharu AKAHANE over 11 years ago

Hi, Bryan

Completed in 13222ms (View: 8537, DB: 305) | 200 OK [http://www.abc.com/issues/3697]
Log says:
  • It takes very long time (8.5sec) to making/rendering the response HTML page.
  • It takes long time (0.3sec) to fetch data from the database.
  • It takes very long time (4.3sec) to doing some other process.

In my opinion, there are 3 points to make your redmine server faster.

  1. Change Application-server from Webrick to Passenger.
  2. Use newer version of Ruby. ( Redmine 1.4 can use with Ruby 1.9.3 )
  3. If you are using Sqlite3, then change database system from Sqlite3 to Postgresql or Mysql. And in some case, It needs some Memory-Tuning.

Just for your information, Our Redmine server's log as follows:

Started GET "/its/issues/88593" for 172.xx.xx.xx at 2013-08-21 17:40:13 +0900
Processing by IssuesController#show as HTML
Completed 200 OK in 173ms (Views: 104.7ms | ActiveRecord: 14.9ms)

Hope this help.

RE: Application is very slow - Added by Etienne Massip over 11 years ago

Kuniharu AKAHANE wrote:

Hi, Bryan

[...]
In my opinion, there are 3 points to make your redmine server faster.

  1. Change Application-server from Webrick to Passenger.

Indeed, WebRick is a development server and absolutely not designed to run on production sites.

  1. If you are using Sqlite3, then change database system from Sqlite3 to Postgresql or Mysql. And in some case, It needs some Memory-Tuning.

Just the same, sqlite is ok for small personal DB but not designed for greater workload.

The last point is that you should opt for asynchronous mail notifications; else it's not rare that the process blocks a long time before rendering the issue page, waiting for the mail server call to return.

    (1-2/2)