MySQL Review

A fast and reliable database management system


Valuable Features:

• It is inexpensive as compared to other common databases like Microsoft SQL Server or Oracle. • MySQL is an extensible, open storage database engine that integrates seamlessly with a number of programming languages and other web-based technologies. • MYSQL is an open source system under the GNU General Public License. Developers can use it at no cost as long as the associated projects are also open-source. • Having excellent performance, MYSQL is used by many internet powerhouses like yahoo as their back-end database. MYSQL has great performance due to format of its default table, MyISAM. MyISAM databases use little disk space, memory and cpu. The system runs without flaw and perform better on all platforms including windows, Unix and Linux.

Room for Improvement:

• MySQL has a limited storage capacity. It doesn’t support large databases. • Database transactions are not handled efficiently. • Unlike Oracle, MySQL doesn't have Tablespace, Role management, snapshots, synonym and packages. • For transferring data, MySQL doesn’t support other languages being executed from within the system, and neither does it supports XML. • Compared to Oracle, MySQL database does not support any feature like Audit Vault on its server • There is a limited scope and earning available for database administrator of MySQL.

Other Advice:

MySQL is an open source database management system and is used by most of the most famous networking sites. It is more popular in websites and PHP integration. It can be executed under a number of operating systems like Linux, UNIX, Mac OS and Windows. MySQL supports ODBC interface which allows MySQL to be addressed by all the usual programming languages that run under Microsoft Windows.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More MySQL reviews from users
...who work at a University
...who compared it with Oracle Database
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2020.
454,950 professionals have used our research since 2012.
Add a Comment
Guest
3 Comments

author avatarit_user1068 (Tech Support Staff at a tech company with 1,001-5,000 employees)
Vendor

In case one does not need a lot storage capacity and need to run a simple database, MySQL is the ultimate choice. Great Information for someone seeking to know when MySQL might not meet their needs and expectations.

author avatarit_user6414 (CEO at a tech services company with 501-1,000 employees)
Consultant

I marvel at the robustness at which MySQL manages large database yet supporting many operating systems. While lack of a well developed studio is a concern, I also prefer using it over others. Francis I like the fact that you also appreciate free source software like MySQL.

author avatarit_user6579 (Engineer at a tech services company with 1,001-5,000 employees)
Consultant

Nice detailed explanation regarding advantages and disadvantages of MySQL. I agree with author on various points like popular free opensource database. But it doesn't support PL fully.