Posted by yolau
In this article I will try to teach you all the tricks to make your webserver (apache) run faster. While the information in this article is not necessary new I tried compressing all the useful tips in one short article.
I’ve put this article on hold for far too long but here it it.
I would [...]
Posted by yolau
MySQL can sometimes create big problems on a server when you have users abusing it.
This article will teach you how to correctly identify the queries that are creating a problem for your server.
MySQL can log those queries that are taking longer then X seconds but this future is not turned on by default.
Here’s how you [...]
Posted by yolau
Tuning the performance of MySQL can be a really hard job to do.
There are many thinks to consider and no two servers are identical so there is no universal solution.
Tuning Primer is a script that will help you tune your mysql installation by providing very healthy recommendations based on past mysql records.
For the script to [...]
Posted by yolau
What is mytop?
mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server. It runs on most Unix systems (including Mac OS X) which have Perl, DBI, and Term::ReadKey installed.
You will find more details on the homepage at http://jeremy.zawodny.com/mysql/mytop/
How to install
Download mytop
wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
Extract and change [...]
Posted by admin
What is APC?
APC is a free, open, and robust framework for caching and optimizing PHP intermediate code.
Install instructions
Login to the server as root
Download APC
wget http://pecl.php.net/get/APC-3.0.14.tgz
Extract and move into the directory
gzip -d APC-3.0.14.tgz
tar -xf APC-3.0.14.tar
cd APC-3.0.14
Locate where php is
which php
This should return something like: /usr/local/bin/php
We have to remember the location of php
Create configuration files
phpize
Compile APC
./configure –enable-apc [...]
Posted by admin
What is Eaccelerator?
eAccelerator is a free open-source PHP accelerator, optimizer, and dynamic content cache. It increases the performance of PHP scripts by caching them in their compiled state, so that the overhead of compiling is almost completely eliminated. It also optimizes scripts to speed up their execution. eAccelerator typically reduces server load and increases the [...]