Author: admin

Comments Off on Creating Custom Google MAP

Creating Custom Google MAP

Google Map
Creating Custom Google MAP is an easy but powerful  way to represent  your location. You can  create  custom Google Map  and embedded it into your…
Read More
3

fixing mysql replication error automatically

Database Linux MySQL
This article is written for those who have already read article “MySQL Replication skip error” . In that article I explained how to find out replication…
Read More
Comments Off on Create database and user in phpMyAdmin

Create database and user in phpMyAdmin

Database MySQL phpMyAdmin
phpMyAdmin is a great tool to manage MySQL and MariaDB database.  Every cPanel allows  phpMyAdmin interface to manage the hosting database. It is often required…
Read More
1

Install WordPress in Bangla

WordPress
Install WordPress in Bangla WordPress displays in U.S. English (en_US) by default. But the software has the built-in capability to be used in any language..…
Read More
Comments Off on Install WordPress in other language

Install WordPress in other language

WordPress
Install WordPress in other language WordPress displays in U.S. English (en_US) by default. But  the software has the built-in capability to be used in any…
Read More
Comments Off on Top 3 alternatives of Google Adsense

Top 3 alternatives of Google Adsense

Adsense
Google Adsense is the best advertising network for online earning. However, nowadays it is very difficult for new bloggers or website owner to get approved…
Read More
Comments Off on Top 7 Social Networking Sites

Top 7 Social Networking Sites

Social Networking
The most popular social networking sites sure have changed over the years, and you can expect them to continue to change as times goes on. Old social…
Read More
Comments Off on Sum Column in Linux

Sum Column in Linux

AWK Linux
Sum column in Linux  is very easy  and you can do it by a single command.  If you have a file with multiple columns and…
Read More
7

MySQL Replication skip error

Database MySQL
MySQL Replication skip error There are two ways you can configure MySQL replication : normal and GTID based replication. From MySQL 5.6 GTID based replication…
Read More
Comments Off on Important Linux and Unix Commands

Important Linux and Unix Commands

Linux
  Necessary Linux / Unix Commands There are a lot of articles on the web regarding Linux commands. Here I have listed some of my…
Read More
Linux
1

Install OCI8 on CentOS/Redhat/Fedora

Database Linux Oracle PHP
Install OCI8 on CentOS/Redhat/Fedora The post will describe how to Install OCI8 on CentOS/Redhat/Fedora in step by step. The easiest way to configure PHP to access…
Read More
Comments Off on Remove Duplicate Rows in MySQL

Remove Duplicate Rows in MySQL

Database MySQL
Remove Duplicate Rows in MySQL Remove duplicate rows in MySQL is a common query for many initial MySQL user. I  have been working on MySQL…
Read More
3

Optimize MySQL innodb_buffer_pool_size

Database MySQL
Optimize MySQL innodb_buffer_pool_size InnoDB buffer pool is the size in bytes of the buffer pool, the memory area where InnoDB caches table and index data.…
Read More
2

Optimize MySQL tmp_table_size

Database MySQL
Optimize MySQL tmp_table_size MySQL tmp_table_size is  the maximum size of internal in-memory temporary tables. (The actual limit is determined as the minimum of tmp_table_size and max_heap_table_size.) If…
Read More
Comments Off on Change MySQL Data Directory

Change MySQL Data Directory

Database MySQL
Change MySQL Data Directory In Redhat/CentOS/Fedora MySQL default data directory remains in /var/lib/mysql. Sometimes you need to change MySQL data directory to a new location…
Read More
8

Optimize MySQL table_open_cache

Database MySQL
Optimize MySQL table_open_cache The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can…
Read More
2

Optimize MySQL query_cache_size

Database MySQL
Optimize MySQL query_cache_size The MySQL query_cache_size is an in memory caches that stores the complete result sets of frequent SELECT queries. Instead of issuing the…
Read More
Comments Off on MySQL system variables

MySQL system variables

Database MySQL
Important MySQL System Variables MySQL is mostly used open source database which is very fast and effective when you perfectly configure it.  In this article…
Read More
2

Installation of Varnish caching server

Apache Varnish Webserver
Installation of Varnish caching server in Redhat/CentOS/Fedora Varnish will significantly improve your website performance as it responses static pages from cache. After installation of Varnish,…
Read More
Comments Off on Install Google mod_pagespeed

Install Google mod_pagespeed

Apache PageSpeed Webpage Optimization Webserver
Install Google mod_pagespeed Fast and optimized pages lead to higher visitor engagement, retention, and conversions. Google mod_pagespeed si an Apache module for Website Optimization which…
Read More
Comments Off on Getting real client IP through Varnish

Getting real client IP through Varnish

Apache Varnish Webserver
Getting real client IP through Varnish After installation Varnish as frontend caching server your Web server ( like Apache, Nginx etc.) and application (PHP, ASP,…
Read More
Comments Off on Optimization of Apache webserver with Varnish installation

Optimization of Apache webserver with Varnish installation

Apache Varnish Webserver
Apache is a powerful, reliable and capable web server. The single biggest hardware issue affecting Apache webserver performance is RAM. In Linux by default Apache…
Read More
Comments Off on Speed and Performance Optimization of WordPress

Speed and Performance Optimization of WordPress

WordPress
Everyone hates slow websites. “Speed and Performance Optimization of WordPress”  is the key to success to attract visitors and to attain a good rank on…
Read More
24

Migrating WordPress website to a new hosting provider

Website Migration WordPress
Migrating WordPress website to a new hosting provider is not a difficult task and only takes 20-30 minutes if your database is not big. I…
Read More
Comments Off on Repair WordPress Database by PhpMyAdmin

Repair WordPress Database by PhpMyAdmin

Database MySQL WordPress
Repair WordPress Database by PhpMyAdmin This post will describe how to “Repair WordPress Database by PhpMyAdmin” in step by step. WordPress use MySQL database; and…
Read More