MySQL Performance Series: Part II. MyISAM vs InnoDB

The second article in my multi-part series on MySQL Performance. Published by Liquid Web, Inc on the Liquid Web Knowledge Base. This article discusses the use cases for both MyISAM and InnoDB, a widely contentous topic to be sure. Both MySQL engines have their niche and in their niche they perform very well. This article is a guide to understanding when, why and how to use MyISAM vs InnoDB.

MySQL Performance: MyISAM vs InnoDB

MySQL Performance Series: Part I. Identifying Long Queries

The first in a multi-part series on MySQL Optimization written for Liquid Web, Inc. This one covers the basics of identifying bottlenecks using mysqladmin and mysql to view the MySQL process list. If you’ve been interested in optimizing your database setup, this is just the start of a longer series where I cover several topics all related to MySQL Optimization.

https://www.liquidweb.com/kb/mysql-performance-identifying-long-queries/

 

 

What is a LAMP Stack?

My very first published article and it’s a good one. An outline of what makes up a typical LAMP stack and how knowing each layer applies to site owners and developers. Understanding the LAMP stack is critical for optimization. We all want our sites to perform there very best, but there is no one-size-fits-all solution when it comes down to server performance. A basic understanding of these software layers allows you to properly configure each directive to best perform for your unique site, user base, traffic and hardware configuration.

What is a LAMP stack? – Liquid Web
Learn about What is a LAMP stack? today with Liquid Web.
www.liquidweb.com