Do I need a bigger machine?

More
4 years 9 months ago #81169 by jrsanche
Hi,

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

Please Log in to join the conversation.

More
4 years 9 months ago #81171 by jrsanche
Sorry, I said "But the performance has decreased." when I wanted to say "But the performance is not much better".

Thanks,

Please Log in to join the conversation.

More
4 years 9 months 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
tmp_table_size

But mySQL optimisation are not comon for all server.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 9 months ago #81253 by jrsanche
Thanks for your reply, Denis. We'll try the query_cache and the tmp_table_size params.

Juan Ramón

Please Log in to join the conversation.

More
4 years 9 months 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!

Please Log in to join the conversation.