Category: Database

Optimize only fragmented tables in MySQL

When you are using MySQL, you will (likely) have tables that can be fragmented.  Fragmented tables in mysql needs to be optimized. You could simply OPTIMIZE every table in every …

Redis – Installation and basic usage

Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted …

Pagination with large dataset

This article mentions common problems when performing pagination on a big data set and solutions to overcome them. Scenario When querying with a large dataset, we often use SELCT .... …

Setup MySQL Replication

This tutorial describes how to setup MySQL replication. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all …

Some MySQL performance tips

This article discusses about some MySQL performance tips which are collected over Internet and based on the experience of the author (me ^__^). Specific Query Performance Tips (see also database …