Category: MySQL

Select random records in MySQL

There are some case we need to select random records in mysql. The normal way I did see many developers have used is ORDER BY RAND(). But they might not …

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