cPanel Config

Welcome to cPanelConfig the fastest growing cPanel configuration and troubleshooting guide on the internet. Please take the time and register. We would love to have your contribution to this completely free cPanel resource. We are updating this daily so be sure to visit us on a regular basis.

Apache tuning and optimization cPanel 11.x

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 [...]

Identifying slow MySQL queries

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 [...]

Install MySQL Performance Tuning Primer Script

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 [...]

Install mytop - top clone for MySQL

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 [...]

How to install APC (PHP Cache)

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 [...]

How to install Eaccelerator

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 [...]