"InnoDB" tag
Comprehensive LAMP guide

The Comprehensive LAMP Guide — Part 2 (MySQL)

MySQL is the most widely used Relational Database Management System (RDBMS), and is the “M” in the LAMP stack. One of the main uses for MySQL is with Web applications. To avoid the…

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.