MySQL Review

One of the best open source database for web developers and application enthusiasts

Valuable Features:

The best features in MySQL, making it one of the most used databases globally, are- 1) Multi-threaded architecture for multiple CPU utilization and kernel threading 2) Use of triggers and crash recovery techniques 3) Indexed Conditional Pushdown 4) Integration with LAMP/WAMP 5) Easy setup with Memcached for increasing performance and scalability

Room for Improvement:

Few cons in MySQL are 1) Increased complexity in InnoDB 2) Slower performance when using InnoDB as compared to MyISAM for using simple queries 3) Only identical MyISAM tables can be merged. 4) No active directory integration as in SQL server 5) It does not support check constraints

Other Advice:

MySQL is indeed the world's most popular open source database. It has been designed on the hyper threading infrastructure and supports multi-threaded architecture for using multiple CPU's. It works on index compression with B-Tree disk tables popularly known as MyISAM. Its efficiency depends on the implementation of SQL functions with optimization of library classes.
**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: September 2021.
534,468 professionals have used our research since 2012.
Add a Comment
ITCS user
1 Comment

author avatarit_user2652 (Project Manager at a non-tech company with 10,001+ employees)
Top 20PopularVendor

MySQL is platform independent and can be installed on windows, linux and other OS too. It is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source.