The following table details all of the configure
options available when building MySQL server from source. The table
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 (configure) options
Format | Description | ||||||
---|---|---|---|---|---|---|---|
Default | Introduced | Removed | 5.0 | 5.1 | 5.4 | 5.5 | |
--bindir=DIR | User executables | ||||||
EPREFIX/bin | yes | yes | yes | ||||
--build=BUILD | Configure for building on BUILD | ||||||
guessed | yes | yes | yes | ||||
--cache-file=FILE | Cache test results in FILE | ||||||
disabled | yes | yes | yes | ||||
-C | Alias for `--cache-file=config.cache' | ||||||
yes | yes | yes | |||||
--config-cache | Alias for `--cache-file=config.cache' | ||||||
yes | yes | yes | |||||
--datadir=DIR | Read-only architecture-independent data | ||||||
PREFIX/share | yes | yes | yes | ||||
--disable-FEATURE | Do not include FEATURE | ||||||
yes | yes | yes | |||||
--disable-dependency-tracking | Disable dependency tracking | ||||||
yes | yes | yes | |||||
--disable-grant-options | Disable GRANT options | ||||||
5.0.34 | yes | yes | yes | ||||
--disable-largefile | Omit support for large files | ||||||
yes | yes | yes | |||||
--disable-libtool-lock | Disable libtool lock | ||||||
yes | 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 | yes | |||||
--enable-FEATURE | Enable FEATURE | ||||||
yes | yes | yes | |||||
--enable-assembler | Use assembler versions of some string functions if available | ||||||
yes | yes | yes | |||||
--enable-debug-sync | Compile in Debug Sync facility | ||||||
6.0.6, 5.1.41 | yes | yes | |||||
--enable-dependency-tracking | Do not reject slow dependency extractors | ||||||
yes | yes | yes | |||||
--enable-dtrace | Compile in DTrace support | ||||||
6.0.4 | yes | yes | |||||
--enable-fast-install | Optimize for fast installation | ||||||
yes | yes | yes | yes | ||||
--enable-local-infile | Enable LOAD DATA LOCAL INFILE | ||||||
disabled | yes | yes | yes | ||||
--enable-shared | Build shared libraries | ||||||
yes | yes | yes | yes | ||||
--enable-static | Build static libraries | ||||||
yes | yes | yes | yes | ||||
--enable-thread-safe-client | Compile the client with threads | ||||||
5.1.6 | yes | yes | |||||
--exec-prefix=EPREFIX | Install architecture-dependent files in EPREFIX | ||||||
yes | yes | yes | |||||
-h | Display this help and exit | ||||||
yes | yes | yes | |||||
--help | Display this help and exit | ||||||
yes | yes | yes | |||||
--help=short | Display options specific to this package | ||||||
yes | yes | yes | |||||
--help=recursive | Display the short help of all the included packages | ||||||
yes | yes | yes | |||||
--host=HOST | Cross-compile to build programs to run on HOST | ||||||
yes | yes | yes | |||||
--includedir=DIR | C header files | ||||||
PREFIX/include | yes | yes | yes | ||||
--infodir=DIR | Info documentation | ||||||
PREFIX/info | yes | yes | yes | ||||
--libdir=DIR | Object code libraries | ||||||
EPREFIX/lib | yes | yes | yes | ||||
--libexecdir=DIR | Program executables | ||||||
EPREFIX/libexec | yes | yes | yes | ||||
--localstatedir=DIR | Modifiable single-machine data | ||||||
PREFIX/var | yes | yes | yes | ||||
--mandir=DIR | man documentation | ||||||
PREFIX/man | yes | yes | yes | ||||
-n | Do not create output files | ||||||
yes | yes | yes | |||||
--no-create | Do not create output files | ||||||
yes | yes | yes | |||||
--oldincludedir=DIR | C header files for non-gcc | ||||||
/usr/include | yes | yes | yes | ||||
--prefix=PREFIX | Install architecture-independent files in PREFIX | ||||||
yes | yes | yes | |||||
--program-prefix=PREFIX | Prepend PREFIX to installed program names | ||||||
yes | yes | yes | |||||
--program-suffix=SUFFIX | Append SUFFIX to installed program names | ||||||
yes | yes | yes | |||||
--program-transform-name=PROGRAM | run sed PROGRAM on installed program names | ||||||
yes | yes | yes | |||||
-q | Do not print `checking...' messages | ||||||
yes | yes | yes | |||||
--quiet | Do not print `checking...' messages | ||||||
yes | yes | yes | |||||
--sbindir=DIR | System admin executables | ||||||
EPREFIX/sbin | yes | yes | yes | ||||
--sharedstatedir=DIR | Modifiable architecture-independent data | ||||||
PREFIX/com | yes | yes | yes | ||||
--srcdir=DIR | Find the sources in DIR | ||||||
configure directory or .. | yes | yes | yes | ||||
--sysconfdir=DIR | Read-only single-machine data | ||||||
PREFIX/etc | yes | yes | yes | ||||
--target=TARGET | Configure for building compilers for TARGET | ||||||
yes | yes | yes | |||||
-V | Display version information and exit | ||||||
yes | yes | yes | |||||
--version | Display version information and exit | ||||||
yes | yes | yes | |||||
--with-PACKAGE | Use PACKAGE | ||||||
yes | 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 | 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 | yes | ||||
--with-blackhole-storage-engine | Enable the Blackhole Storage Engine | ||||||
no | 5.0.4 | 5.1.9 | yes | yes | yes | ||
--with-charset | Default character set | ||||||
yes | yes | yes | |||||
--with-client-ldflags | Extra linking arguments for clients | ||||||
yes | yes | yes | |||||
--with-collation | Default collation | ||||||
yes | yes | yes | |||||
--with-comment | Comment about compilation environment | ||||||
yes | 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 | yes | ||||
--with-debug | Add debug code | ||||||
5.1.7 | yes | yes | |||||
--with-debug=full | Add debug code (adds memory checker, very slow) | ||||||
5.1.7 | yes | yes | |||||
--with-embedded-privilege-control | Build parts to check user's privileges (only affects embedded library) | ||||||
yes | yes | yes | |||||
--with-embedded-server | Build the embedded server | ||||||
yes | yes | yes | |||||
--with-error-inject | Enable error injection in MySQL Server | ||||||
5.1.11 | yes | 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 | yes | |||||
--with-fast-mutexes | Compile with fast mutexes | ||||||
enabled | 5.1.5 | yes | 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 | 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 | yes | |||||
--with-libevent | Include libevent for thread-pool support | ||||||
6.0.4 | |||||||
--with-libwrap=DIR | Compile in libwrap (tcp_wrappers) support | ||||||
yes | yes | yes | |||||
--with-low-memory | Try to use less memory to compile to avoid memory limitations | ||||||
yes | yes | yes | |||||
--with-machine-type | Set the machine type, like "powerpc" | ||||||
5.0.44 | yes | yes | yes | ||||
--with-maria-temp-tables | Make the temporary tables within MySQL use the Maria storage engine | ||||||
6.0.6, 5.1.24-maria | |||||||
--with-max-indexes=N | Sets the maximum number of indexes per table | ||||||
64 | yes | yes | yes | ||||
--with-mit-threads | Always use included thread lib | ||||||
5.0.3 | yes | ||||||
--with-mysqld-ldflags | Extra linking arguments for mysqld | ||||||
yes | yes | yes | |||||
--with-mysqld-libs | Extra libraries to link with for mysqld | ||||||
5.0.44 | yes | yes | yes | ||||
--with-mysqld-user | What user the mysqld daemon shall be run as | ||||||
yes | 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 | yes | |||||
--with-named-thread-libs | Use specified thread libraries | ||||||
yes | yes | yes | |||||
--with-ndb-ccflags | Extra CC options for ndb compile | ||||||
5.0.3 | yes | 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=DIR | 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=DIR | 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=DIR | Link against libc and other standard libraries installed in the specified nonstandard location | ||||||
yes | yes | yes | |||||
--with-pic | Try to use only PIC/non-PIC objects | ||||||
Use both | yes | yes | yes | ||||
--with-plugin-PLUGIN | Forces the named plugin to be linked into mysqld statically | ||||||
5.1.11 | yes | yes | |||||
--with-plugins | Plugins to include in mysqld | ||||||
none | 5.1.11 | yes | yes | ||||
--with-pstack | Use the pstack backtrace library | ||||||
yes | yes | yes | |||||
--with-pthread | Force use of pthread library | ||||||
yes | 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 | yes | |||||
--with-ssl=DIR | Include SSL support | ||||||
5.1.11 | yes | yes | |||||
--with-system-type | Set the system type, like "sun-solaris10" | ||||||
5.0.44 | yes | yes | yes | ||||
--with-tags | Include additional configurations | ||||||
automatic | yes | yes | yes | ||||
--with-tcp-port | Which port to use for MySQL services | ||||||
3306 | yes | yes | yes | ||||
--with-unix-socket-path | Where to put the unix-domain socket | ||||||
yes | 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=no|bundled|DIR | Provide MySQL with a custom location of compression library | ||||||
yes | yes | yes | |||||
--without-PACKAGE | Do not use PACKAGE | ||||||
yes | 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 | yes | ||||
--without-docs | Skip building of the documentation | ||||||
yes | 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 | yes | |||||
--without-innodb | Do not include the InnoDB table handler | ||||||
5.0.48 | yes | ||||||
--without-libedit | Use system libedit instead of bundled copy | ||||||
5.1.9 | yes | yes | |||||
--without-libevent | Do not include libevent for thread-pool support | ||||||
6.0.4 | |||||||
--without-man | Skip building of the man pages | ||||||
yes | 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 | yes | ||||
--without-plugin-PLUGIN | Exclude PLUGIN | ||||||
5.1.11 | yes | yes | |||||
--without-query-cache | Do not build query cache | ||||||
yes | yes | yes | |||||
--without-readline | Use system readline instead of bundled copy | ||||||
yes | 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 | yes | |||||
--without-uca | Skip building of the national Unicode collations | ||||||
5.0.3 | yes | yes | yes |