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

Enlightenment E19 RC3 Shows Off The New Wayland Compositor

The E19 RC3 release most notably features the rewritten Wayland compositor that was talked about on Phoronix earlier this week. The Wayland compositor rewrite for Enlightenment reduxes the memory footprint along with the code-base size and at the same time lowers the rendering complexity. This new version also supports Wayland clients inside X11, wl_shell/xdg_shell protocol support, initial support for standalone Enlightenment Wayland, and has no hard requirements on X11. This new compositor is still considered unstable and doesn't yet feature XWayland support. Read more

Linux Foundation's certification sets new benchmark for admins

At LinuxCon last week, the Linux Foundation announced a new certification scheme for Linux professionals to complement their existing training activities. The Linux Foundation Certification Program offers a peer-verified certification for both early-career and engineer-level systems administrators for a fee of $300. The process involves a real-time skill test administered via a remote-access virtual machine running one of several Linux distributions. To ensure the rules are followed, a human proctor watches the test via screen-sharing and video camera using your own computer at a location of your choice. The certification tests real-world skills for both sys admins and more senior engineers at the command line and in configuration files. Read more

Linux Mint Debian to Be Called "Betsy"

"The upcoming release of LMDE will be version 2, codename 'betsy' and it will use a Debian 'jessie' package base. The team is currently adapting to the new LMDE, setting up its repositories and porting various packages onto it. The target for a stable release is estimated for this November, along with an official upgrade path from UP8 to Betsy," said the leader of the Linux Mint project, Clement Lefebvre. Read more

Adapting to the Mobile World

Now more than ever companies are gaining a mobile presence due to the popularity of smartphones and tablets. It is important to any company’s success to become part of the mobile world if they want to build business. Consumers used to look up companies in the phonebook, but now the first action consumers take when they need to find a company is to look them up online. If consumers cannot find a company online, they are likely to find a different company instead of continuing the search through other means. Because the Internet is so easily accessed from mobile devices now, consumers use their devices to find their favorite companies so a strong mobile presence is a must if companies do not want to lose business. Hasbro goes mobile According to Mobile Marketer, Hasbro has decided to create a mobile presence in order to keep up with video games. So far Hasbro’s Monopoly application has been a great success because it promotes family and friend engagement and users can personalize the app by uploading pictures of themselves to use as game pieces. Consumers like personalization, and so if companies want to see success from their mobile marketing strategies they should consider personalizing them to consumers in some way. Companies hesitate to go mobile because they are set in their ways, and they might already be seeing success, however as technology advances all companies should consider building a mobile presence if they want to continue to be successful. Successful mobile marketing techniques Thanks to mobile devices there are a number of ways companies can reach out to consumers who use them. SMS advertisements are a great way to personalize advertising for consumers making them feel important and ultimately driving in business. Marketing applications are another way companies can engage with consumers on a more personal basis. Consumers like to be in control, and applications are a great way they can control the type of marketing they receive. If apps are intriguing enough, consumers are likely to promote them to friends and family, which will ultimately promote business. Convenience of being mobile Consumers like the convenience of being able to locate and engage with their favorite companies from their mobile devices, so it is important that companies maintain that presence. Consumers are looking for ways to make their lives easier, and being able to purchase products with the click of a button or pay bills on the fly will only increase business for companies because consumers are always looking for convenience. Being mobile can benefit companies in several ways, but one way that is especially appealing to companies is the ease of keeping track of business thanks to their mobile presence. Mobile devices and websites help companies to keep track of important data such as which marketing strategies are working the best and where most of the sales are coming from. Being mobile can enhance business in several ways and should be a priority for all companies. Mobile Technology News brought to you by businesstexter.com Source: mobilemarketer.com/cms/news/gaming/18437.html