MySQL Review

It tends to perform better on Linux and other UNIX-like systems, but it needs support for foreign keys.


Valuable Features:

  • Excellent performance, mainly due to the format of its default table, MyISAM - low disk space, CPU, and memory
  • Flexibility offering multiple variations such as Berkely DB , InnoDB, Heap and MyISAM
  • Reliability. Although the system runs on Windows without flaws, it tends to perform better on Linux and other UNIX-like Systems.
  • Availability
  • Open-Source System, open storage database engine
  • Used by many websites (e.g. LinkedIn, Facebook, Verizon, and PayPal)
  • It's inexpensive when compared to other common databases like Microsoft SQL Server.
  • As a developer myself, I enjoy using it at no cost as long as the associated projects are also open-source.

Room for Improvement:

  • Limited storage capacity
  • Support for foreign keys
  • Stored procedures
  • The biggest disadvantage of MySQL is MyISAM system, which doesn't support well transactions (lack of efficiency)

Use of Solution:

Personally, I've been using it for over 10 years, and professionally for three to four years.

Deployment Issues:

I had no problems deploying it.

Stability Issues:

With each release of MySQL Server was useful for any little problems that users detected, so I would say it's quite stable.

Customer Service:

Previous Solutions:

Initial Setup:

It was straightforward, thanks to the workbench that pulls together nearly every MySQL task, and puts them into one easy and friendly GUI.

Cost and Licensing Advice:

Because MySQL is an open-source , the system is under GNU Licence. The system isn't always free, but it's more affordable. If you intend to sell your software as a proprietary product, you would need to purchase a commercial license, which is quite inexpensive when compared with a Microsoft SQL license.

Other Advice:

From my perspective, MySQL is a product that allows you to be efficient, but the decision goes down to the situation and what you're looking to accomplish.

Which version of this solution are you currently using?

6.3
**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 Computer Software Company
...who compared it with SQL Server
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
523,230 professionals have used our research since 2012.
Add a Comment
ITCS user
Guest
1 Comment

author avatarit_user333624 (Software Developer at a tech services company with 501-1,000 employees)
Consultant

also with the new 5.7 edition added some other fixes , update, firewall , etc. You can check the new version on their page.