-static 13%
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-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
--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的普通操作符,可以提高性能
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 2
32 (~4.295E+09) rows in a
MyISAM
table. If you build MySQL with the
--with-big-tables
option, the row limitation is increased to (2
32 )
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)
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 用逗号分开
--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 用逗号分开
实例:./configure –prefix=/usr/local/webserver/mysql/ --enable-assembler --with-unix-socket-path=/tmp/mysql.sock --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-extra-charsets=gbk,gb2312,utf8 --enable-thread-safe-client --with-big-tables --enable-local-infile --with-ssl
make && make install