Welcome, Guest
Username: Password: Remember me

TOPIC: mysql query cache / php memcache / apc / etc?

mysql query cache / php memcache / apc / etc? 4 years 5 days ago #51299

  • lovepade
  • lovepade's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 93
  • Karma: 0
Hi there,

Does anyone have any experience with optimizing performance using any of the mentioned techniques? I realize that this is as much a general question as it is LS specific - I am just nervours about possible caveats and dangeres, when tinkering with setting I don't understand fully.

Theres a sticky thread somewhere about phpsurveyor performing brilliantly - but its old and not really about caching techniques.

I plan to read up on nadeausoftware.com/articles/2007/01/esse...ing_drupal_web_sites and webjawns.com/2010/01/optimize-php-apache...-practices-and-more/

But any pointers from this forums would be great

Thanks in advance and have a splendid day :-)

A
The administrator has disabled public write access.

Re:mysql query cache / php memcache / apc / etc? 4 years 5 days ago #51307

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
I have great experience with apache .htaccess like this, makes it fly for me even without other optimisation. This is not failsafe, if the needed modules are not loaded you might get some errors.

Apc or other accelarator is a good idea in general. Read en.wikipedia.org/PHP_accelerator for more info and links.
#Caching
ExpiresActive on
ExpiresByType application/javascript "access plus 1 month"
ExpiresByType text/css "access plus 1 month"
ExpiresByType image/png "access plus 1 month"
ExpiresByType image/jpg "access plus 1 month"
ExpiresByType image/jpeg "access plus 1 month"
ExpiresByType image/gif "access plus 1 month"
ExpiresByType image/ico "access plus 1 month"
ExpiresByType image/x-icon "access plus 1 month" 
 
#Compression
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE text/css
AddOutputFilterByType DEFLATE application/javascript
---
Menno Dekker
The administrator has disabled public write access.

Re:mysql query cache / php memcache / apc / etc? 4 years 4 days ago #51390

  • lovepade
  • lovepade's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 93
  • Karma: 0
Wauw - thanks mdekker. Didn't even know about modding .htaccess like that.

The modules I need to copy/paste this is mod_expires and mod_deflate right? I think we have apc enabled, as it was just and install - no settings needed I think.
I think mysql query is the most important one - but thats just a feeling.

Do you, or any other, have pointers as to how I can simulate a big load on the server (for testing purposes)?

Sincerely
The administrator has disabled public write access.

Re:mysql query cache / php memcache / apc / etc? 4 years 4 days ago #51400

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
You are right on the apache modules.

For load testing: difficult, as you can only hit a certain page, not simulate clicking though the pages. But for example loadimpact.com/index.php can get you started online with simulated loads. Keep in mind that 50 users hitting your server at the same time is different than having 50 users take a survey and click through pages at varying speeds. There are other tools, like httpd.apache.org/docs/2.0/programs/ab.html but they need some experience to know how to use it right.

So I would say you can have quite a lot of users taking a survey, especially if you are not too heavy on conditions. The array filters seem to cause quite some load on the server somehow.
---
Menno Dekker
The administrator has disabled public write access.

Re:mysql query cache / php memcache / apc / etc? 4 years 4 days ago #51401

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
BTW, keep in mind that when you update and the js or css files get updated some browsers still serve the old ones from cache.
---
Menno Dekker
The administrator has disabled public write access.

Re:mysql query cache / php memcache / apc / etc? 4 years 3 days ago #51429

  • lovepade
  • lovepade's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 93
  • Karma: 0
Thank you, once again. I can't figure out if seleniumhq.org/ can help with a realistic click-through scenario.

The tweaking takes place saterday. hopefully I wont break anything :-)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.152 seconds
Donation Image