Category: MySQL

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 …

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 , but …

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 …