a public resource for all things web hosting, systems administration, and dedicated server management.

Anchor Web hosting knowledgebase

The Anchor wiki is a collection of articles, tutorials, howto's and support guides focused on just one topic - web hosting. We hope these guides will be useful not just to our clients but the general public as well. So much of what we do at Anchor is so reliant on free and open source software that we thought it only appropriate to give back in some way.

Feature Article - MySQL Storage Engines


This article offers a discussion on the plethora of storage engines available for use with late releases of the MySQL database management system (DBMS). Our focus will be on the two most widely-deployed — and talked about — engines, InnoDB and MyISAM.

What is a storage engine?

It is not uncommon to hear of developers who have worked with MySQL for some time before realising that the root cause of their poor-performing application is a direct result of their choice of storage engine. This can seem confusing at first, as no conscious choice has often been made. Developers infrequently need to think about such low-level details by design: how your DBMS structures your high-level view of tables on disk is rarely significant to the task at hand, so it is abstracted away.

A MySQL storage engine is best thought of as the end of the line in terms of a query's reach into the DBMS. It is the storage engine's routines that govern the translation to on-disk, machine-friendly data formats (and the same in reverse). A storage engine will impose various functional limits on your application, some more significant than others. (Limitations for the InnoDB and MyISAM storage engines are discussed below.) Heavily-loaded applications that are functionally compatible with more than one storage engine may suffer performance setbacks when thoughtlessly paired with a particular engine. Complex, well-designed applications layered on top of MySQL are often designed to work with more than one storage engine to gain the best of all worlds. (more...)

More article listings


Requests & Feedback


Is there a server management or web hosting topic you think we could help with? Find an error in our work? Let us know, send us your requests: support@anchor.com.au

Most recently created hosting articles

  Taking advantage of filesystem ACLs
  How to detect Malware attacks and prevent them from re-occurring
  Sending Email via Anchor - Mail.app
  Sending Email via Anchor - Entourage 2008
  support/programming/CreditCardPayments/APG_XML-RPC_Guide
  support/programming/CreditCardPayments/APG_Response_Codes
  Improving Server Capacity
  Logical Volume Management
  Automatic updates for linux servers
  Setting up Postfix for SMTP Auth with the Dovecot SASL backend
  Connecting to a Xen guest console via VNC
  Deleting/Removing fully virtualised Xen Guest
  Using Anchor provided Xen virtualisation
  xen/Commonxencommands
  Create Fully Virtualised Xen Guest
  xen
  Oracle initscript and usability improvements
  Anchor Windows IPSec/L2TP VPN Setup
  Sending Email via Anchor - Mozilla Thunderbird
  Rolling out your website's codebase, easy and pain-free
  Setup Entourage 2008
  Serving streaming flash video
  Setup Windows Mail
  Root privileges on Anchor dedicated servers
  Sending Email via Anchor - Windows Mail
  Sending Email via Anchor - Outlook 2007
  PasswordVaults
  support/MySQLConnecting_to_mysql_remotely
  Setting file permissions via SSH
  filtergen
  Running Rails 2.3 Using CGI with Rack
  Bulk Email Marketing - Information you should know before emailing
  planning/dedicated-colocation-data-billing-models
  Common Australian ISPs outgoing mail servers
  OpenSSL Commands
  Setup Outlook 2003
  Dedicated server and Co-location data billing models
  Creating A Quick MySQL Relational Database Tutorial Using All Common Relationships
  support/programming/CreditCardPayments/Integration_Guide
  How to use a swapfile on linux
  Pegasus Mail client configuration guide
  Performance figures for the Postfix MTA
  How to get started with GlassFish application server
  Setup Outlook 2007
  Handling Massive Filesystems
  A process for web hosting migration of large numbers of websites
  PCI Compliant Hosting
  Linux Software RAID Disc Replacement Procedure
  RAID Hard Disk Replacement
  IP Traffic Accounting



Did did you find this article useful? Then See also articles on: Web hosting support, dedicated server administration and useful hosting tools