-static 13% --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static 静态链接提高13%性能 Unix Socket 7.5% --with-unix-socket path=/usr/local/mysql/tmp/mysql.sock 使用unix套接字链接提高7.5%性能,所以在windows下mysql性能肯定不如unix下面 --enable-assembler
The --enable-assembler options of configure allows for
compiling in x86 (and sparc) versions of common string operations, which should result in more performance. 汇编x86的普通操作符,可以提高性能 --with-extra-charsets=complex字符支持
--enable-thread-safe-client #Compile the client with
threads. 也就是让客户端支持线程的意思 --with-big-tables
There is a limit of 232 (~4.295E+09) rows in a MyISAM table. If you build MySQL
with the --with-big-tables option, the
row limitation is increased to (232)2 (1.844E+19) rows--with-ssl
--with-embedded-server #编译成embedded MySQL library (
libmysqld.a ),--enable-local-infile #让mysql支持从本地文件 导入数据库
load data local infile '/usr/test' into table test fields terminated by ' '; ERROR 1148 (42000): The used command is not allowed with this MySQL version) --with-plugins=innobase存储引擎 Mysql5.1开始,编译添加innodb插件就从--with-innodb 改成了 --with-plugins=innobase --with-plugins=PLUGIN[[[,PLUGIN..]]] Plugins to include in mysqld. (default is: none) Must be a configuration name or a comma separated list of plugins. Available configurations are: none max max-no-ndb all. Available plugins are: partition daemon_example ftexample archive blackhole csv example federated heap innobase myisam myisammrg ndbcluster 如果多个插件,可以写成:--with-plugins=partition,blackhole,heap,innobase,myisam,ndbcluster 用逗号分开 |
mysql编译参数详解
原创
©著作权归作者所有:来自51CTO博客作者270175100的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:常用shell命令参数(高级)
下一篇:重定向标准输入,输出以及错误流
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
lsblk命令参数详解
lsblk命令用于列出块设备的信息,包括磁盘、分区和挂载点等。下面是lsblk命令的一些常用用法和示例讲解:
CentOS lsblk命令 Linux -
nginx编译及参数详解
说明:蓝色=命令名称 浅绿=命令参数 浅蓝=选项 紫色=目录 系统环境:CentOS 5.
休闲 nginx nginx编译 nginx参数详解 nginx默认支持模块