The embedded server has the following limitations:
No user-defined functions (UDFs).
No stack trace on core dump.
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.
The Event Scheduler is not available. Because of this, the
variable is disabled.
The embedded server cannot share the same
with another server. As of MySQL 5.7.8, the default value for
this directory can be set at build time with the
Some of these limitations can be changed by editing the
mysql_embed.h include file and recompiling