mysql-5.1 编译参数优化

-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 用逗号分开
 
实例：

./configure –prefix=/usr/local/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