30 Jun 08 LAMP Optimization

Here’s 3 easy steps to immediately boost your Linux Apache MySQL PHP installation.

- Apache:
Make sure you’re using the correct number of spare threads and minimum and maximum constraints. Too few available threads mean that a new one will have to be spawned for a site access leading to a decrease in response time, but too many available threads will eat memory unnecessarily

- MySQL:
Is your database performing a lot of SELECT queries on data that doesnt often change? Consider MySQL query caching. http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html

- PHP:
Does your code rarely change? Why not cache the output results until the information does change? Install the eAccelerator module for this. You’ll notice a massive improvement.

For the HOWTO, please see here: http://www.adamsinfo.com/php-mysql-apache2-install-howto-on-debian/

Tags: Apache, eaccelerator, LAMP Optimization, MySQL, Optimization, PHP, query cache, query caching, theads

Leave a Comment