Redmine

Thanks Winston for your thoughts. I've also just upgraded to 2.0.2 and spent a few hours trying to find a replacement for mongrel which doesn't seem to work with 2.x.

I've started using Puma but it seems that either the web server or Redmine 2.x is slower than the previous 1.3.x version I had installed.

Can you please explain in more detail what you mean by "tunning MySQL" and what sample configuration file you were referring to?

I have a similar problem. Using puma web server doesn't solve the problem. Db=postegreDB

FYI, this has been pointed out by JPL when he started to implement the RoR upgrade.

• Installing Ruby 1.9.3-p125 instead of 1.9.3-p194 is the key, about 70% performance gained by this one.
• Under MySQL folder, there are more configuration files like "my-huge.ini". Merge it into your my.ini, and uncomment the InnoDB parts. This can hugely improve ActiveRecord fetching performance, about 20% of total page loading time.
• Puma won't improve much performance for Redmine. It's just a web server choice for Redmine 2.x + Windows. Another substitute is thin, which can only work under Ruby 1.9.3-p125.

Thanks, Installing Ruby 1.9.3-p125 increased speed a lot.

Thanks for your article.
Then I have a question. what's your Ruby Environments or gems.
RubyGem version. Gem list, and so on...

To Ki Won Kim:
My ruby environment is for Redmine only, nothing fancy. After install Ruby 1.9.3p125 and DevKit(under ruby193\DevKit), I use the following script to install everything:

::Find Ruby dir
@for /f "tokens=* delims=." %%p in ('where ruby') do set ruby=%%p
@set rubyDir=%ruby:\bin\ruby.exe=%

::Use Ruby DevKit
@set rubyDevKitVarsBat=%rubyDir%\DevKit\devkitvars.bat
@if exist %rubyDevKitVarsBat% call "%rubyDevKitVarsBat%" 

::Copy libmysql.dll to ruby\bin
@copy /y "%~dp0CopyToRubyBinIfMysqlError\libmySQL.dll" "%rubyDir%\bin" 

call gem install bundler --no-ri --no-rdoc
call bundle install --without development test rmagick postgresql sqlite

call gem install eventmachine --no-ri --no-rdoc --pre
call gem install thin -v 1.3.1 --no-ri --no-rdoc

libmySQL.dll is downloaded from http://www.mysql.com/downloads/connector/c/

I updated thin install command to stick to v1.3.1, since the latest v1.4.1 reports error.

Thank you Winston Feng.
My successful environment were

Redmine 1.4.4
Ruby 1.9.3p125 (2012-02-16) [i386-mingw32]
Rails 2.3.14
RubyGems 1.8.24

By the way, about how to increase the speed of svn? :)

Nice!
Thanks.
I used ruby 1.8.7.

any solution for thin server performance tuning?

Ki Won Kim wrote:

By the way, about how to increase the speed of svn? :)

Svn is really slow. I use Git now. Git is good for programmer, but not friendly enough for other people. Need some script work.