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.

1 Comment

kapilmalik1983ConsultantTOP REVIEWER

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.

27 July 13
Guest
Why do you like it?

Sign Up with Email