| MySQL is the world's most popular open source | | | | choose from multiple storage engines each table, |
| relational database management system. It is widely | | | | according to the requirements. |
| used web applications due to fast performance, high | | | | - MyISAM is a disk based storage engine. Aiming for |
| reliability and scaliblity, cost-effectiveness. Several | | | | very low overhead, it does not support transactions. |
| powerful and smart features make MySQL the | | | | MyISAM is default storage engine of MySQL. |
| ultimate choice for web applications. | | | | - InnoDB is also disk based, supports ACID |
| MySQL is especially designed to support indexing and | | | | transactional capabilities. It has strong referential |
| Full-text searching. Indexes are created on specific | | | | integrity. InnoDB requires more disk space than |
| fields of a table and MySQL stores the records sorted | | | | MyISAM to store its data, and this increased overhead |
| based on the index fields created. Below I mention | | | | is compensated by more aggressive use of memory |
| some of the features that makes it popular for web | | | | caching, in order to attain high speeds. |
| apps where mining of data is required from huge | | | | - Memory (formerly called "HEAP") is a storage engine |
| datastores. | | | | that utilizes only RAM. The tables are memory-based |
| - Full-text searching is ideal for extremely large | | | | and very fast. |
| databases that contain thousands or even millions of | | | | - NDB, the MySQL Cluster Storage engine, connects |
| rows. Computations are performed faster and rows | | | | to a cluster of nodes, offering high availability through |
| can be ranked based on search relevance, which is | | | | redundancy, high performance through fragmentation |
| returned as a decimal number by MySQL. | | | | (partitioning) of data across multiple node groups, and |
| - Noise words and any words that are 3 characters or | | | | excellent scalability through the combination of these |
| less in length such as the, and, etc are removed from | | | | two. NDB uses main-memory only, with logging to disk. |
| the search query. This means that more accurate | | | | MySQL has exceptional high performance query |
| results are returned. If you searched for "as the | | | | engine that can easily handle ever-increasing volume |
| people", then the noise words "the" and "as" will | | | | of users, transactions and data. Further data insertion is |
| automatically be removed from your query. | | | | also very fast . All these make it suitable for |
| - In addition to simple searches, full-text searches can | | | | high-traffic web sites. |
| also be performed in Boolean mode. Boolean mode | | | | MySQL uses features like main memory tables, B-tree |
| allows searches based on and/or criteria, such as | | | | and hash indexes, and compressed archive tables that |
| "%2Bperson %2BMitchell", which would only return all | | | | reduce storage requirements by up to eighty-percent |
| records that contained the words person AND Mitchell. | | | | make MySQL a strong standout for both web and |
| We will look at Boolean searches later in this article. | | | | business intelligence applications. |
| - The query is case-insensitive, meaning that "cat" is | | | | MySQL has many Plug-in libraries, so it can support |
| ranked the same as "Cat", "CAT" and "cAT". | | | | nearly every application. All the major programming |
| A unique storage-engine architecture data managing | | | | languages including PHP, Java, Perl, Python, .NET, and |
| capabilities with different performance and scaliblity | | | | C etc has MySQL Plug-in libraries to access MySQL |
| features. Some of the popular storage engines are | | | | databases. But MySQL's popularity is closely tied to |
| MyISAM, InnoDB, Memory, NDB. Developers can | | | | PHP,Perl and Python. |