Javatpoint Logo

91-9990449935

 0120-4256464

JavaTpoint

MySQL Features

  • Relational Database Management System (RDBMS): MySQL is a relational database management system.
  • 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.
  • It is secure: MySQL consist of a solid data security layer that protects sensitive data from intruders. Passwords are encrypted in MySQL.
  • 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.
  • Free to download: MySQL is free to use and you can download it from MySQL official website.
  • 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.
  • 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).
  • Allows roll-back: MySQL allows transactions to be rolled back, commit and crash recovery.
  • High Performance: MySQL is faster, more reliable and cheaper because of its unique storage engine architecture.
  • High Flexibility: MySQL supports a large number of embedded applications which makes MySQL very flexible.
  • 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:

  • MySQL version less than 5.0 doesn't support ROLE, COMMIT and stored procedure.
  • MySQL does not support a very large database size as efficiently.
  • MySQL doesn't handle transactions very efficiently and it is prone to data corruption.
  • MySQL is accused that it doesn't have a good developing and debugging tool compared to paid databases.
  • MySQL doesn't support SQL check constraints.
Next TopicMySQL Data Types