What are the limitations of mysql in Comparison of Oracle?

1.MySQL supports six different types of tables, four of which do not support transactions (MyISAM, MERGE, ISAM, and HEAP) and two of which support transactions (InnoDB and BDB). The multiple table types are a result of the initial MySQL design where fast, non-transactional tables were the only option. Because non-transactional tables do not support referential integrity, transactions, and hot backups, no mission-critical application development could utilize these tables.

2.MySQL only supports one index type, but implements different data access paths using the various table types. The eight types of Oracle indexes are B-tree, B-tree Cluster, Hash Cluster, Reverse Key, Bitmap, Bitmap Join, Function-Based, and Domain.