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

IBM Promises Apache Spark for Linux on Z Systems

Expanding the z Systems ecosystem means data scientists can use Apache Spark’s common programming framework and get the full use of the mainframe’s advanced analytics capabilities - without having to get sidelined by any specific format for data. Read more

Red Hat augments presence in Malaysia

Senior director and general manager, ASEAN, Damien Wong Yok Weng said Malaysia was an important market for the company and it had much potential for the adoption of open source technology across industries. Speaking to reporters at the official announcement of the subsidiary here, Wong said in terms of expansion strategy, Red Hat had looked at all the surrounding factors in the information technology (IT) industry. Read more

An Everyday Linux User Review Of Android x86 - Release 4.4 r3

This review might not be very long but I have spent a long time playing and experimenting with Android x86 and if you stick with it and are willing to play with settings then you may get something close to desirable. Those who will get the most out of Android x86 will be using a computer with a touchscreen. Read more

Will an upgrade to Windows 10 on a dual-boot system mess GRUB up?

If the setup is on a computer with UEFI firmware, with the boot files of all systems on the EFI Boot Partition, then I don’t see anything that will mess GRUB up during or after upgrading to Windows 10. That’s because the EFI Boot Partition is like a public park, where the space occupied by each operating system’s boot files is respected. So the Windows 10 upgrade script will only update the files and directory that pertains to the Windows boot manager. That this is true has been verified by none other than a Microsoft employee in this blog post. The same goes with the upgrade script of the installed Linux distribution(s), but you knew that already. Read more