Language Selection

English French German Italian Portuguese Spanish

MySQL Storage Engines

Filed under
Software

Data in MySQL is stored in files (or memory) using a variety of different techniques. Each of these techniques employ different storage mechanisms, indexing facilities, locking levels and ultimately provide a range of different functions and capabilities. By choosing a different technique you can gain additional speed or functionality benefits that will improve the overall functionality of your application.

For example, if you work with a large amount of temporary data, you may want to make use of the MEMORY storage engine, which stores all of the table data in memory. Alternatively, you may want a database that supports transactions (to ensure data resilience).

Each of these different techniques and suites of functionality within the MySQL system is referred to as a storage engine (also known as a table type). By default, MySQL comes with a number of different storage engines pre-configured and enabled in the MySQL server. You can select the storage engine to use on a server, database and even table basis, providing you with the maximum amount of flexibility when it comes to choosing how your information is stored, how it is indexed and what combination of performance and functionality you want to use with your data.

This flexibility to choose how your data is stored and indexed is a major reason why MySQL is so popular; other database systems, including most of the commercial options, support only a single type of database storage. Unfortunately the 'one size fits all approach' in these other solutions means that either you sacrifice performance for functionality, or have to spend hours or even days finely tuning your database. With MySQL, we can just change the engine we are using.

In this article, we're not going to concentrate on the technical aspects of the different storage engines (although we will inevitably have to look at some of these elements), instead we will concentrate on how and where these different engines can be best employed. To achieve this, we'll have to look at some of the fundamental issues before moving on to the specifics of each engine type.

Full Article.

More in Tux Machines

Leftovers: Software

  • Ekiga 5 – Progress Report
    Ekiga 5 has progressed a lot lately. OpenHUB is reportin a High Activity for the project. The main reason behind this is that I am again dedicating much of my spare time to the project. Unfortunately, we are again facing a lack of contributions. Most probably (among others) because the project has been silent during several years.
  • Calibre Gets a New Tool to Better Edit eBooks
    The Calibre eBook reader, editor, and library management software has been upgraded to version 2.17 and is now available for download. The developer has only implemented a couple of new features, but it's really worth the update if you are using this application to edit eBooks.
  • More Windows Apps and Games Now Work with Wine 1.7.35, EA's Origin Included
    Wine 1.7.35 has been released and the developers have made a number of improvements for some of the core components and they've added support for more apps and games.

today's howtos

Leftovers: Gaming

  • Dying Light Action Survival Game Coming to Steam January 27
    Dying Light, a modern first-person survival horror game set in a world hit by plague, is now available for pre-purchase on Steam and will be available for download on January 27.
  • Dying Light FPS Has Been Confirmed for Linux, Zombies Galore
    Techland is preparing to launch Dying Light, a new FPS with amazing graphics and hordes of zombies. The developer has revealed that it will also have a Linux version, right from the start.
  • Dying Light Is Now Confirmed For Linux, Bring It On Techland
    Dying Light is now confirmed for Linux thanks to the announcement from the developers on the Steam store itself. The Linux icons show up on the store pages, and the game even has a steam coming soon banner on the home-page. Time to get seriously excited.
  • Star Traders: 4X Empires Strategy Game Now On Linux
  • 5 reasons Valve's Steam Machine dream is still very alive
    Steam Machines? More like has-been machines, am I right? Actually, no: while many people are giving Valve's PC-console-hybrids the cold shoulder, this gamer reckons they'll be worth the wait. I realise that I'm part of a shrinking group still backing Valve's SteamOS-powered Linux boxes, and it's not difficult to see why the hype around them has all but evaporated. Several controller-related delays, U-turns by seemingly committed hardware partners and a lack of news from the top has made many think that Valve is blowing hot air.

Android Leftovers