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

San Francisco Open Source Voting System Project Continues On

At the February 15 Elections Commission meeting, the Elections Commission voted unanimously to ask the Mayor's Office to allocate $4 million towards initial development of the open source voting project for the 2018-19 fiscal year (from Aug. 2018 - July 2019). This would go towards initial development once the planning phase is complete. Read more

Detailed change log for deepin 15.4 RC

deepin is a Linux distribution devoted to providing beautiful, easy to use, safe and reliable system for global users. After public test of deepin 15.4 Beta, we have received a lot of suggestions and feedback, we adopted part of them and fixed a lot of problems. Read more

GNOME 3.24: New Linux desktop is fast, responsive

I’ve been a fan of the work of the GNOME team for quite some time. They put together one heck of an excellent Linux desktop environment. But of late, I’ve found myself gravitating towards some of the more lightweight environments. MATE (which is a forked version of GNOME 2) and xmonad. I like my systems to be light on resource usage and highly responsive—those are two absolutely critical things for the way I use my computers. With this week’s release of GNOME 3.24, I decided to jump back into the world of modern GNOME desktops and kick the tires again. In order to give it the best possible shot, I did a clean install of openSUSE Tumbleweed (the rolling release version of openSUSE) and then installed GNOME 3.24 on top of it. (Side note: 3.24 was not yet available in the default repositories when I wrote this article, but it should be shortly.) Read more Also: Applying to Outreachy and GSoC for Fedora and GNOME

OpenSuse Leap Reinforces Linux Faith

Leap is a solid performer. I had no trouble installing it on MBR and EFI systems. Secure Boot tends to be buggy with some configurations, but it was incident-free with this installation. The bootloader handles multiboot with other Linux distributions or Windows fairly trouble-free. Installation is routine, thanks to the graphical format used. Only 64-bit versions are available for x86 computers, which limits access to legacy hardware in the 32-bit machines. ARM ports are available if you can track them down through the project's wiki. Read more