Explain Features of MySQL???

o    Relational Database Management System (RDBMS): MySQL is a relational database management system.

o    Easy to use: MySQL is easy to use. You have to get only the basic knowledge of SQL. You can build and interact with MySQL with only a few simple SQL statements.

o    It is secure: MySQL consist of a solid data security layer that protects sensitive data from intruders. Passwords are encrypted in MySQL.

o    Client/ Server Architecture: MySQL follows a client /server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc.

o    Free to download: MySQL is free to use and you can download it from MySQL official website.

o    It is scalable: MySQL can handle almost any amount of data, up to as much as 50 million rows or more. The default file size limit is about 4 GB. However, you can increase this number to a theoretical limit of 8 TB of data.

o    Compatibale on many operating systems: MySQL is compatible to run on many operating systems, like Novell NetWare, Windows* Linux*, many varieties of UNIX* (such as Sun* Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others. MySQL also provides a facility that the clients can run on the same computer as the server or on another computer (communication via a local network or the Internet).

o    Allows roll-back: MySQL allows transactions to be rolled back, commit and crash recovery.

o    High Performance: MySQL is faster, more reliable and cheaper because of its unique storage engine architecture.

o    High Flexibility: MySQL supports a large number of embedded applications which makes MySQL very flexible.

o    High Productivity: MySQL uses Triggers, Stored procedures and views which allows the developer to give a higher productivity.

Disadvantages / Drawback of MySQL:

Following are the few disadvantages of MySQL:

o    MySQL version less than 5.0 doesn't support ROLE, COMMIT and stored procedure.

o    MySQL does not support a very large database size as efficiently.

o    MySQL doesn't handle transactions very efficiently and it is prone to data corruption.

o    MySQL is accused that it doesn't have a good developing and debugging tool compared to paid databases.

o    MySQL doesn't support SQL check constraints.