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 source or a replica (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.
libmysqld
does not support encrypted connections. An implication is that if an application linked againstlibmysqld
establishes a connection to a remote server, the connection cannot be encrypted.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
event_scheduler
system variable is disabled.The Performance Schema is not available.
Some of these limitations can be changed by editing the
mysql_embed.h
include file and recompiling
MySQL.