Debian ARM / PHP MySQL Optimization

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
yggdra
Posts: 4
Joined: Mon Sep 08, 2014 3:29 pm

Debian ARM / PHP MySQL Optimization

Post by yggdra » Mon Sep 08, 2014 5:28 pm

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

Thorsten
Posts: 14774
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Debian ARM / PHP MySQL Optimization

Post by Thorsten » Mon Sep 08, 2014 7:17 pm

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

yggdra
Posts: 4
Joined: Mon Sep 08, 2014 3:29 pm

Re: Debian ARM / PHP MySQL Optimization

Post by yggdra » Mon Sep 08, 2014 10:10 pm

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

Post Reply