The embedded server has the following limitations:
No support for
ISAM tables. (This is done
mainly to make the library smaller.)
No user-defined functions (UDFs).
No stack trace on core dump.
No internal RAID support. (This is not normally needed as most current operating systems support big files.)
You cannot set this up as a master or a slave (no replication).
Very large result sets may be unusable on low memory systems.
You cannot connect to an embedded server from an outside process with sockets or TCP/IP. However, you can connect to an intermediate application, which in turn can connect to an embedded server on the behalf of a remote client or outside process.
InnoDB is not reentrant in the embedded
server and cannot be used for multiple connections, either
successively or simultaneously.
Some of these limitations can be changed by editing the
mysql_embed.h include file and recompiling