MySQL Server Version Reference  /  Build (Configuration) Options

Chapter 4 Build (Configuration) Options

The following tables details all of the configuration options available when building MySQL server from source. The first table shows the CMake options, which are used in MySQL 5.5.5 and up. The second table shows the configure (GNU autotools) options, which are used prior to MySQL 5.5.5. The tables includes the following columns:

  • Formats: The command line format for the configure option.

  • Description: A short description of the option.

  • Default: The default value.

  • Introduced: The versions in which the option was introduced.

  • Removed: The versions in which the option was removed.

  • 5.0, 5.1, and so forth: Whether the option is available in MySQL 5.0, MySQL 5.1, and so forth. If available, a link to the reference manual where more information can be located will be included.

Table 4.1 Build (CMake) options

Name Description
Default Introduced Removed 5.5 5.6 5.7
BUILD_CONFIG Use same build options as official releases
5.5.7 Yes Yes Yes
CMAKE_BUILD_TYPE Type of build to produce
RelWithDebInfo 5.5.7 Yes Yes Yes
CMAKE_CXX_FLAGS Flags for C++ Compiler
Yes Yes Yes
CMAKE_C_FLAGS Flags for C Compiler
Yes Yes Yes
CMAKE_INSTALL_PREFIX Installation base directory
/usr/local/mysql 5.5.8 Yes Yes Yes
COMPILATION_COMMENT Comment about compilation environment
5.5.7 Yes Yes Yes
CPACK_MONOLITHIC_INSTALL Whether package build produces single file
OFF 5.5.7 Yes Yes Yes
DEFAULT_CHARSET The default server character set
latin1 5.5.7 Yes Yes Yes
DEFAULT_COLLATION The default server collation
latin1_swedish_ci 5.5.7 Yes Yes Yes
DISABLE_PSI_COND Exclude Performance Schema condition instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_FILE Exclude Performance Schema file instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_IDLE Exclude Performance Schema idle instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_MEMORY Exclude Performance Schema memory instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_METADATA Exclude Performance Schema metadata instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_MUTEX Exclude Performance Schema mutex instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_RWLOCK Exclude Performance Schema rwlock instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_SOCKET Exclude Performance Schema socket instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_SP Exclude Performance Schema stored program instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_STAGE Exclude Performance Schema stage instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_STATEMENT Exclude Performance Schema statement instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_STATEMENT_DIGEST Exclude Performance Schema statement_digest instrumentation
OFF 5.7.3 Yes
DISABLE_PSI_TABLE Exclude Performance Schema table instrumentation
OFF 5.7.3 Yes
DOWNLOAD_BOOST Whether to download the Boost library
OFF 5.7.5 Yes
DOWNLOAD_BOOST_TIMEOUT Timeout in seconds for downloading the Boost library
600 5.7.6 Yes
ENABLED_LOCAL_INFILE Whether to enable LOCAL for LOAD DATA INFILE
OFF 5.5.7 Yes Yes Yes
ENABLED_PROFILING Whether to enable query profiling code
ON 5.5.7 Yes Yes Yes
ENABLE_DEBUG_SYNC Whether to enable Debug Sync support
ON 5.5.7 Yes Yes Yes
ENABLE_DOWNLOADS Whether to download optional files
OFF 5.5.7 Yes Yes Yes
ENABLE_DTRACE Whether to include DTrace support
5.5.7 Yes Yes Yes
ENABLE_GCOV Whether to include gcov support
5.5.14, 5.6.3 Yes Yes Yes
ENABLE_GPROF Enable gprof (optimized Linux builds only)
OFF 5.6.6 Yes Yes
FORCE_UNSUPPORTED_COMPILER Whether to permit unsupported compiler
OFF 5.7.5 Yes
IGNORE_AIO_CHECK With -DBUILD_CONFIG=mysql_release, ignore libaio check
OFF 5.5.9, 5.6.1 Yes Yes Yes
INNODB_PAGE_ATOMIC_REF_COUNT Enable or disable atomic page reference counting
ON 5.6.16, 5.7.4 5.7.5 Yes Yes
INSTALL_BINDIR User executables directory
PREFIX/bin 5.5.7 Yes Yes Yes
INSTALL_DOCDIR Documentation directory
PREFIX/docs 5.5.7 Yes Yes Yes
INSTALL_DOCREADMEDIR README file directory
PREFIX 5.5.7 Yes Yes Yes
INSTALL_INCLUDEDIR Header file directory
PREFIX/include 5.5.7 Yes Yes Yes
INSTALL_INFODIR Info file directory
PREFIX/docs 5.5.7 Yes Yes Yes
INSTALL_LAYOUT Select predefined installation layout
STANDALONE 5.5.7 Yes Yes Yes
INSTALL_LIBDIR Library file directory
PREFIX/lib 5.5.7 Yes Yes Yes
INSTALL_MANDIR Manual page directory
PREFIX/man 5.5.7 Yes Yes Yes
INSTALL_MYSQLKEYRINGDIR Directory for keyring_file plugin data file
platform specific 5.7.11 Yes
INSTALL_MYSQLSHAREDIR Shared data directory
PREFIX/share 5.5.7 Yes Yes Yes
INSTALL_MYSQLTESTDIR mysql-test directory
PREFIX/mysql-test 5.5.7 Yes Yes Yes
INSTALL_PKGCONFIGDIR Directory for mysqlclient.pc pkg-config file
INSTALL_LIBDIR/pkgconfig 5.7.9 Yes
INSTALL_PLUGINDIR Plugin directory
PREFIX/lib/plugin 5.5.7 Yes Yes Yes
INSTALL_SBINDIR Server executable directory
PREFIX/bin 5.5.7 Yes Yes Yes
INSTALL_SCRIPTDIR Scripts directory
PREFIX/scripts 5.5.7 Yes Yes Yes
INSTALL_SECURE_FILE_PRIVDIR secure_file_priv default value
platform specific 5.7.6 Yes
INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR secure_file_priv default value for libmysqld
5.7.8 Yes
INSTALL_SHAREDIR aclocal/mysql.m4 installation directory
PREFIX/share 5.5.7 Yes Yes Yes
INSTALL_SQLBENCHDIR sql-bench directory
PREFIX 5.5.7 5.7.8 Yes Yes Yes
INSTALL_SUPPORTFILESDIR Extra support files directory
PREFIX/support-files 5.5.7 Yes Yes Yes
MAX_INDEXES Maximum indexes per table
64 5.7.1 Yes
MEMCACHED_HOME Path to memcached
[none] 5.5.16-ndb-7.2.2 Yes Yes
MUTEX_TYPE InnoDB mutex type
event 5.7.2 Yes
MYSQL_DATADIR Data directory
5.5.7 Yes Yes Yes
MYSQL_MAINTAINER_MODE Whether to enable MySQL maintainer-specific development environment
OFF 5.5.7 Yes Yes Yes
MYSQL_PROJECT_NAME Windows/OS X project name
3306 5.5.21, 5.6.5 Yes Yes Yes
MYSQL_TCP_PORT TCP/IP port number
3306 5.5.7 Yes Yes Yes
MYSQL_UNIX_ADDR Unix socket file
/tmp/mysql.sock 5.5.7 Yes Yes Yes
ODBC_INCLUDES ODBC includes directory
Yes Yes Yes
ODBC_LIB_DIR ODBC library directory
Yes Yes Yes
OPTIMIZER_TRACE Whether to support optimizer tracing
5.6.3 Yes Yes
SUNPRO_CXX_LIBRARY Client link library on Solaris 10+
5.6.20, 5.7.5 Yes Yes
SYSCONFDIR Option file directory
5.5.7 Yes Yes Yes
SYSTEMD_PID_DIR Directory for PID file under systemd
/var/run/mysqld 5.7.6 Yes
SYSTEMD_SERVICE_NAME Name of MySQL service under systemd
mysqld 5.7.6 Yes
TMPDIR tmpdir default value
5.5.36, 5.6.16, 5.7.4 Yes Yes Yes
WIN_DEBUG_NO_INLINE Whether to disable function inlining
OFF 5.7.6 Yes
WITHOUT_SERVER Do not build the server
OFF Yes Yes Yes
WITHOUT_xxx_STORAGE_ENGINE Exclude storage engine xxx from build
5.5.7 Yes Yes Yes
WITH_ASAN Enable AddressSanitizer
OFF 5.5.35, 5.6.15, 5.7.3 Yes Yes Yes
WITH_AUTHENTICATION_PAM Build PAM authentication plugin
OFF Yes
WITH_BOOST The location of the Boost library sources
5.7.5 Yes
WITH_BUNDLED_LIBEVENT Use bundled libevent when building ndbmemcache
ON 5.5.16-ndb-7.2.2 Yes Yes
WITH_BUNDLED_MEMCACHED Use bundled memcached when building ndbmemcache
ON 5.5.16-ndb-7.2.2 Yes Yes
WITH_CLASSPATH Classpath to use when building MySQL Cluster Connector for Java. Default is an empty string.
Yes Yes
WITH_CLIENT_PROTOCOL_TRACING Build client-side protocol tracing framework
ON 5.7.2 Yes
WITH_DEBUG Whether to include debugging support
OFF 5.5.7 Yes Yes Yes
WITH_DEFAULT_COMPILER_OPTIONS Whether to use default compiler options
ON 5.6.6 Yes Yes
WITH_DEFAULT_FEATURE_SET Whether to use default feature set
ON 5.6.6 Yes Yes
WITH_EDITLINE Which libedit/editline library to use
bundled 5.6.12, 5.7.2 Yes Yes
WITH_EMBEDDED_SERVER Whether to build embedded server
OFF 5.5.7 Yes Yes Yes
WITH_EMBEDDED_SHARED_LIBRARY Whether to build a shared embedded server library
OFF 5.5.37, 5.6.17, 5.7.4 Yes Yes Yes
WITH_ERROR_INSERT Enable error injection in the NDB storage engine. Should not be used for building binaries intended for production.
OFF Yes Yes
WITH_EXTRA_CHARSETS Which extra character sets to include
all 5.5.7 Yes Yes Yes
WITH_INNODB_EXTRA_DEBUG Whether to include extra debugging support for InnoDB.
OFF 5.7.2 Yes
WITH_INNODB_MEMCACHED Whether to generate memcached shared libraries.
OFF Yes Yes
WITH_KEYRING_TEST Build the keyring test program
OFF 5.7.11 Yes
WITH_LIBEDIT Use bundled libedit library
ON 5.5.7 5.6.12 Yes Yes
WITH_LIBEVENT Which libevent library to use
bundled 5.6.6 Yes Yes
WITH_LIBWRAP Whether to include libwrap (TCP wrappers) support
OFF 5.5.7 Yes Yes Yes
WITH_MECAB Compiles MeCab
5.7.6 Yes
WITH_MSAN Enable MemorySanitizer
OFF 5.7.4 Yes
WITH_MSCRT_DEBUG Enable Visual Studio CRT memory leak tracing
OFF 5.7.6 Yes
WITH_NDBCLUSTER Build the NDB storage engine; alias for WITH_NDBCLUSTER_STORAGE_ENGINE
ON Yes Yes
WITH_NDBCLUSTER_STORAGE_ENGINE Build the NDB storage engine
ON Yes Yes
WITH_NDBMTD Build multi-threaded data node.
ON Yes Yes
WITH_NDB_BINLOG Enable binary logging by default by mysqld.
ON Yes Yes
WITH_NDB_DEBUG Produce a debug build for testing or troubleshooting.
OFF Yes Yes
WITH_NDB_JAVA Enable building of Java and ClusterJ support. Enabled by default. Supported in MySQL Cluster only.
ON 5.5.27-ndb-7.2.9 Yes Yes
WITH_NDB_PORT Default port used by a management server built with this option. If this option was not used to build it, the management server's default port is 1186.
[none] Yes Yes
WITH_NDB_TEST Include NDB API test programs.
OFF Yes Yes
WITH_READLINE Use bundled readline library
OFF 5.5.7 5.6.5 Yes Yes
WITH_SSL Type of SSL support
bundled 5.5.7 Yes Yes Yes
WITH_SYSTEMD Enable installation of systemd support files
OFF 5.7.6 Yes
WITH_TEST_TRACE_PLUGIN Build test protocol trace plugin
OFF 5.7.2 Yes
WITH_UBSAN Enable Undefined Behavior Sanitizer
OFF 5.7.6 Yes
WITH_UNIXODBC Enable unixODBC support
OFF Yes Yes Yes
WITH_VALGRIND Whether to compile in Valgrind header files
OFF 5.5.6 Yes Yes Yes
WITH_ZLIB Type of zlib support
bundled 5.5.7 Yes Yes Yes
WITH_xxx_STORAGE_ENGINE Compile storage engine xxx statically into server
5.5.7 Yes Yes Yes

Table 4.2 Build (configure) options

Name Description
Default Introduced Removed 5.0 5.1
--bindir User executables
EPREFIX/bin Yes Yes
--build Configure for building on BUILD
guessed Yes Yes
--cache-file Cache test results in FILE
disabled Yes Yes
--config-cache Alias for `--cache-file=config.cache'
Yes Yes
--datadir Read-only architecture-independent data
PREFIX/share Yes Yes
--disable-FEATURE Do not include FEATURE
Yes Yes
--disable-community-features Disable additional features provided by the community
5.0.82, 5.1.28 Yes Yes
--disable-dependency-tracking Disable dependency tracking
Yes Yes
--disable-grant-options Disable GRANT options
5.0.34 Yes Yes
--disable-largefile Omit support for large files
Yes Yes
--disable-libtool-lock Disable libtool lock
Yes Yes
--disable-profiling Build a version without query profiling code
5.0.37 5.0.45 Yes
--disable-thread-safe-client Compile the client without threads
5.1.7 Yes
--enable-FEATURE Enable FEATURE
Yes Yes
--enable-assembler Use assembler versions of some string functions if available
Yes Yes
--enable-debug-sync Compile in Debug Sync facility
5.1.41 Yes
--enable-dependency-tracking Do not reject slow dependency extractors
Yes Yes
--enable-fast-install Optimize for fast installation
yes Yes Yes
--enable-local-infile Enable LOCAL for LOAD DATA INFILE
disabled Yes Yes
--enable-profiling Build a version with query profiling code
5.1.24 Yes
--enable-shared Build shared libraries
yes Yes Yes
--enable-static Build static libraries
yes Yes Yes
--enable-thread-safe-client Compile the client with threads
5.1.6 Yes Yes
--exec-prefix Install architecture-dependent files in EPREFIX
Yes Yes
--help Display help message and exit
Yes Yes
--host Cross-compile to build programs to run on HOST
Yes Yes
--includedir C header files
PREFIX/include Yes Yes
--infodir Info documentation
PREFIX/info Yes Yes
--libdir Object code libraries
EPREFIX/lib Yes Yes
--libexecdir Program executables
EPREFIX/libexec Yes Yes
--localstatedir Modifiable single-machine data
PREFIX/var Yes Yes
--mandir man documentation
PREFIX/man Yes Yes
--no-create Do not create output files
Yes Yes
--oldincludedir C header files for non-gcc
/usr/include Yes Yes
--prefix Install architecture-independent files in PREFIX
Yes Yes
--program-prefix Prepend PREFIX to installed program names
Yes Yes
--program-suffix Append SUFFIX to installed program names
Yes Yes
--program-transform-name run sed PROGRAM on installed program names
Yes Yes
--quiet Do not print `checking...' messages
Yes Yes
--sbindir System administrative executables
EPREFIX/sbin Yes Yes
--sharedstatedir Modifiable architecture-independent data
PREFIX/com Yes Yes
--srcdir Find the sources in DIR
configure directory or .. Yes Yes
--sysconfdir Read-only single-machine data
PREFIX/etc Yes Yes
--target Configure for building compilers for TARGET
Yes Yes
--version Display version information and exit
Yes Yes
--with-PACKAGE Use PACKAGE
Yes Yes
--with-archive-storage-engine Enable the Archive Storage Engine
no 5.1.9 Yes Yes
--with-atomic-ops Implement atomic operations using pthread rwlocks or atomic CPU instructions for multi-processor
5.1.12 Yes
--with-berkeley-db Use BerkeleyDB located in DIR
no 5.1.11 Yes Yes
--with-berkeley-db-includes Find Berkeley DB headers in DIR
5.1.11 Yes Yes
--with-berkeley-db-libs Find Berkeley DB libraries in DIR
5.1.11 Yes Yes
--with-big-tables Support tables with more than 4 G rows even on 32 bit platforms
5.0.4 Yes Yes
--with-blackhole-storage-engine Enable the Blackhole Storage Engine
no 5.0.4 5.1.9 Yes Yes
--with-charset Default character set
Yes Yes
--with-client-ldflags Extra linking arguments for clients
Yes Yes
--with-collation Default collation
Yes Yes
--with-comment Comment about compilation environment
Yes Yes
--with-csv-storage-engine Enable the CSV Storage Engine
yes 5.1.9 Yes Yes
--with-darwin-mwcc Use Metrowerks CodeWarrior wrappers on OS X/Darwin
5.0.6 Yes Yes
--with-debug Add debug code (optionally with memory checker, very slow)
5.1.7 Yes
--with-embedded-privilege-control Build parts to check user's privileges (only affects embedded library)
Yes Yes
--with-embedded-server Build the embedded server
Yes Yes
--with-error-inject Enable error injection in MySQL Server
5.1.11 Yes
--with-example-storage-engine Enable the Example Storage Engine
no 5.1.9 Yes Yes
--with-extra-charsets Use charsets in addition to default
Yes Yes
--with-fast-mutexes Compile with fast mutexes
disabled 5.1.5 Yes
--with-federated-storage-engine Enable federated storage engine
no 5.1.3 5.1.9 Yes
--with-gnu-ld Assume the C compiler uses GNU ld
no Yes Yes
--with-innodb Enable innobase storage engine
no 5.1.3 5.1.9 Yes
--with-isam Enable the ISAM table type
5.0.2 Yes
--with-lib-ccflags Extra CC options for libraries
Yes Yes
--with-libwrap Compile in libwrap (tcp_wrappers) support
Yes Yes
--with-low-memory Try to use less memory to compile to avoid memory limitations
Yes Yes
--with-machine-type Set the machine type, like "powerpc"
5.0.44 Yes Yes
--with-maria-temp-tables Make the temporary tables within MySQL use the Maria storage engine
5.1.24 Yes
--with-max-indexes Sets the maximum number of indexes per table
64 Yes Yes
--with-mit-threads Always use included thread lib
5.0.4 Yes
--with-mysqld-ldflags Extra linking arguments for mysqld
Yes Yes
--with-mysqld-libs Extra libraries to link with for mysqld
5.0.44 Yes Yes
--with-mysqld-user What user the mysqld daemon shall be run as
Yes Yes
--with-mysqlfs Include the corba-based MySQL file system
5.0.3 Yes
--with-mysqlmanager Build the mysqlmanager binary
Build if server is built Yes Yes
--with-named-curses-libs Use specified curses libraries
Yes Yes
--with-named-thread-libs Use specified thread libraries
Yes Yes
--with-ndb-ccflags Extra CC options for ndb compile
5.0.3 Yes Yes
--with-ndb-docs Include the NDB Cluster ndbapi and mgmapi documentation
Yes Yes
--with-ndb-port Port for NDB Cluster management server
Yes Yes
--with-ndb-port-base Port for NDB Cluster management server
5.0.3 Yes Yes
--with-ndb-sci Provide MySQL with a custom location of sci library
Yes Yes
--with-ndb-shm Include the NDB Cluster shared memory transporter
5.0.2 Yes
--with-ndb-test Include the NDB Cluster ndbapi test programs
Yes Yes
--with-ndbcluster Include the NDB Cluster table handler
no 5.1.9 Yes Yes
--with-openssl Include the OpenSSL support
5.1.9 Yes Yes
--with-openssl-includes Find OpenSSL headers in DIR
5.1.9 Yes Yes
--with-openssl-libs Find OpenSSL libraries in DIR
5.1.9 Yes Yes
--with-other-libc Link against libc and other standard libraries installed in the specified nonstandard location
Yes Yes
--with-pic Try to use only PIC/non-PIC objects
Use both Yes Yes
--with-plugin-PLUGIN Forces the named plugin to be linked into mysqld statically
5.1.11 Yes
--with-plugins Plugins to include in mysqld
none 5.1.11 Yes
--with-pstack Use the pstack backtrace library
5.1.54 Yes Yes
--with-pthread Force use of pthread library
Yes Yes
--with-raid Enable RAID Support
5.0.3 Yes
--with-row-based-replication Include row-based replication
5.1.5 5.1.6 Yes
--with-server-suffix Append value to the version string
Yes Yes
--with-ssl Include SSL support
5.1.11 Yes
--with-system-type Set the system type, like "sun-solaris10"
5.0.44 Yes Yes
--with-tags Include additional configurations
automatic Yes Yes
--with-tcp-port Which port to use for MySQL services
3306 Yes Yes
--with-unix-socket-path Where to put the unix-domain socket
Yes Yes
--with-vio Include the Virtual IO support
5.0.2 Yes
--with-yassl Include the yaSSL support
5.0.6 5.1.9 Yes Yes
--with-zlib-dir Provide MySQL with a custom location of compression library
Yes Yes
--without-PACKAGE Do not use PACKAGE
Yes Yes
--without-bench Skip building of the benchmark suite
5.1.11 Yes Yes
--without-debug Build a production version without debugging code
5.1.6 Yes Yes
--without-docs Skip building of the documentation
Yes Yes
--without-extra-tools Skip building utilities in the tools directory
5.1.9 Yes Yes
--without-geometry Do not build geometry-related parts
Yes Yes
--without-innodb Do not include the InnoDB table handler
5.0.48 Yes
--without-libedit Use system libedit instead of bundled copy
Yes Yes
--without-man Skip building of the man pages
Yes Yes
--without-ndb-binlog Disable ndb binlog
5.1.6 Yes
--without-ndb-debug Disable special ndb debug features
5.0.3 Yes Yes
--without-plugin-PLUGIN Exclude PLUGIN
5.1.11 Yes
--without-query-cache Do not build query cache
Yes Yes
--without-readline Use system readline instead of bundled copy
Yes Yes
--without-row-based-replication Don't include row-based replication
5.1.7 5.1.14 Yes
--without-server Only build the client
Yes Yes
--without-uca Skip building of the national Unicode collations
5.0.3 Yes Yes


PREV   HOME   UP