Best mysql configurations

In this post i will describe what are the best configurations for mysql server, you can edit your my.cnf file to reflect the changes. To do so follow the below steps:

  • Login to your server via putty or shell/terminal with root access.
  • Execute following commands:
# cd /etc/mysql
# nano my.cnf
  • Now you are in text editor with opened file my.cnf here you can copy and paste the below code into it and then save it.
#skip-innodb
[mysqld]
#socket=/path/to/mysql.sock
#datadir=/var/lib/mysql
skip-locking
local-infile=0

# MySQL 4.x has query caching available.
# Enable it for vast improvement and it may be all you need to tweak.
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
max_connections=60
interactive_timeout=100
wait_timeout=100
connect_timeout=100
table_cache=512
thread_cache=32

[mysqldump]
quick
max_allowed_packet = 2M
[mysql]
no-auto-rehash

[isamchk]
key_buffer=50M
sort_buffer_size = 4M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 4M
sort_buffer_size = 4M
read_buffer = 2M
write_buffer = 4M
  • Now press CTRL+O and the press [Enter] settings will be saved and then execute following below command:
/etc/init.d/mysql restart
OR
service mysql restart
OR
restart mysql
  • You can find your my.cnf file in mysql directory it might be different from the location that i mentioned above.
You are welcome to ask any question regarding above tutorial…

Apache2 high RAM usage resolution

In this post i will describe how to decrease memory usage of apache2, i tried to search on google and found many solution to that problem but nothing worked for me. So i discovered a way to decrease the memory usage of apache2.

Apache

Apache

Here is the solution:

  • Login to your server via putty / shell terminal with root access.
  • Execute following command:
# cd /etc/apache2
# nano apache2.conf
  • A text editor will appear with apache2 configuration file find the below line in it:
KeepAlive On
  • Replace this line with:
KeepAlive Off Read More

Initial setup of WHM/cPanel

cPanel/WHM configurations

cPanel/WHM configurations

In this post i am going to describe how to setup your whm/cPanel for the first time. Login to your whm/cPanel with root username and password by typing your ip address and port number in url bar of browser as stated below:

http://your-ip-address:2086/

First Step:

On very first page you will see license agreement of cPanel/WHM just accept it.

  • Agreement: Accept the agreement.

2nd Step:

Here you are required to configure networking options for the WHM/cPanel.

  • Setup Networking: 
  • Hostname: In the server’s host name write your host name such as server1.yourdomain.com
  • Resolvers: Leave these options as they are, as they are configured automatically.

3rd Step:

Here you will see all available ip address and the actions that can be done on them.

  • Setup IP address: Leave these fields as they are. Skip this option Read More

Claim your free google adword promo code

Hello,

We are giving free Google Adword Promo Code to our visitors, to claim yours send email at offers[at]websterz.net containing following information:

  1. Your Name
  2. Your Web Site Address
  3. Your Valid Email Address

Note: Offer is limited and can be closed anytime with or without notice.

You must like us on FaceBook to get your free promo code and to stay up to date by new promotions and offers.

http://facebook.com/websterz.net
http://fb.websterz.net

Thank You!

Installing WHM/cPanel on dedicated server/vps | whm/cpanel trial

installing cpanel/WHM

installing cPanel/WHM

In this post i will discuss how to install WHM/cPanel trial version on dedicated server or onVPS, if your IP has not used cPanel/WHM before you will be eligible to use trial version of WHM/cPanel (30 days for dedicated server and 15 days for VPS) once your trial is over you need to license for it.

Minimum Requirements:

  • 512 MB minimum RAM
  • 10GB minimum Hard Disk
  • 2 GHZ minimum processor
  • 1 Public IP
  • Linux CentOS 5+/CentOS 6 Read More