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
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
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
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
I/O Benchmarking
Creating high performance dynamic web sites with the Varnish HTTP accelerator
How to add a monitoring page to your website, letting you quickly find out if your site is working
Frequent Database Backups With Xdelta
Hunting the Performance Wumpus
Monitoring VMware ESX System Health and Hardware using Nagios
Templating Windows server builds using VMWare ESX without VMware Infrastructure
Easy LVM volume extension
Nagios notification options
support/email/setting_up_your_email_client/Sending_email_via_Anchor
Comparison of virtualisation technologies
Server Rack Equipment Layout and Cable Organisation Ideas
Windows Server 2008 for Web Hosting
Anchor's IPv6 Deployment Plans
Advanced Monitoring of Network, Servers, Websites and Applications using Nagios
Australian Made Web Hosting
Per-domain Traffic Reporting and Usage Analysis for Web, E-mail and FTP
VPS Implementation considerations at Anchor
Automated Websites - a list of things you'll need to think about