Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

MySQL 5.5Compiler and installation cmake parameter description

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

-DCMAKE_INSTALL_PREFIX=dir_name Home directory of installation

-DDEFAULT_CHARSET character set, default character set is latin1

-DDEFAULT_COLLATION=collation_name service collation, default is latin1_swedish_ci, you can see which collation matches the character set through the SHOW COLLATION statement

-DENABLED_LOCAL_INFILE Whether LOCAL parameter of LOAD DATA INFILE is turned on

-DWITH_INNOBASE_STORAGE_ENGINE=1 Compile the INNODB storage engine into it

- DWITOUT_FEDERATED_STORAGE_ENGINE=1 Compile the FEDERATED storage engine into it

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 Compile BLACKHOLE storage engine into

- DWITOUT_EXAMPLE_STORAGE_ENGINE=1 Do not compile EXAMPLE storage engine

-DWITH_PARTITION_STORAGE_ENGINE=1 Compile partition storage engine into it

-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 Compile the Performance Schema storage engine into it.

-DCOMPILATION_COMMENT=string Compile Environment Description

-DWITH_READLINE=bool Whether to use readline library

-DSYSCONFDIR=dir_name my.cnf Path to parameter file

-DMYSQL_UNIX_ADDR=file_name Path of Unix socket file, socket file is used for server listening connection, this parameter must be absolute path

-DENABLED_PROFILING=bool Query whether profiling code is turned on (for SHOW PROFILE and SHOW PROFILES statements)

-DMYSQL_DATADIR=dir_name MySQL file directory path, this parameter can also be set with the--datadir parameter when starting MySQL

-DWITH_EXTRA_CHARSETS=name Specifies additional character sets, default is all, contains all character sets.

-DINSTALL_BINDIR=dir_name Path to install user programs, default path is DCMAKE_INSTALL_PREFIX/bin

-DINSTALL_DOCDIR=dir_name Path to installation documentation, default path is DCMAKE_INSTALL_PREFIX/doc

-DINSTALL_INCLUDEDIR=dir_name Path to install header file, default path is DCMAKE_INSTALL_PREFIX/include

-DINSTALL_LIBDIR=dir_name Path to the installation library file, default path is DCMAKE_INSTALL_PREFIX/lib

-DINSTALL_MANDIR=dir_name Path to installation help manual, default path is DCMAKE_INSTALL_PREFIX/man

-DINSTALL_PLUGINDIR=dir_name Path to install plugins, default path is DCMAKE_INSTALL_PREFIX/lib/plugin

-DINSTALL_SBINDIR=dir_name Path to install mysqld server startup script, default path is DCMAKE_INSTALL_PREFIX/bin

-DINSTALL_SCRIPTDIR=dir_name The mysql_install_db script path that initializes the MySQL database's data file path, the default path is DCMAKE_INSTALL_PREFIX/scripts

-DINSTALL_SQLBENCHDIR=dir_name Path to install sql-bench, default path is DCMAKE_INSTALL_PREFIX

-DINSTALL_SUPPORTFILESDIR=dir_name Path to install support files, default path is DCMAKE_INSTALL_PREFIX/support-files

-DMYSQL_TCP_PORT=port_num Port on which the server listens for TCP/IP connections, default is 3306

compile the sample

cmake . -DCMAKE_INSTALL_PREFIX=/software \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DENABLED_LOCAL_INFILE=ON \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \

-DCOMPILATION_COMMENT='production environment' \

-DWITH_READLINE=ON \

-DSYSCONFDIR=/software \

-DMYSQL_UNIX_ADDR=/data/mysql.sock \

-DMYSQL_DATADIR=/data

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report