Do I need a bigger machine?

Mehr
7 Jahre 3 Monate her #81169 von 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

LimeSurvey Partners
Mehr
7 Jahre 3 Monate her #81171 von jrsanche
Sorry, I said "But the performance has decreased." when I wanted to say "But the performance is not much better".

Thanks,

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
7 Jahre 3 Monate her #81175 von 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 , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
7 Jahre 3 Monate her #81253 von jrsanche
Thanks for your reply, Denis. We'll try the query_cache and the tmp_table_size params.

Juan Ramón

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
7 Jahre 3 Monate her #81269 von 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!

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha