content_image/862931.jpg
• -DODBC_LIB_DIR= dir_name 

The location of the ODBC library directory, and may be used while configuring Connector/ODBC. 

• -DSYSCONFDIR= dir_name 

The default my.cnf  option file directory. 

This location cannot be set at server startup, but you can start the server with a given option file using the --defaults-file= file_name  option, where file_name  is the full path name to the file. 

• -DSYSTEMD_PID_DIR= dir_name 

The name of the directory in which to create the PID file when MySQL is managed by systemd. The default is /var/run/mysqld ; this might be changed implicitly according to the INSTALL_LAYOUT value. 

This option is ignored unless WITH_SYSTEMD  is enabled. 

• -DSYSTEMD_SERVICE_NAME= name 

The name of the MySQL service to use when MySQL is managed by systemd. The default is mysqld ; this might be changed implicitly according to the INSTALL_LAYOUT  value. 

This option is ignored unless WITH_SYSTEMD  is enabled. 

• -DTMPDIR= dir_name 

The default location to use for the tmpdir  system variable. If unspecified, the value defaults to P_tmpdir  in <stdio.h> . 

## Storage Engine Options 

Storage engines are built as plugins. You can build a plugin as a static module (compiled into the server) or a dynamic module (built as a dynamic library that must be installed into the server using the INSTALL PLUGIN  statement or the --plugin-load  option before it can be used). Some plugins might not support static or dynamic building. 

The InnoDB , MyISAM , MERGE , MEMORY , and CSV  engines are mandatory (always compiled into the server) and need not be installed explicitly. 

To compile a storage engine statically into the server, use -DWITH_ engine _STORAGE_ENGINE=1 . Some permissible engine  values are ARCHIVE , BLACKHOLE , EXAMPLE , FEDERATED , and NDB  or NDBCLUSTER ( NDB  support). Examples: 

-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 

<img src='content_image/862931.jpg'>

## Note 

It is not possible to compile without Performance Schema support. If it is desired to compile without particular types of instrumentation, that can be done with the following CMake  options: 

DISABLE_PSI_COND DISABLE_PSI_DATA_LOCK DISABLE_PSI_ERROR DISABLE_PSI_FILE 

