Welcome, Guest
Username: Password: Remember me

TOPIC: Do I need a bigger machine?

Do I need a bigger machine? 2 years 9 months ago #81169

  • jrsanche
  • jrsanche's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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
The administrator has disabled public write access.

Re: Do I need a bigger machine? 2 years 9 months ago #81171

  • jrsanche
  • jrsanche's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
Sorry, I said "But the performance has decreased." when I wanted to say "But the performance is not much better".

Thanks,
The administrator has disabled public write access.

Re: Do I need a bigger machine? 2 years 9 months ago #81175

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6952
  • Thank you received: 929
  • Karma: 277
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
The administrator has disabled public write access.

Re: Do I need a bigger machine? 2 years 9 months ago #81253

  • jrsanche
  • jrsanche's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
Thanks for your reply, Denis. We'll try the query_cache and the tmp_table_size params.

Juan Ramón
The administrator has disabled public write access.

Re: Do I need a bigger machine? 2 years 9 months ago #81269

  • jrsanche
  • jrsanche's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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 administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.151 seconds
Donation Image