MySQL Features


MySQL Features
the open source MySQL Community Server and the proprietary Enterprise Server.MySQL Enterprise Server is differentiated by a series of proprietary extensions which install as server plugins, but otherwise shares the version numbering system and is built from the same code base.

A broad subset of ANSI SQL 99, as well as extensions
Cross-platform support
Stored procedures, using a procedural language that closely adheres to SQL/PSM[71]
Triggers
Cursors
Updatable views
Online DDL when using the InnoDB Storage Engine.
Information schema
Performance Schema that collects and aggregates statistics about server execution and query performance for monitoring purposes.[72]
A set of SQL Mode options to control runtime behavior, including a strict mode to better adhere to SQL standards.
X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using the default InnoDB storage engine
Transactions with savepoints when using the default InnoDB Storage Engine. The NDB Cluster Storage Engine also supports transactions.
ACID compliance when using InnoDB and NDB Cluster Storage Engines
SSL support
Query caching
Sub-SELECTs (i.e. nested SELECTs)
Built-in Replication support (i.e. Master-Master Replication & Master-Slave Replication) with one master per slave, many slaves per master.Multi-master replication is provided in MySQL Cluster and multi-master support can be added to unclustered configurations using Galera Cluster.
Full-text indexing and searching
Embedded database library
Unicode support
Partitioned tables with pruning of partitions in optimizer
Shared-nothing clustering through MySQL Cluster
Multiple storage engines, allowing one to choose the one that is most effective for each table in the application.
Native storage engines InnoDB, MyISAM, Merge, Memory (heap), Federated, Archive, CSV, Blackhole, NDB Cluster.
Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.

Advertisements

MySQL Versions


MySQL Versions

77cd3da8ce9e485eb5ef01e1bd369c61

MySQL 5.6.24 (Apr 08, 2015)
MySQL 5.6.17 (Mar 28, 2014)
MySQL 5.6.15 (Dec 03, 2013)
MySQL 5.6.13 (Jul 31, 2013)
MySQL 5.6.12 (Jun 04, 2013)
MySQL 5.6.11 (Apr 19, 2013)
MySQL 5.5.29 (Dec 21, 2012)
MySQL 5.5.28 (Sep 29, 2012)
MySQL 5.5.27 (Aug 09, 2012)
MySQL 5.5.24 (May 09, 2012)
MySQL 5.5.23 (Apr 16, 2012)
MySQL 5.5.22 (Mar 26, 2012)
MySQL 5.5.21 (Feb 21, 2012)
MySQL 5.5.20 (Jan 13, 2012)
MySQL 5.5.19 (Dec 08, 2011)
MySQL 5.5.16 (Sep 16, 2011)
MySQL 5.5.14 (Jul 06, 2011)
MySQL 5.5.11 (Apr 05, 2011)
MySQL 5.5.9 (Feb 08, 2011)
MySQL 5.5.8 (Dec 17, 2010)

MySQL History


MySQL History
MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael “Monty” Widenius. The first version of MySQL appeared on 23 May 1995. It was initially created for personal usage from mSQL based on the low-level language ISAM, which the creators considered too slow and inflexible. They created a new SQL interface, while keeping the same API as mSQL. By keeping the API consistent with the mSQL system, many developers were able to use MySQL instead of the (proprietarily licensed) mSQL antecedent.

ukoug-2011-mysql-architectures-for-oracle-dbas-6-728

MySQL Overview


MySQL Overview
MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyzer. MySQL works on many system platforms, including AIX, BSDi, FreeBSD, HP-UX, eComStation, i5/OS, IRIX, Linux, OS X, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos and Tru64. A port of MySQL to OpenVMS also exists.

mysql-aquarium-paris-3-728

The MySQL server software itself and the client libraries use dual-licensing distribution. They are offered under GPL version 2,beginning from 28 June 2000(which in 2009 has been extended with a FLOSS License Exception)[26] or to use a proprietary license.

Support can be obtained from the official manual.Free support additionally is available in different IRC channels and forums. Oracle offers paid support via its MySQL Enterprise products. They differ in the scope of services and in price. Additionally, a number of third party organisations exist to provide support and services.

What is MySQL


What is MySQL
MySQL (officially pronounced as /maɪ ˌɛskjuːˈɛl/ “My S-Q-L”) is an open-source relational database management system (RDBMS);in July 2013, it was the world’s second most[a] widely used RDBMS, and the most widely used open-source client–server model RDBMS.It is named after co-founder Michael Widenius’s daughter, The SQL acronym stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements.

database

MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.For proprietary use, several paid editions are available, and offer additional functionality.
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other “AMP” stacks). LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python.” Free-software-open source projects that require a full-featured database management system often use MySQL. Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software.MySQL is also used in many high-profile, large-scale.