Ankur Kashyap
Better queries with MySQL

Better Queries with MySQL, Part 3: The MyISAM Storage Engine

MyISAM is MySQL’s default storage engine, and is probably most commonly used by new adopters of MySQL. The objective of this article is to discuss how the MyISAM storage engine works, to enable…

Better queries with MySQL

Better Queries with MySQL, Part 2

Last month, we created a simple table with an index. The idea was to understand how indexes work in MySQL. For this, we populated the table with 100 rows, and ran EXPLAIN with…

Better queries with MySQL

Better Queries with MySQL, Part 1

This article helps you write high-performance MySQL queries, by pointing out the various pitfalls and dangerous misconceptions that developers have. How many times have you found yourself in a situation where your Web…

All published articles are released under Creative Commons Attribution-NonCommercial 3.0 Unported License, unless otherwise noted.
Open Source For You is powered by WordPress, which gladly sits on top of a CentOS-based LEMP stack.

Creative Commons License.