MySQL Performance: MyISAM vs InnoDB

Reading Time: 5 minutes

 

A major factor in database performance is the storage engine used by the database, and more specifically, its tables. Different storage engines provide better performance in one situation over another. For general use, there are two contenders to be considered. These are MyISAM, which is the default MySQL storage engine, or InnoDB, which is an alternative engine built-in to MySQL intended for high-performance databases. Before we can understand the difference between the two storage engines, we need to understand the term “locking.” Continue reading “MySQL Performance: MyISAM vs InnoDB”

How to Display MySQL Storage Engines

Reading Time: < 1 minute
Pre-Flight Check
  • These instructions are intended for displaying a list of the installed MySQL storage engines.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

Continue reading “How to Display MySQL Storage Engines”

How to Set Up and Use Cloud Block Storage

Reading Time: 4 minutes

What is Cloud Block Storage?

Cloud Block Storage provides additional hard drive space for your Cloud Server with just a few clicks. The space is not pre-formatted but rather, it is a raw block device. The simplicity of providing a raw block device on the cloud means that you can mount and format the space on your server however you would like, with whatever filesystem is appropriate for your needs. This does entail a small amount of work getting the space into a usable state which we will address in this article.

Continue reading “How to Set Up and Use Cloud Block Storage”