Skip navigation links
MySQL 5.5 Reference Manual :: 21 Connectors and APIs :: 21.8 libmysqld, the Embedded MySQL Server Library :: 21.8.2 Restrictions When Using the Embedded MySQL Server
21.8.3 Options with the Embedded Server »
Section Navigation      [Toggle]

21.8.2. Restrictions When Using the Embedded MySQL Server

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 event_scheduler system variable is disabled.

Some of these limitations can be changed by editing the mysql_embed.h include file and recompiling MySQL.