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

Red Hat News

Leftovers: Ubuntu

Linux Devices

  • AsteroidOS 1.0 Alpha on the Asus Zenwatch 3
    In a previous article, I published a small userspace image and Linux kernel for the Zenwatch 3 that enables root access with SSH over USB on the watch. By now, I reached my initial goal to get AsteroidOS, the alternative Android Wear operating system, running on the Zenwatch 3. Similar to SailfishOS and Ubuntu Touch, AsteroidOS uses the original Android kernel - a patched Linux kernel - with a GNU/Linux userspace that, in turn, also uses some of the original, closed-source Android libraries to access certain hardware like the GPU. As the Android libraries expect a different software ecosystem, e.g., a different C library called bionic, we cannot simply call the Android libraries from within a common GNU/Linux application. Instead, we need an additional software layer that translates between the Android and the common GNU/Linux world. This layer is called libhybris.
  • How Ironic: Harman Kardon’s Microsoft Cortana Speaker Is Powered by Linux
    Harman Kardon, the company recently acquired by Samsung, has developed its very own Cortana speaker, which is very similar to the Amazon Echo but featuring Microsoft’s famous digital assistant. And since Cortana is the key feature of this little device, it only makes sense for Harman Kardon to turn to Windows 10 to power the device. And yet, it looks like the so-called Harman Kardon is actually running Linux.
  • MontaVista® Launches Carrier Grade eXpress®(CGX) 2.2 Linux® for 5G and IoT at MWC 2017
  • The Numbers Article for Mobile in 2017 - All the Statistics You Could Ask For
    Mobile is the hottest industry. Banking and payments are rushing to mobile. Governments doing healthcare and education with mobile. Travel from airlines to taxis to trains and busses to hotel bookings is going mobile. Your driver's licence is migrating to the mobile phone as are your keys to your home. And all the other big tech stories from Internet of Things (IoT) to 'Big Data' analytics to Cloud computing - are all dependent on mobile. And next week we have the massive industry event in Barcelona, Mobile World Congress. My brand new TomiAhonen Almanac 2017 is now finished and is released today. So this is the perfect time to do my annual 'State of Mobile' blog of the major statistics. What are the big numbers. Lets start with reach. Yes, mobile is by far the most widely-spread communication technology humankind has ever witnessed.
  • Tizen Store Expands Its Service Coverage to 222 Countries
    The Tizen Store, as the name suggests, is the Tizen Application Store for developers to publish their free and paid for Tizen apps. In April 2015, we saw the store expand it’s coverage to include 182 countries, which was mainly for FREE apps, but we saw this as setting the foundation for providing paid for apps further down the road.

Android Leftovers