07 Oct 08 PHP, MySQL, Apache2 install HOWTO on Debian
>> Forums...Setting up a PHP/MySQL/Apache2 environment on Debian is really easy. I’ll walk through a quick Debian lamp install howto and optimization process. I’ve optimized it for a 1.5Gb to 2GB RAM machine with reasonable load.
apt-get install apache2 php5 mysql-server-5.0 mysql-client-5.0 libapache2-mod-php5 php5-mysql php5-curl php5-cli php5-dev make gcc libc6-dev automake
mysqladmin password ‘NEWPASSWORD’
Now download eaccelerator from http://eaccelerator.net
tar -xjf eaccelerator.tar.bz2
phpize
./configure
make
sudo make install
phpize
./configure
make
sudo make install
Edit /etc/php5/apache2/php.ini and add the following at the bottom:
extension=”eaccelerator.so”
eaccelerator.shm_size=”64″
eaccelerator.cache_dir=”/tmp/eaccellerator”
eaccelerator.enable=”1″
eaccelerator.optimizer=”1″
eaccelerator.check_mtime=”1″
eaccelerator.debug=”0″
eaccelerator.filter=”"
eaccelerator.shm_max=”0″
eaccelerator.shm_ttl=”0″
eaccelerator.shm_prune_period=”0″
eaccelerator.shm_only=”0″
eaccelerator.compress=”1″
eaccelerator.compress_level=”9″
eaccelerator.shm_size=”64″
eaccelerator.cache_dir=”/tmp/eaccellerator”
eaccelerator.enable=”1″
eaccelerator.optimizer=”1″
eaccelerator.check_mtime=”1″
eaccelerator.debug=”0″
eaccelerator.filter=”"
eaccelerator.shm_max=”0″
eaccelerator.shm_ttl=”0″
eaccelerator.shm_prune_period=”0″
eaccelerator.shm_only=”0″
eaccelerator.compress=”1″
eaccelerator.compress_level=”9″
Edit /etc/mysql/my.cnf
#
# * Fine Tuning
#
key_buffer = 64M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 4M
query_cache_size = 64M
# * Fine Tuning
#
key_buffer = 64M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 4M
query_cache_size = 64M
Restart services:
/etc/init.d/apache2 restart
/etc/init.d/mysql restart
/etc/init.d/mysql restart
Tags: apache2 optimization, debian, Debian lamp install howto, Development, LAMP, LAMP Optimization, MySQL, mysql optimization, Optimization, PHP, PHP Developer, PHP MySQL Developer, php optimization, php5, Programmer
Reader's Comments
Leave a Comment
I'm Adam Palmer, and I'm an Embedded Linux/Embedded Hardware enthusiast.
I spend most of my time managing server clusters, and doing some PHP/MySQL development, whilst what little spare time I have is dedicated to playing with gadgets.
I'm always happy to consult on or manage any Linux related, Web Application or Hosting project. Please get in touch with me!
Widgets & Links
Will the eaccelerator work if php/mysql/apache2 are being used by drupal, or in other words, can drupal use eaccelerator in a memory configuration similar to yours?
Yes Biff, eaccelerator is a PHP module and will work on anything that uses PHP (such as drupal). However, afaik, drupal has it’s own caching module so you could also use that instead.
Hey Adam,
I am using a nslu2 device with debian installed on it. It’s running php, mysql and apache on it.
I am using this device for my thesis as i was looking to design a web interface.
The nslu2 will be connect to my microcontroller through a usb to serial converter.
I was curios on how to send and receive data through the web interface which has to send the information over the usb port of the device.
Any help on the matter will be useful.
Thank you
Hello. I wrote a more advanced LAMP Tutorial on my own blog/forum for Debian Lenny specifically. It involves a lot of tweaks.
http://elliquiy.com/forums/index.php?topic=33085.0
The link may be taken as NSFW by some. Enjoy, however : )