查看mysql编译参数: cat /usr/local/mysql/bin/mysqlbug | grep CONFIGURE_LINE 查看apache编译参数: cat $apachehome$/build/config.nice 查看php编译参数: $PHP$/bin/php -i | grep configure 本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u3/90603/showart_1991998.html
by cenalulu - MySQL文档中心 - 2009-07-10 15:08:23 阅读(1219) 回复(0)
CC=icc \ CXX=icpc \ CFLAGS=" -O3 -ip -static -static-intel -no-gcc -no-prec-div -mp -unroll2 -xT" \ CXXFLAGS="-O3 -ip -static -static-intel -no-gcc -no-prec-div -mp -unroll2 -xT" \ LDFLAGS='-static -static-intel' \ LD=xild \ AR=xiar \ ./configure \ --prefix=/usr/local/mysql \ --with-server-suffix='-chinavisual-icc10-compiled' \ --with-pic \ --enable-assembler \ --enable-local-infile \ --...
本帖最后由 cenalulu 于 2012-06-28 10:17 编辑 怎么查看编译mysql时使用了那些参数? 就是./configure 后面的那些东西。 在我编译、安装完mysql后怎么去查看。
关键字: mysql compile 1. -static 13% --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static 静态链接提高13%性能 2. -pgcc 1% CFLAGS="-O3 -mpentiumpro -mstack-align-double" CXX=gcc \ CXXFLAGS="-O3 -mpentiumpro -mstack-align-double \ -felide-constructors -fno-exceptions -fno-rtti" 如果是Inter处理器,使用pgcc提高1%性能 3. Unix Socket 7.5% --with-unix-socket-pat...
1. -static 13% --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static 静态链接提高13%性能 2. -pgcc 1% CFLAGS="-O3 -mpentiumpro -mstack-align-double" CXX=gcc \ CXXFLAGS="-O3 -mpentiumpro -mstack-align-double \ -felide-constructors -fno-exceptions -fno-rtti" 如果是Inter处理器,使用pgcc提高1%性能 3. Unix Socket 7.5% --with-unix-socket-path=/usr/local/mysql/tmp/...
/configure --prefix=/home/mine/mysql --enable-assembler \ --with-mysqld-ldflags=-all-static --localstatedir=/home/mine/mysql/data \ --with-unix-socket-path=/tmp/mysql.sock --enable-assembler \ --with-charset=complex --with-low-memory --with-mit-threads 请高手帮我解释下!!谢谢
用mysql进入client console, 输入show variables like 'character\_set\_%'; 显示如下结果 mysql> show variables like 'character\_set\_%'; +--------------------------+--------+ | Variable_name | Value | +--------------------------+--------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | |...