Tag: Storage Engine
MySQL Performance: MyISAM vs InnoDB
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.”
How to Display MySQL Storage Engines
- 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.
How to Set Up and Use Cloud Block Storage
What is Cloud Block Storage?
Cloud Block Storage provides additional hard drive space for your Private Cloud Hosted 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.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.