MySQL
MySQL Introduction and Features
What is MySQL?
A database is a structured collection of data. It may be text, number, images etc. As a developer, we need to manage the database to store , access and modify.
Mysql is the database management system. MySQL (My Sequel) is the world’s most used open source relational database management system (RDBMS) and it is a popular choice of database for use in web applications. It is developed, distributed, supported by ORACLE. MySQL is used to store, access and modify the data. MySQL is a central component of the LAMP () open source web application software. Explaination for LAMP is “L-Linux, A- Apache, Mysql, Perl/ PHP/ Python”. MySQL user interface is very easy and flexible to design and maintenance the data. MySQL software delivers a very fast, multi-threaded, multi-user and robust SQL(Structured Query Language) database server.
MySql RDBMS:
A relational database stores data in separate tables rather than putting all the data in one big storeroom. The database structures are organized into files. The data speed is very fast, When we retrive the data from files. The logical model with objects are database, tables, views, rows, and columns. This logical structured gives the flexible programming environment. The rules between tables are one-to-one, one-to-many, unique, required or optional. When you apply perfect rules for database, The database is very flexible or easy to maintain.
MySql Open Source:
Open Source means that it is possible for anyone to use and modify the software.MySQL, Anybody can download and use it without paying. You can change this source code.
MySql Limits:
MySql support for large database. We use MySql server with database that contain 50 million records Example. 200,000 tables, 5,000,000,000 rows. MySql support for upto 64 indexes per table (32 indexes for MySql 4.1.2).
MySql Connectivity Languages:
MySql programs can written in many languages. The languages are C, C++, Eiffel, Java, .NET, Perl, PHP, Python, Ruby, Tcl.
MySql License:
MySQL is dual licensed. Users can choose to use the MySQL software as an Open Source product (GNU General public license http://www.fsf.org/licenses/) or users have to purchase a standard commercial license from ORACLE (http://www.mysql.com/company/legal/licensing).
MySql Features And Versions:
| Feature | MySQL Series |
| Unions | 4.0 |
| Subqueies | 4.1 |
| R-trees | 4.1 (My ISAM Storage Engine) |
| Stored Procedures and Functions | 5.0 |
| Views | 5.0 |
| Cursors | 5.0 |
| XA Transactions | 5.0 |
| Triggers | 5.0 and 5.1 |
| Event Scheduler | 5.1 |
| Partitioning | 5.1 |
| Pluggable Storage engine API | 5.1 |
| Plugin API | 5.1 |
| Row Based Replication | 5.1 |
| Server log tables | 5.1 |
| Scalability and performance improvements | 5.1(with InnoDB Plugin) |
| DTrace support | 5.5 |
| Semisynchronous replication | 5.5 |
| Signal / Resignal support in stored routines | 5.5 |
| Performance Schema | 5.5 |
| Supplementary Unicode characters | 5.5 |
