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
VMware ESX Server Security Lockdown
DNS Management
Installing Tomcat 6 with Java 6 and Apache 2.2 on Windows Server 2003 x64
Using Whois and Dig to investigate domain and DNS records
Tuning PostgreSQL on your Dedicated Server
Make sure you order support with your dedicated server!
An introduction to SQL query optimisation
Why does one web host cost more than another?
Efficient file storage
A comparison of data limits on web-hosting vs residential broadband services
Storing mail accounts in MySQL
MySQL storage engines
Subversion server
Why we don't do game server hosting
An Idiot's Guide To Installing A Version Control File Systems
Version Control System Using Sub Version
Load Balancing and Clustered Dedicated Server Architecture Considerations
Dedicated server purchasing guide
RAID configurations
Dedicated server and Co-location data billing models
Server Racks - suppliers in Australia
Full rack colocation power restrictions that effect rack density
Postfix Makefiles
SSH Public Key Authentication - Server Configuration
SSH Key Authentication - Client configuration
Securing remote access via SSH, dealing with passwords
How to correctly set the From address on email that is sent from your website
Web hosting and dedicated hosting tutorials by Anchor
Web hosting and dedicated hosting tutorials by Anchor
Dealing with Character Sets and Encodings in MySQL
PhpMyAdmin installation
Preventing your site being crawled and indexed by robots.txt
Common Australian ISPs outgoing mail servers
Configuring Mozilla Thunderbird mail client
Triggers in MySQL: a cautionary tale
MySQL vs PostgreSQL comparison
Using PHP on Windows vs Linux
Installing PHP on Windows with IIS
Permitting remote access to your dedicated server
MySQL Administration
Automated cron job configuration
Looking Glasses from Australian network operators
Website Migration Process
Application versions supported in Anchor shared web hosting
Adding a new domain to postfix mail server on your dedicated server
Website migration process
Apache virtual host configuration on dedicated servers
Programming support guides for shared web hosting
Developer friendly hosting
Installing Moin Moin as a cgi on a shared web hosting account