【MySQL 8.x】定制化 MySQL 8.2.0 编译选项（文末彩蛋）

【MySQL 8.x】定制化 MySQL 8.2.0 编译选项（文末彩蛋）

ShawnYan Lv.6
  2023-11-08 00:23:31 2023-11-08 00:23:31 Created   2023-11-08 00:23:31 2023-11-08 00:23:31 Updated      3.3k Words  17 Mins  
mysql-logo.png

前情提要

前文介绍了如何在 Rocky Linux 9.2 上编译 MySQL 8.2.0 DEBUG 版本。但也留有疑问，编译时间过长，可否缩短等待时间。

本文将着重介绍 MySQL 8.2.0 编译过程中一些可定制的编译选项。

MySQL 存储引擎

在 MySQL 编译过程中，除了我们熟知的 MyISAM、InnoDB 引擎，还会默认编译几种存储引擎，分别是：

  • ARCHIVE
  • BLACKHOLE
  • FEDERATED
  • NDBCLUSTER
  • CSV
  • HEAP

下面来逐一介绍。

ARCHIVE

ARCHIVE 存储引擎[1]，意为归档，可用于生成特殊用途的表，这些表以很小的占用空间存储大量未索引的数据。

ARCHIVE 的表只支持写入 (INSERT/REPLACE) 和查询 (SELECT)，不支持修改 (UPDATE) 和删除 (DELETE)。

该引擎不常用，且在 MySQL 8.2 中没有新的变化，预编译时加入参数 (WITH_ARCHIVE_STORAGE_ENGINE=OFF) 可跳过该引擎。

BLACKHOLE

BLACKHOLE 故名思议为“黑洞”，可以接收数据，但并不储存数据。特殊的是，该引擎的表会写二进制日志 (binlog)，所以可以用在中继 (relay) 复制节点。

该引擎不常用，且在 MySQL 8.2 中没有新的变化，预编译时加入参数 (WITH_BLACKHOLE_STORAGE_ENGINE=OFF) 可跳过该引擎。

FEDERATED

简言之，FEDERATED 是 MySQL 里的 “DB Link”，支持从本地访问远程 MySQL 数据库里的表，而本地并不存储数据。

该引擎不常用，且在 MySQL 8.2 中没有新的变化，预编译时加入参数 (WITH_FEDERATED_STORAGE_ENGINE=OFF) 可跳过该引擎。

NDBCLUSTER

NDB 是 Network Database 的缩写，NDB 集群是 shared-nothing 架构，由 SQL 节点，数据节点和 NDB 管理节点组成。

以下引用摘自官方文档：

NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software. [2]

从 MySQL 集群架构来说，推荐使用 InnoDB Cluster，而非 NDB Cluster，所以，在预编译时加入参数 (WITH_NDBCLUSTER_STORAGE_ENGINE=OFF) 跳过该引擎。

CSV

CSV 存储引擎，用于将表数据存储在文本文件中。从 MySQL 5.7.1 开始，改为强制编译。

HEAP (MEMORY)

HEAP 存储引擎[3]，又称 MEMORY 存储引擎。顾名思义，输出存储在内存中，不具备数据持久化功能，所以仅可用于临时表。且不建议用在复制中，可能会造成上下游数据不一致的情况。

但由于该引擎默认编译，故一般情况下，加参数 WITH_HEAP_STORAGE_ENGINE 也无法跳过。

其他引擎

除过以上几种存储引擎之外，还有几种常见的引擎，如 InnoDB, MyISAM, PERFSCHEMA 等，但这都是 MySQL 默认绑定预装的，无法剥离。

MYSQL X 插件

从 MySQL 5.7.12 开始，引入 X plugin，包括 X 协议 和 X 开发API。该插件起到一个接口的作用，提供如 MySQL Shell (mysqlsh) 之类的工具连接 MySQL 服务器。

在 MySQL 5.7 中，需要用如下命令来安装，插件文件默认在 plugin_dir 路径下：

1
INSTALL PLUGIN mysqlx SONAME 'mysqlx.so';

在 MySQL 8.0 中，该插件默认安装。

如果需要卸载该插件，需要使用如下命令：

1
UNINSTALL PLUGIN mysqlx;

编译时，可以通过参数 WITH_MYSQLX 进行控制是否进行编译。

MySQL Router 组件

MySQL Router 是一个代理组件，负责分发来自应用的流量到后端数据库，支持读写、只读流量分发。

MySQL Route 是个轻量级组件，是 InnoDB Cluster 的重要组成。[3:1]

但是，如果不使用 MIC 方案，则可选择 ProxySQL 或 HAProxy 作为代理。

编译时，可以通过参数 WITH_ROUTER 进行控制是否进行编译。

编译过程

经过上述阐述，我们大致了解了 MySQL 常见的存储引擎，针对不同项目的使用情况，我们可以有针对性的使用不同的存储引擎，有些存储引擎如果用不到，就可以不安装，甚至不编译进安装包。

我们知道在 MySQL 的源码里，有很大一部分的代码是测试用例，在完整版的安装包里也会包含测试脚本，但在安装包正式发布前，一定是通过测试的，并且在生产环境中，并不会去运行测试脚本，所以我们可以跳过编译测试用例，以节省时间。

1
2
3
4
5
[root@rocky9 debug]# grep -i MYSQLTEST CMakeCache.txt 
//MYSQLTEST installation directory
INSTALL_MYSQLTESTDIR:STRING=mysql-test
//ADVANCED property for variable: INSTALL_MYSQLTESTDIR
INSTALL_MYSQLTESTDIR-ADVANCED:INTERNAL=1

下面来演示优化后的编译过程。

预编译选项如下：

1
2
3
4
5
6
7
8
cmake .. \
-DCMAKE_BUILD_TYPE=Debug \
-DWITH_BOOST=. \
-DWITH_ARCHIVE_STORAGE_ENGINE=OFF \
-DWITH_BLACKHOLE_STORAGE_ENGINE=OFF \
-DWITH_FEDERATED_STORAGE_ENGINE=OFF \
-DWITH_NDBCLUSTER_STORAGE_ENGINE=OFF \
-DWITH_UNIT_TESTS=OFF

执行编译配置后，可以在生成的缓存文件中进行确认。

1
2
3
4
5
6
7
8
9
10
11
12
13
[shawnyan@rocky9 debug]$ grep -i engine CMakeCache.txt
WITH_ARCHIVE_STORAGE_ENGINE:BOOL=OFF
WITH_BLACKHOLE_STORAGE_ENGINE:BOOL=OFF
WITH_FEDERATED_STORAGE_ENGINE:BOOL=OFF
WITH_NDBCLUSTER_STORAGE_ENGINE:UNINITIALIZED=OFF
WITH_CSV_STORAGE_ENGINE:INTERNAL=ON
WITH_HEAP_STORAGE_ENGINE:INTERNAL=ON
WITH_INNOBASE_STORAGE_ENGINE:INTERNAL=ON
WITH_MYISAMMRG_STORAGE_ENGINE:INTERNAL=ON
WITH_MYISAM_STORAGE_ENGINE:INTERNAL=ON
WITH_PERFSCHEMA_STORAGE_ENGINE:INTERNAL=ON
WITH_TEMPTABLE_STORAGE_ENGINE:INTERNAL=ON
[shawnyan@rocky9 debug]$

下面是咖啡时间 ☕，等待编译完成。。。

编译完成：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
[root@rocky9 debug]# grep Built make.log 
[  1%] Built target INFO_SRC
[  1%] Built target stack_direction
[  1%] Built target abi_check
[  1%] Built target lz4_lib
[  2%] Built target zlib_objlib
[  2%] Built target icustubdata
[  3%] Built target zstd_objlib
[  5%] Built target uca9dump
[  8%] Built target vio_objlib
[  8%] Built target libprotobuf-lite
[ 11%] Built target mytime_objlib
[ 11%] Built target mysql_gtid
[ 14%] Built target all_sys_schema
[ 14%] Built target comp_sql
[ 14%] Built target gen_lex_hash
[ 14%] Built target GenBootstrapPriv
[ 14%] Built target GenFixPrivs
[ 14%] Built target libedit_emacs
[ 14%] Built target libedit_vi
[ 14%] Built target libedit_common
[ 15%] Built target libedit_help
[ 15%] Built target libedit_func
[ 15%] Built target event_pthreads
[ 16%] Built target event_core
[ 18%] Built target build_id_test
[ 18%] Built target icuuc
[ 19%] Built target mysys_objlib
[ 20%] Built target mysqlservices
[ 20%] Built target oci_common_objlib
[ 20%] Built target GenLiteProtos
[ 20%] Built target library_mysys
[ 20%] Built target decimal_objlib
[ 20%] Built target zlib
[ 20%] Built target mysqltest_safe_process
[ 20%] Built target zstd
[ 20%] Built target strings_ja_hans
[ 20%] Built target strings_zh_hans
[ 20%] Built target vio
[ 21%] Built target mytime
[ 22%] Built target sql_commands
[ 22%] Built target GenServerSource
[ 22%] Built target libedit_fcns
[ 23%] Built target event_openssl
[ 23%] Built target event_extra
[ 25%] Built target changestreams_standalone_static
[ 25%] Built target oci_common
[ 25%] Built target decimal
[ 25%] Built target GenSysSchemaC
[ 27%] Built target mysql_binlog_event_standalone
[ 27%] Built target icui18n
[ 27%] Built target GenSysSchema
[ 28%] Built target gen_keyword_list
[ 28%] Built target gen_lex_token
[ 29%] Built target mysqlgcs
[ 29%] Built target GenKeywordList
[ 29%] Built target GenDigestServerSource
[ 31%] Built target edit
[ 31%] Built target strings_objlib
[ 32%] Built target strings
[ 32%] Built target strings_shared
[ 32%] Built target conf_to_src
[ 32%] Built target mysys
[ 32%] Built target comp_err
[ 32%] Built target thr_lock
[ 33%] Built target mf_iocache_test
[ 34%] Built target mysql_ssl_rsa_setup
[ 34%] Built target comp_client_err
[ 34%] Built target my_print_defaults
[ 34%] Built target lz4_decompress
[ 34%] Built target zlib_decompress
[ 34%] Built target GenError
[ 34%] Built target GenClientError
[ 34%] Built target range_check_err
[ 34%] Built target perror
[ 34%] Built target mysql_tzinfo_to_sql
[ 34%] Built target udf_example
[ 34%] Built target locking_service
[ 34%] Built target csv
[ 34%] Built target libprotobuf
[ 37%] Built target heap_library
[ 37%] Built target mysql_binlog_event
[ 38%] Built target myisammrg
[ 38%] Built target ngram_parser
[ 38%] Built target temptable
[ 39%] Built target mysql_native_password
[ 40%] Built target minchassis
[ 40%] Built target myisam_library
[ 40%] Built target installed_headers
[ 41%] Built target archive
[ 42%] Built target clientlib_objlib
[ 43%] Built target blackhole
[ 44%] Built target example
[ 44%] Built target federated
[ 46%] Built target innodb_zipdecompress
[ 46%] Built target myisam_ftdump
[ 46%] Built target myisamchk
[ 46%] Built target mysql_server_component_services
[ 46%] Built target myisamlog
[ 46%] Built target myisampack
[ 46%] Built target test_security_context
[ 46%] Built target audit_null
[ 46%] Built target auth
[ 46%] Built target qa_auth_client
[ 46%] Built target auth_test_plugin
[ 46%] Built target mock
[ 46%] Built target qa_auth_server
[ 46%] Built target qa_auth_interface
[ 46%] Built target mysql_no_login
[ 46%] Built target auth_socket
[ 46%] Built target daemon_example
[ 46%] Built target ddl_rewriter
[ 46%] Built target ftexample
[ 46%] Built target connection_control
[ 46%] Built target clone
[ 46%] Built target keyring_udf
[ 47%] Built target validate_password
[ 47%] Built target pfs_example_plugin_employee
[ 48%] Built target rewrite_example
[ 48%] Built target replication_observers_example
[ 48%] Built target rewriter
[ 48%] Built target keyring_file
[ 48%] Built target semisync_source
[ 48%] Built target semisync_replica
[ 50%] Built target semisync_master
[ 50%] Built target conflicting_variables
[ 51%] Built target semisync_slave
[ 51%] Built target test_sql_replication
[ 51%] Built target test_sql_reset_connection
[ 51%] Built target test_sql_sqlmode
[ 51%] Built target test_sql_lock
[ 51%] Built target test_sql_commit
[ 51%] Built target test_session_attach
[ 51%] Built target test_session_detach
[ 51%] Built target test_sql_stmt
[ 51%] Built target test_sql_complex
[ 51%] Built target test_sql_processlist
[ 51%] Built target test_sql_errors
[ 51%] Built target test_x_sessions_deinit
[ 51%] Built target test_sql_stored_procedures_functions
[ 51%] Built target test_session_info
[ 51%] Built target test_x_sessions_init
[ 51%] Built target test_sql_all_col_types
[ 51%] Built target test_sql_views_triggers
[ 51%] Built target test_sql_2_sessions
[ 51%] Built target test_session_in_thd
[ 51%] Built target test_sql_shutdown
[ 51%] Built target test_sql_sleep_is_connected
[ 51%] Built target test_sql_cmds_1
[ 51%] Built target test_services_host_application_signal
[ 51%] Built target test_services_thread
[ 51%] Built target test_framework
[ 51%] Built target test_services_plugin_registry
[ 52%] Built target test_services
[ 52%] Built target test_services_command_services
[ 52%] Built target test_udf_services
[ 52%] Built target version_token
[ 52%] Built target component_audit_api_message_emit
[ 52%] Built target component_example_component1
[ 52%] Built target component_example_component2
[ 53%] Built target component_example_component3
[ 53%] Built target component_test_string_service_charset
[ 54%] Built target component_test_string_service
[ 54%] Built target component_test_string_service_long
[ 54%] Built target component_test_backup_lock_service
[ 54%] Built target component_log_sink_test
[ 55%] Built target component_log_filter_dragnet
[ 55%] Built target component_log_sink_json
[ 55%] Built target component_log_sink_syseventlog
[ 55%] Built target component_mysqlbackup
[ 55%] Built target component_pfs_example_component_population
[ 55%] Built target component_pfs_example
[ 56%] Built target component_query_attributes
[ 56%] Built target keyring_common_objlib
[ 56%] Built target component_test_event_tracking_consumer
[ 56%] Built target component_reference_cache
[ 57%] Built target component_test_sys_var_service_int
[ 57%] Built target component_test_sys_var_service
[ 57%] Built target component_test_system_variable_source
[ 57%] Built target component_udf_unreg_real_func
[ 57%] Built target component_udf_reg_avg_func
[ 57%] Built target component_udf_reg_int_same_func
[ 57%] Built target component_udf_reg_only_3_func
[ 57%] Built target component_udf_reg_int_func
[ 57%] Built target component_udf_unreg_3_func
[ 57%] Built target component_test_sys_var_service_same
[ 57%] Built target component_udf_reg_3_func
[ 57%] Built target component_test_status_var_service
[ 57%] Built target component_test_status_var_reader
[ 58%] Built target component_udf_reg_real_func
[ 58%] Built target component_test_udf_registration
[ 58%] Built target component_test_sys_var_service_str
[ 58%] Built target component_test_status_var_service_reg_only
[ 58%] Built target component_udf_unreg_int_func
[ 58%] Built target component_test_status_var_service_int
[ 58%] Built target component_test_audit_api_message
[ 58%] Built target component_test_status_var_service_str
[ 58%] Built target component_test_mysql_thd_store_service
[ 58%] Built target component_test_mysql_runtime_error
[ 58%] Built target component_test_mysql_current_thread_reader
[ 58%] Built target component_test_sensitive_system_variables
[ 58%] Built target component_test_status_var_service_unreg_only
[ 58%] Built target component_test_host_application_signal
[ 58%] Built target component_test_component_deinit
[ 58%] Built target component_test_mysql_command_services
[ 59%] Built target component_test_mysql_system_variable_set
[ 59%] Built target component_test_server_telemetry_metrics
[ 59%] Built target component_test_server_telemetry_traces
[ 59%] Built target component_validate_password
[ 61%] Built target mysql_test_event_tracking
[ 61%] Built target component_test_event_tracking_producer_a
[ 61%] Built target component_test_event_tracking_producer_b
[ 61%] Built target component_test_event_tracking_consumer_a
[ 61%] Built target component_test_event_tracking_consumer_b
[ 61%] Built target component_test_event_tracking_consumer_c
[ 61%] Built target mysql_keyring_encryption_test
[ 61%] Built target component_test_pfs_notification
[ 61%] Built target component_test_table_access
[ 61%] Built target component_test_pfs_resource_group
[ 61%] Built target component_test_udf_services
[ 61%] Built target perfschema
[ 61%] Built target ibd2sdi
[ 61%] Built target innochecksum
[ 61%] Built target heap
[ 62%] Built target json_client_library_objlib
[ 62%] Built target clientlib
[ 62%] Built target json_binlog
[ 62%] Built target keyring_common
[ 62%] Built target json_client_library
[ 62%] Built target json_binlog_main
[ 62%] Built target myisam
[ 62%] Built target libmysql
[ 62%] Built target mysqlclient
[ 62%] Built target component_keyring_file
[ 62%] Built target json_binlog_static
[ 62%] Built target mysqlshow
[ 63%] Built target mysqlimport
[ 63%] Built target mysqldump
[ 63%] Built target mysqlcheck
[ 64%] Built target mysqltest
[ 64%] Built target json_client_library_main
[ 64%] Built target mysqladmin
[ 64%] Built target client_base
[ 64%] Built target mysql_secure_installation
[ 64%] Built target mysql_config_editor
[ 64%] Built target json_binlog_main_static
[ 64%] Built target mysqlslap
[ 64%] Built target mysql_migrate_keyring
[ 64%] Built target mysql_client_test
[ 66%] Built target libmysql_api_test
[ 66%] Built target mysql_upgrade
[ 66%] Built target libprotoc
[ 66%] Built target protoc
[ 66%] Built target run_libmysql_api_test
[ 67%] Built target gr_protobuf_lite
[ 67%] Built target mysql
[ 69%] Built target mysqlpump_lib
[ 69%] Built target rpl_protobuf_lite
[ 69%] Built target mysqlbinlog
[ 69%] Built target mysqlxmessages
[ 69%] Built target mysqlpump
[ 69%] Built target mysqlxmessages_lite
[ 69%] Built target xprotocol_plugin
[ 71%] Built target mysqlxclient_lite
[ 71%] Built target mysqlxclient
[ 76%] Built target group_replication
[ 84%] Built target sql_main
[ 84%] Built target rpl_source
[ 89%] Built target sql_dd
[ 90%] Built target rpl_replica
[ 92%] Built target sql_gis
[ 93%] Built target binlog
[ 93%] Built target rpl
[100%] Built target innobase
[100%] Built target mysqld
[100%] Built target INFO_BIN

编译耗时：real 73m, user 231m.

安装数据库，查看安装后的目录。

1
2
3
4
5
6
7
8
9
10
11
[root@rocky9 mysql]# ll
total 292
drwxr-xr-x.  2 root root   4096 Nov 10 00:19 bin
drwxr-xr-x.  2 root root     38 Nov 10 00:19 docs
drwxr-xr-x.  3 root root   4096 Nov 10 00:19 include
drwxr-xr-x.  5 root root    187 Nov 10 00:19 lib
-rw-r--r--.  1 root root 279351 Oct 12 19:40 LICENSE
drwxr-xr-x.  4 root root     30 Nov 10 00:19 man
-rw-r--r--.  1 root root    666 Oct 12 19:40 README
drwxr-xr-x. 28 root root   4096 Nov 10 00:19 share
drwxr-xr-x.  2 root root     77 Nov 10 00:19 support-files

运行数据库。

1
2
3
4
5
6
7
8
[mysql@rocky9 mysql]$ /usr/local/mysql/bin/mysqld
2023-11-09T16:07:52.428069Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2023-11-09T16:07:53.115177Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.2.0-ShawnYan-debug) starting as process 146906
2023-11-09T16:07:53.174965Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-09T16:07:53.963537Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-09T16:07:57.246800Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-09T16:07:57.246958Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-09T16:07:57.584185Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.2.0-ShawnYan-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution.

查看引擎。

1
2
3
4
5
6
7
8
9
10
11
12
mysql> show engines;
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                    | Transactions | XA   | Savepoints |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                      | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                         | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                         | NO           | NO   | NO         |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.01 sec)

查看插件。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
mysql> show plugins;
+---------------------------------+--------+--------------------+---------+---------+
| Name                            | Status | Type               | Library | License |
+---------------------------------+--------+--------------------+---------+---------+
| binlog                          | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| sha256_password                 | ACTIVE | AUTHENTICATION     | NULL    | GPL     |
| caching_sha2_password           | ACTIVE | AUTHENTICATION     | NULL    | GPL     |
| sha2_cache_cleaner              | ACTIVE | AUDIT              | NULL    | GPL     |
| daemon_keyring_proxy_plugin     | ACTIVE | DAEMON             | NULL    | GPL     |
| CSV                             | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| MEMORY                          | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| InnoDB                          | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| INNODB_TRX                      | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_CMP                      | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_CMP_RESET                | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_CMPMEM                   | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_CMPMEM_RESET             | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_CMP_PER_INDEX            | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_CMP_PER_INDEX_RESET      | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_BUFFER_PAGE              | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_BUFFER_PAGE_LRU          | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_BUFFER_POOL_STATS        | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_TEMP_TABLE_INFO          | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_METRICS                  | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_FT_DEFAULT_STOPWORD      | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_FT_DELETED               | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_FT_BEING_DELETED         | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_FT_CONFIG                | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_FT_INDEX_CACHE           | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_FT_INDEX_TABLE           | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_TABLES                   | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_TABLESTATS               | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_INDEXES                  | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_TABLESPACES              | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_COLUMNS                  | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_VIRTUAL                  | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_CACHED_INDEXES           | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| INNODB_SESSION_TEMP_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |
| MyISAM                          | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| MRG_MYISAM                      | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| PERFORMANCE_SCHEMA              | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| TempTable                       | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |
| ngram                           | ACTIVE | FTPARSER           | NULL    | GPL     |
| mysql_native_password           | ACTIVE | AUTHENTICATION     | NULL    | GPL     |
+---------------------------------+--------+--------------------+---------+---------+
40 rows in set (0.01 sec)

彩蛋

之前在 PG 的文章中多次演示过如何在 PG 编译过程加入定制版本号。

例如：【PG16】后 RHEL 7 时代, PG 16 如何在 CentOS 7 上运行

1
2
$ psql
psql (16.0-ShawnYan)

在 MySQL 中，也同样可以加入定制版本信息，只需在编译时加入选项 MYSQL_SERVER_SUFFIX 即可。

实际效果如下：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
[root@rocky9 bin]# ./mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.2.0-ShawnYan-debug Source distribution

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select version();
+----------------------+
| version()            |
+----------------------+
| 8.2.0-ShawnYan-debug |
+----------------------+
1 row in set (0.00 sec)

总结

到此，MySQL 8.2.0 编译选项就先介绍到这里，在实际的测试或者生产环境中，可以依据实际项目需求，来增加、减少存储引擎或插件，当然，ALL IN ONE 也不是不可。

In short，本文介绍了 MySQL 的常见存储引擎，MySQL X 协议，和 Router，并提供了编译选项以供参考。

logo.jpg

  1. https://dev.mysql.com/doc/refman/8.2/en/archive-storage-engine.html ↩︎

  2. https://dev.mysql.com/doc/refman/8.2/en/mysql-cluster-overview.html ↩︎

  3. https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html ↩︎ ↩︎

  • Title: 【MySQL 8.x】定制化 MySQL 8.2.0 编译选项（文末彩蛋）
  • Author: ShawnYan
  • Created at: 2023-11-08 00:23:31
  • Updated at: 2023-11-08 00:23:31
  • Link: https://shawnyan.cn/2023/mysql/mysql-8.2.0-compile-customization/
  • License: This work is licensed under CC BY-NC-SA 4.0.
推荐阅读
三天三夜的三更半夜! StoneDB on Rocky 9 三天三夜的三更半夜! StoneDB on Rocky 9 MySQL 8.4.0 LTS 变更解析：源码编译（类库变更）和密码插件 MySQL 8.4.0 LTS 变更解析：源码编译（类库变更）和密码插件 MySQL 管理运维：root 密码还可以这样改 MySQL 管理运维：root 密码还可以这样改
推荐阅读
三天三夜的三更半夜! StoneDB on Rocky 9 三天三夜的三更半夜! StoneDB on Rocky 9 MySQL 8.4.0 LTS 变更解析：源码编译（类库变更）和密码插件 MySQL 8.4.0 LTS 变更解析：源码编译（类库变更）和密码插件
 Comments
On this page
  1. 前情提要
  2. MySQL 存储引擎
    1. ARCHIVE
    2. BLACKHOLE
    3. FEDERATED
    4. NDBCLUSTER
    5. CSV
    6. HEAP (MEMORY)
    7. 其他引擎
  3. MYSQL X 插件
  4. MySQL Router 组件
  5. 编译过程
  6. 彩蛋
  7. 总结