- 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.
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
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.
I had no problems deploying it.
With each release of MySQL Server was useful for any little problems that users detected, so I would say it's quite stable.
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.
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.