现在的位置: 首页 > IT运维 > 正文

MySQL编译参数详解

2011年01月14日 IT运维 ⁄ 共 1441字 暂无评论 ⁄ 被围观 9+
  • -static 13%, 静态链接提高13%性能
    [php]--with-client-ldflags=-all-static
    --with-mysqld-ldflags=-all-static[/php]
  • Unix Socket 7.5%, 使用unix套接字链接提高7.5%性能,所以在windows下mysql性能肯定不如unix下面
    [php]--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock[/php]
  • --enable-assembler, 汇编x86的普通操作符,可以提高性能
    [php]The --enable-assembler options of configure allows for
    compiling in x86 (and sparc) versions of common string
    operations, which should result in more performance.[/php]

  • --with-extra-charsets=complex字符支持
    [php]--enable-thread-safe-client #Compile the client with threads. 也就是让客户端支持线程的意思[/php]
  • --with-big-tables
    [php]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[/php]
  • --with-ssl
  • --with-embedded-server #编译成embedded MySQL library (libmysqld.a),
  • --enable-local-infile #让mysql支持从本地文件 导入数据库
    [php]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)[/php]
  • --with-plugins=innobase存储引擎

    Mysql5.1开始,编译添加innodb插件就从--with-innodb 改成了 --with-plugins=innobase

  • --with-plugins=PLUGIN[[[,PLUGIN..]]], 如果多个插件,可以写成:--with-plugins=partition,blackhole,heap,innobase,myisam,ndbcluster 用逗号分开
    [php] 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[/php]

给我留言

您必须 [ 登录 ] 才能发表留言!

×
#