Page 1 of 1

Debian ARM / PHP MySQL Optimization

Posted: Mon Sep 08, 2014 5:28 pm
by yggdra
Hi,

I'm running phpMyFAQ on Debian ARM OS with the latest phpMyFAQ.

Some sites are loading really slowly while others are not loading at all due to timeout. I was wondering if there was a way to optimize phpMyFAQ settings to speed up the load times. I also don't think the websites are not caching to a local browser. I've tried changing the webserver from Apache to Lighttpd but it's still really slow. I'm also thinking about changing MySQL to PostGres database.

Let me know if there is a way to make the system run more efficiently.

Software:
php version 5.4.4-14+deb7u14
mysql version 5.5.38
apache 2.2.22
debian ARM 7.5 wheezy

Hardware:
512MB DDR3 RAM
AM335x 1GHz ARMĀ® Cortex-A8 processor.

Thanks.

Chris

Re: Debian ARM / PHP MySQL Optimization

Posted: Mon Sep 08, 2014 7:17 pm
by Thorsten
Hi,

oh, wow, interesting hardware setup. I could try to install phpMyFAQ on my RasPi for some performance debugging if you like. Maybe you could try SQLite3?

Cheers
Thorsten

Re: Debian ARM / PHP MySQL Optimization

Posted: Mon Sep 08, 2014 10:10 pm
by yggdra
Thanks Thorsten.

I'm trying to run it on Beaglebone Black http://beagleboard.org/black and it works well with websites with images and text. But when I have numerous tables using <tr> or <td>, it gets really slow.

Also, I noticed that you've decided not to cache. (Cache-Control: no-store, no-cache, must-revalidate") Would caching help in my situation?

I'll try SQLite3 with Lighttpd combination tomorrow and see if that works better. If you could have it running on RasPi for some performance debugging, that would be great!!!
I know a lot of people are trying to run various apps on small development platforms and having phpMyFAQ running on it is awesome.

v/r,

Chris