MySQL Source-Configuration Options • -DODBC_LIB_DIR= dir_name • -DSYSCONFDIR= dir_name • -DSYSTEMD_PID_DIR= dir_name • -DSYSTEMD_SERVICE_NAME= name • -DTMPDIR= dir_name 228 Note Storage Engine Options The location of the ODBC library directory, and may be used while configuring Connector/ODBC. 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. 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. 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. The default location to use for the  tmpdir  system variable. If unspecified, the value defaults to P_tmpdir  in  <stdio.h> . 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: 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: -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 DISABLE_PSI_COND DISABLE_PSI_DATA_LOCK DISABLE_PSI_ERROR DISABLE_PSI_FILE