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.
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/
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.
