Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 17.12 Known Limitations of MySQL Cluster
- 17.12.1 Non-Compliance In SQL Syntax
- 17.12.2 Limits and Differences from Standard MySQL Limits
- 17.12.3 Limits Relating to Transaction Handling
- 17.12.4 Error Handling
- 17.12.5 Limits Associated with Database Objects
- 17.12.6 Unsupported Or Missing Features
- 17.12.7 Limitations Relating to Performance
- 17.12.8 Issues Exclusive to MySQL Cluster
- 17.12.9 Limitations Relating to Multiple Cluster Nodes
- 17.12.10 Previous MySQL Cluster Issues Resolved in MySQL 5.0
A number of features supported by other storage engines are not
supported for NDB tables. Trying to use any of
these features in MySQL Cluster does not cause errors in or of
itself; however, errors may occur in applications that expects the
features to be supported or enforced:
Foreign key constraints. The foreign key construct is ignored, just as it is in
MyISAMtables.OPTIMIZEoperations.OPTIMIZEoperations are not supported.LOAD TABLE ... FROM MASTER.LOAD TABLE ... FROM MASTERis not supported.Savepoints and rollbacks. Savepoints and rollbacks to savepoints are ignored as in
MyISAM.Durability of commits. There are no durable commits on disk. Commits are replicated, but there is no guarantee that logs are flushed to disk on commit.
Replication. Replication is not supported.
Note
See Section 17.12.3, “Limits Relating to Transaction Handling”,
for more information relating to limitations on transaction
handling in NDB.
User Comments
Add your own comment.