Do I need a bigger machine?

8 years 1 month ago #81169 by jrsanche

We have about 1100 surveys of 30 questions each, to asses teachers and subjects at the university.

We are running Limesurvey 1.90+ in a server with a 4-core AMD opteron 2GHz, 3GB RAM.

OS: Windows 2003 Server

Apache Friends XAMPP (Basis Package) version 1.7.3, which includes:

+ Apache 2.2.14 (IPV6 enabled)
+ MySQL 5.1.41 (Community Server) with PBXT engine 1.0.09-rc
+ PHP 5.3.1 (PEAR, Mail_Mime, MDB2, Zend)
+ Perl 5.10.1 (Bundle::Apache2, Apache2::Request, Bundle::Apache::ASP, Bundle::Email, Bundle::DBD::mysql, DBD::SQlite, Randy Kobes PPM)
+ XAMPP Control Version 2.5.8 (ApacheFriends Edition)
+ XAMPP CLI Bundle 1.6
+ XAMPP Port Check 1.5
+ XAMPP Security 1.1
+ SQLite 2.8.17
+ SQLite 3.6.20
+ OpenSSL 0.9.8l
+ phpMyAdmin 3.2.4
+ ADOdb v5.10
+ FPDF v1.6
+ Zend Framework 1.9.6 Minimal Package (via PEAR)
+ Mercury Mail Transport System v4.72
+ msmtp 1.4.19 (a sendmail compatible SMTP client)
+ FileZilla FTP Server 0.9.33
+ Webalizer 2.21-02 (with GeoIP lite)
+ apc 3.1.3p1 for PHP
+ eAccelerator 0.9.6-rc1 for PHP
+ Ming 0.4.3 for PHP
+ PDF with pdflib lite v7.0.4p4 for PHP
+ rar 2.0.0-dev for PHP
+ Xdebug 2.0.6-dev for PHP
+ libapreq2 v2.12 (mod_apreq2) for Apache

We tried to improve MySQL performance setting these param values in c:\xampp\mysql\binmy.ini:

key_buffer = 64M
max_allowed_packet = 16M
table_cache = 256
sort_buffer_size = 4M
read_buffer_size = 1M

Also, we have edited the following params in C:\xampp\php\php.ini:

max_execution_time = 180
max_input_time = 180

But the performance has decreased. We've observed that the CPU use percentage is very high, more than 80%. MySQL process is using about 25% of CPU percentage.

Is it still possible to improve the performance or do I need a bigger machine to increase it?

Thanks in advance for your help,

Juan Ramón
The topic has been locked.
LimeSurvey Partners
8 years 1 month ago #81171 by jrsanche
Sorry, I said "But the performance has decreased." when I wanted to say "But the performance is not much better".

The topic has been locked.
8 years 1 month ago #81175 by DenisChenu
Think it's best to use GNU/Linux server

GNU/Linux is made for web server, performance is greater :)

You can try some query_cache:
query_cache_limit       = 4M
query_cache_size        = 64M
and maybe some

But mySQL optimisation are not comon for all server.


Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development . I don't answer to private message.
The topic has been locked.
8 years 1 month ago #81253 by jrsanche
Thanks for your reply, Denis. We'll try the query_cache and the tmp_table_size params.

Juan Ramón
The topic has been locked.
8 years 1 month ago #81269 by jrsanche
We've changed the query_cache props and response time has been reduced to one third.

We are going to test the Linux option as well.

Thank you!
The topic has been locked.

Start now!

Just create your account and start using Limesurvey today.

Register now