-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 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支持从本地文件 导入数据库
![]() ![]()
--with-plugins=innobase存储引擎
![]() ![]() --with-plugins=PLUGIN[[[,PLUGIN..]]] ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
转载于:https://blog.51cto.com/wangmukun/236149