2.17.3 MySQL Source-Configuration Options

The configure script provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the configure command line. For a full list of options supported by configure, run this command:

shell> ./configure --help

You can also affect configure using certain environment variables. See Section 2.21, “Environment Variables”.

The following table shows the available configure options.

Table 2.7 MySQL Source-Configuration Option Reference (configure)

FormatsDescriptionDefaultIntroducedRemoved
--bindir=DIRUser executablesEPREFIX/bin  
--build=BUILDConfigure for building on BUILDguessed  
--cache-file=FILECache test results in FILEdisabled  
-CAlias for `--cache-file=config.cache'  
--config-cache    
--datadir=DIRRead-only architecture-independent dataPREFIX/share  
--disable-FEATUREDo not include FEATURE  
--disable-community-featuresDisable additional features provided by the community5.0.82 
--disable-dependency-trackingDisable dependency tracking  
--disable-grant-optionsDisable GRANT options5.0.34 
--disable-largefileOmit support for large files  
--disable-libtool-lockDisable libtool lock  
--disable-profilingBuild a version without query profiling code5.0.375.0.45
--enable-FEATUREEnable FEATURE  
--enable-assemblerUse assembler versions of some string functions if available  
--enable-dependency-trackingDo not reject slow dependency extractors  
--enable-fast-installOptimize for fast installationyes  
--enable-local-infileEnable LOCAL for LOAD DATA INFILEdisabled  
--enable-sharedBuild shared librariesyes  
--enable-staticBuild static librariesyes  
--enable-thread-safe-clientCompile the client with threads  
--exec-prefix=EPREFIXInstall architecture-dependent files in EPREFIX  
-hDisplay this help and exit  
--help    
--help=shortDisplay options specific to this package   
--help=recursiveDisplay the short help of all the included packages   
--host=HOSTCross-compile to build programs to run on HOST  
--includedir=DIRC header filesPREFIX/include  
--infodir=DIRInfo documentationPREFIX/info  
--libdir=DIRObject code librariesEPREFIX/lib  
--libexecdir=DIRProgram executablesEPREFIX/libexec  
--localstatedir=DIRModifiable single-machine dataPREFIX/var  
--mandir=DIRman documentationPREFIX/man  
-nDo not create output files  
--no-create    
--oldincludedir=DIRC header files for non-gcc/usr/include  
--prefix=PREFIXInstall architecture-independent files in PREFIX  
--program-prefix=PREFIXPrepend PREFIX to installed program names  
--program-suffix=SUFFIXAppend SUFFIX to installed program names  
--program-transform-name=PROGRAMrun sed PROGRAM on installed program names  
-qDo not print `checking...' messages  
--quiet    
--sbindir=DIRSystem administrative executablesEPREFIX/sbin  
--sharedstatedir=DIRModifiable architecture-independent dataPREFIX/com  
--srcdir=DIRFind the sources in DIRconfigure directory or ..  
--sysconfdir=DIRRead-only single-machine dataPREFIX/etc  
--target=TARGETConfigure for building compilers for TARGET  
-VDisplay version information and exit  
--version    
--with-PACKAGEUse PACKAGE  
--with-archive-storage-engineEnable the Archive Storage Engineno  
--with-berkeley-dbUse BerkeleyDB located in DIRno  
--with-berkeley-db-includesFind Berkeley DB headers in DIR  
--with-berkeley-db-libsFind Berkeley DB libraries in DIR  
--with-big-tablesSupport tables with more than 4 G rows even on 32 bit platforms5.0.4 
--with-blackhole-storage-engineEnable the Blackhole Storage Engineno5.0.4 
--with-charsetDefault character set  
--with-client-ldflagsExtra linking arguments for clients  
--with-collationDefault collation  
--with-commentComment about compilation environment  
--with-csv-storage-engineEnable the CSV Storage Engineyes  
--with-darwin-mwccUse Metrowerks CodeWarrior wrappers on OS X/Darwin5.0.6 
--with-embedded-privilege-controlBuild parts to check user's privileges (only affects embedded library)  
--with-embedded-serverBuild the embedded server  
--with-example-storage-engineEnable the Example Storage Engineno  
--with-extra-charsetsUse charsets in addition to default  
--with-gnu-ldAssume the C compiler uses GNU ldno  
--with-isamEnable the ISAM table type 5.0.2
--with-lib-ccflagsExtra CC options for libraries  
--with-libwrap=DIRCompile in libwrap (tcp_wrappers) support  
--with-low-memoryTry to use less memory to compile to avoid memory limitations  
--with-machine-typeSet the machine type, like "powerpc"5.0.44 
--with-max-indexes=NSets the maximum number of indexes per table64  
--with-mit-threadsAlways use included thread lib 5.0.4
--with-mysqld-ldflagsExtra linking arguments for mysqld  
--with-mysqld-libsExtra libraries to link with for mysqld5.0.44 
--with-mysqld-userWhat user the mysqld daemon shall be run as  
--with-mysqlfsInclude the corba-based MySQL file system 5.0.3
--with-mysqlmanagerBuild the mysqlmanager binaryBuild if server is built  
--with-named-curses-libsUse specified curses libraries  
--with-named-thread-libsUse specified thread libraries  
--with-ndb-ccflagsExtra CC options for ndb compile5.0.3 
--with-ndb-docsInclude the NDB Cluster ndbapi and mgmapi documentation  
--with-ndb-portPort for NDB Cluster management server  
--with-ndb-port-basePort for NDB Cluster management server5.0.3 
--with-ndb-sci=DIRProvide MySQL with a custom location of sci library  
--with-ndb-shmInclude the NDB Cluster shared memory transporter 5.0.2
--with-ndb-testInclude the NDB Cluster ndbapi test programs  
--with-ndbclusterInclude the NDB Cluster table handlerno  
--with-openssl=DIRInclude the OpenSSL support  
--with-openssl-includesFind OpenSSL headers in DIR  
--with-openssl-libsFind OpenSSL libraries in DIR  
--with-other-libc=DIRLink against libc and other standard libraries installed in the specified nonstandard location  
--with-picTry to use only PIC/non-PIC objectsUse both  
--with-pstackUse the pstack backtrace library  
--with-pthreadForce use of pthread library  
--with-raidEnable RAID Support 5.0.3
--with-server-suffixAppend value to the version string  
--with-system-typeSet the system type, like "sun-solaris10"5.0.44 
--with-tagsInclude additional configurationsautomatic  
--with-tcp-portWhich port to use for MySQL services3306  
--with-unix-socket-pathWhere to put the unix-domain socket  
--with-vioInclude the Virtual IO support 5.0.2
--with-yasslInclude the yaSSL support5.0.6 
--with-zlib-dir=no|bundled|DIRProvide MySQL with a custom location of compression library  
--without-PACKAGEDo not use PACKAGE  
--without-benchSkip building of the benchmark suite  
--without-debugBuild a production version without debugging code  
--without-docsSkip building of the documentation  
--without-extra-toolsSkip building utilities in the tools directory  
--without-geometryDo not build geometry-related parts  
--without-innodbDo not include the InnoDB table handler 5.0.48
--without-libeditUse system libedit instead of bundled copy  
--without-manSkip building of the man pages  
--without-ndb-debugDisable special ndb debug features5.0.3 
--without-query-cacheDo not build query cache  
--without-readlineUse system readline instead of bundled copy  
--without-serverOnly build the client  
--without-ucaSkip building of the national Unicode collations5.0.3 

Some of the configure options available are described here. For options that may be of use if you have difficulties building MySQL, see Section 2.17.4, “Dealing with Problems Compiling MySQL”.

Many options configure compile-time defaults that can be overridden at server startup. For example, the --prefix, --with-tcp-port, and with-unix-socket-path options that configure the default installation base directory location, TCP/IP port number, and Unix socket file can be changed at server startup with the --basedir, --port, and --socket options for mysqld.