Comments Off on Remove Duplicate Rows in MySQL

Remove Duplicate Rows in 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…

Optimize MySQL innodb_buffer_pool_size

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.…

Optimize MySQL tmp_table_size

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…
Comments Off on Change MySQL Data Directory

Change MySQL Data Directory

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…

Optimize MySQL table_open_cache

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…

Optimize MySQL query_cache_size

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…
Comments Off on MySQL system variables

MySQL system variables

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…

Installation of Varnish caching server

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,…
Comments Off on Install Google mod_pagespeed

Install Google mod_pagespeed

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…
Comments Off on Getting real client IP through Varnish

Getting real client IP through Varnish

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

Optimization of Apache webserver with Varnish installation

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…
Comments Off on Speed and Performance Optimization of WordPress

Speed and Performance Optimization of 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…

Migrating WordPress website to a new hosting provider

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…
Comments Off on Repair WordPress Database by PhpMyAdmin

Repair WordPress Database by PhpMyAdmin

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…
Comments Off on Optimize WordPress Database by PhpMyAdmin

Optimize WordPress Database by PhpMyAdmin

Optimize WordPress Database by PhpMyAdmin This post will describe how to “Optimize WordPress Database by PhpMyAdmin” in step by step. Now a days, many people…
Comments Off on Fastest way to select a random row from a big MySQL table

Fastest way to select a random row from a big MySQL table

Fastest way to select a random row from a big MySQL table In this article I will try to explain the “Fastest way to select…

Connect oracle database from php in Redhat/CentOS

Connect oracle database from php in Redhat/CentOS/Fedora The post will describe how to connect Oracle database from PHP in Redhat/CentOS in step by step. The…
PHP

MySQL Version Upgrade in Redhat/CentOS from 5.1 to latest

MySQL Version Upgrade in Redhat/CentOS from 5.1 to latest If you follow traditional procedure for “MySQL Version Upgrade in Redhat/CentOS from 5.1 to latest” ,…