mysql55查看编译的参数

1. 某个软件需要编译安装的，如何查看其编译安装的一些选项参数

方法如下：链培进入安装该软件的原代码目录，察如运行make uninstall。如果不行，也可以查看一下Makefile文件，主要是看install部分，从其中找出tar格式败唤启的文件被复制到了什么路径，然后进入相应的目录进行删除即可

2. 怎样用mysql命令行查看show_queries参数我用show status like 'show%';却提示'empty set'

亲，应该是slow_queries??你试试show status like '%queries%'

3. squid 怎么查看编译时用的参数

squid 2.5 中，编译的时候加入如下参陵氏数
--enable-underscore

允许解析的URL中出现下划渣汪游线，因为默认squid会认为带下划线的URL地址是非法的，并拒绝访问该地址。对于 2.6 版本，编译时没有这个参数，这个参数出现在 squid.conf 的配置文档里，说明是这样的：

TAG: allow_underscore
# Underscore characters is not strictly allowed in Internet hostnames
# but nevertheless used by many sites. Set this to off if you want
# Squid to be strict about the standard.
# This check is performed only when check_hostnames is set to on.
#
#Default:
# allow_underscore on
如销默认是 on 所以编译时不用再加--enable-underscore

4. 用命令行方式操作mysql数据库，为什么会出现错误。Mysql服务已启动，服务器名称为MySQL55

这个错误是无法连接到Mysql数据库，使用mysql命令进行登陆的参数为：

-h主机地址，如：localhost或者127.0.0.1

-u用户名，如：root

-p登陆密码，如果你有设置mysql密码就填

参数与值之间不需要空格，但是不同参数间有空格，

格式如：>mysql-hlocalhost-uroot-pa12346

mysql命令大全参考：http://wenku..com/view/e5f0ab07e87101f69e3195b0.html

如图：

5. 如何动态修改Mysql的配置参数

登入mysql：
mysql -h localhost -u root -p
然后会让输入密码

查看当前配置参数（wait_timeout为例）：
show session variables like '%wait_timeout%'; （或去掉session也一样）这是当前会话配置参数

现在我们来改这个值：
set wait_timeout=90;
然后我们一起再查看下当前配置参数：
show variables like '%wait_timeout%';

这是修改当前会话配置，当退出再新起一个会话时就会恢复原样。

想在所有会话都有效可以设置全局配置，参数把session改为global就可以了
set global wait_timeout=90;后再查看
show global variables like '%wait_timeout%';

再退出后重新进入看看，值还是在。

6. MySQL cmake编译时这些参数是什么意思

MySQL cMake 常规参数介绍

-DCMAKE_INSTALL_PREFIX= 指向mysql安装目录
-DINSTALL_SBINDIR=sbin 指向可执行文件目录（prefix/sbin）
-DMYSQL_DATADIR=/var/lib/mysql 指向mysql数据文件目录（/var/lib/mysql）
-DSYSCONFDIR=/etc/mysql 指向mysql配置文件目录（/etc/mysql）
-DINSTALL_PLUGINDIR=lib/mysql/plugin 指向插件目录（prefix/lib/mysql/plugin）
-DINSTALL_MANDIR=share/man 指向man文档目录（prefix/share/man）
-DINSTALL_SHAREDIR=share 指向aclocal/mysql.m4安装目录（prefix/share）
-DINSTALL_LIBDIR=lib/mysql 指向对象代码库目录（prefix/lib/mysql）
-DINSTALL_INCLUDEDIR=include/mysql 指向头文件目录（prefix/include/mysql）
-DINSTALL_INFODIR=share/info 指向info文档存放目录（prefix/share/info）
prefix官方推荐设为/usr
类型csv,myisam,myisammrg,heap,innobase,archive,blackhole
若想启用某个引擎的支持：-DWITH_<ENGINE>_STORAGE_ENGINE=1
如：
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
若想禁用某个引擎的支持：-DWITHOUT_<ENGINE>_STORAGE_ENGINE=1
如：
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1
-DWITHOUT_FEDERATED_STORAGE_ENGINE=1
-DWITHOUT_PARTITION_STORAGE_ENGINE=1
-DWITH_READLINE=1 启用readline库支持（提供可编辑的命令行）
-DWITH_SSL=system 启用ssl库支持（安全套接层）
-DWITH_ZLIB=system 启用libz库支持（zib、gzib相关）
-DWTIH_LIBWRAP=0 禁用libwrap库（实现了通用TCP包装的功能，为网络服务守护进程使用）
-DMYSQL_TCP_PORT=3306 指定TCP端口为3306
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock 指定mysql.sock路径
-DENABLED_LOCAL_INFILE=1 启用本地数据导入支持
-DEXTRA_CHARSETS=all 启用额外的字符集类型（默认为all）
-DDEFAULT_CHARSET=utf8 指定默认的字符集为utf8
-DDEFAULT_COLLATION=utf8_general_ci 设定默认排序规则（utf8_general_ci快速/utf8_unicode_ci准确）
-DWITH_EMBEDDED_SERVER=1 编译嵌入式服务器支持
-DMYSQL_USER=mysql 指定mysql用户(默认为mysql)
-DWITH_DEBUG=0 禁用debug（默认为禁用）
-DENABLE_PROFILING=0 禁用Profiling分析（默认为开启）
-DWITH_COMMENT='string' 一个关于编译环境的描述性注释

7. 如何在makefile中增加mysql编译参数

用QT Creator生成的文件进行编译时出现错误，网上查找说是要修改生成的Makefile文件，在CFLAGS和CXXFLAGS中添加“-fno-rtti”编译参数。这样每个Makefile文件都要修改，很麻烦。那么能不能在生成Makefile时自动加上呢。可以，只需要修改qmake的配置即可！

以下为解决方法（也可供同类问题参考）：

1、#sudo gedit Makefile 查看生成的Makefile。在其中找到Makefile: mycom.pro /QT4/builddir/sdk/qtopiacore/target/mkspecs/qws/linux-arm-g++/qmake.conf 。

这就是要修改的配置文件

2、#sudo gedit /QT4/builddir/sdk/qtopiacore/target/mkspecs/qws/linux-arm-g++/qmake.conf

找到要修改的项并修改QMAKE_CFLAGS = -fno-rtti -pipe，QMAKE_CXXFLAGS = $$QMAKE_CFLAGS（说明引用QMAKE_CFLAGS）

那么这就完成修改。保存退出即可。

8. 如何查看mysql可用编译参数

如何查看mysql可用编译参数
查看nginx编译参数：/usr/local/nginx/sbin/nginx -V查看apache编译参数：cat /usr/local/apache2/build/config.nice查看mysql编译参数：cat /usr/local/mysql/bin/mysqlbug | grep CONFIGURE_LINE查看php编译参数：/usr/local/php/bin/php -i | grep configure

9. windows怎么查看mysql 编译

准备工作：
安装一个编译器，推荐Microsoft visual studio 2008吧
另外需要装:

开始编译：
这里以mysql-5.1.38的源码编译为例：
mysql-5.1.38的代码下载可以到mysql官方网站下载，具体怎么下载不在说明。

打开一个cmd窗口：
输入：
cscript //H:CScript
然后：
cd /path/mysql-5.1.38
win\configure WITH_INNOBASE_STORAGE_ENGINE __NT__
win\build-vs9.bat

到此我们将会创建一个mysql.sln的工程文件，如果对想学习代码的朋友，到此即可以，然后可以用Microsoft visual studio 2008打开这个文件就可以查看相应的代码了。

如果需要调试或单步执行调试：
这里以mysqld项目为例：
打开项目mysqld 的属性点击debugging
在mysqld的属性页设置命令参数（Command Arguments)为：–console。这样就可以用debug方式调试代码了。

同样对于其它项目的调试，也是这样处理，属性，添加命令行参数：–console。

对于想跟踪的项目可以执行build，然后可以在mysql-5.1.38/client/Debug下生成相应的执行文件。

10. 如何查看Apache的configure编译参数

`configure’ configures this package to adapt to many kinds of systems.
`configure’ 配置这个包来适合多数系统.
Usage: ./configure [OPTION]… [VAR=VALUE]…誉弯
语法: ./configure [选项]… [变量=值]…
To assign environment variables (e.g., CC, CFLAGS…), specify them as VAR=VALUE. See below for descriptions of some of the useful variables.
配置环境变昌虚迟量(例如,CC,CFLAGS),格式为VAR=VALUE. 看下面对这些可用变量的说明.
Defaults for the options are specified in brackets.
选项的默认值括在方括号之中.
Configuration:
配置:
-h, –help display this help and exit 显示这个帮助并退出
–help=short display options specific to this package 显示这个包的详细选项
–help=recursive display the short help of all the included packages 显示所有包括的包的帮助信息
-V, –version display version information and exit 显示版本信息并退出
-q, –quiet, –silent do not print `checking…’ messages 不打印’检查’信息
–cache-file=FILE cache test results in FILE [disabled] 存储测试信息到文件中 [disabled]
-C, –config-cache alias for `–cache-file=config.cache’ `–cache-file=config.cache’的别名
-n, –no-create do not create output files 不生成输出文件
–srcdir=DIR find the sources in DIR [configure dir or `..'] 在DIR查找代码

Installation directories:
安装目录:
–prefix=PREFIX install architecture-independent files in PREFIX 安装路径
[/usr/local/apache2]
–exec-prefix=EPREFIX install architecture-dependent files in EPREFIX 执行文件安装路径
[PREFIX]

By default, `make install’ will install all the files in `/usr/local/apache2/bin’, `/usr/local/apache2/lib’ etc. You can specify an installation prefix other than `/usr/local/apache2′ using `–prefix’,for instance `–prefix=$HOME’.
默认情况下,’make install’安装所有的文件在 `/usr/local/apache2/bin’, `/usr/local/apache2/lib’ 等等.你可以指定一个安装前缀 ‘–prefix’选项来改变耐李安装位置，例如 `–prefix=$HOME’.

For better control, use the options below.
更详细的配置,使用下面的选项.
Fine tuning of the installation directories:
调整安装目录的选项:
–bindir=DIR user executables [EPREFIX/bin]
–sbindir=DIR system admin executables [EPREFIX/sbin]
–libexecdir=DIR program executables [EPREFIX/libexec]
–sysconfdir=DIR read-only single-machine data [PREFIX/etc]
–sharedstatedir=DIR modifiable architecture-independent data [PREFIX/com]
–localstatedir=DIR modifiable single-machine data [PREFIX/var]
–libdir=DIR object code libraries [EPREFIX/lib]
–includedir=DIR C header files [PREFIX/include]
–oldincludedir=DIR C header files for non-gcc [/usr/include]
–datarootdir=DIR read-only arch.-independent data root [PREFIX/share]
–datadir=DIR read-only architecture-independent data [DATAROOTDIR]
–infodir=DIR info documentation [DATAROOTDIR/info]
–localedir=DIR locale-dependent data [DATAROOTDIR/locale]
–mandir=DIR man documentation [DATAROOTDIR/man]
–docdir=DIR documentation root [DATAROOTDIR/doc/PACKAGE]
–htmldir=DIR html documentation [DOCDIR]
–dvidir=DIR dvi documentation [DOCDIR]
–pdfdir=DIR pdf documentation [DOCDIR]
–psdir=DIR ps documentation [DOCDIR]

System types:
系统类型:
–build=BUILD configure for building on BUILD [guessed]
–host=HOST cross-compile to build programs to run on HOST [BUILD]
–target=TARGET configure for building compilers for TARGET [HOST]

Optional Features:
可选的功能:
–disable-FEATURE do not include FEATURE (same as –enable-FEATURE=no)
–enable-FEATURE[=ARG] include FEATURE [ARG=yes]
–enable-layout=LAYOUT
–enable-v4-mapped Allow IPv6 sockets to handle IPv4 connections
–enable-exception-hook Enable fatal exception hook
–enable-maintainer-mode
Turn on debugging and compile time warnings
–enable-pie Build httpd as a Position Independent Executable
–enable-moles=MODULE-LIST
Space-separated list of moles to enable | “all” |
“most”
–enable-mods-shared=MODULE-LIST
Space-separated list of shared moles to enable |
“all” | “most”
–disable-authn-file file-based authentication control
–enable-authn-dbm DBM-based authentication control
–enable-authn-anon anonymous user authentication control
–enable-authn-dbd SQL-based authentication control
–disable-authn-default authentication backstopper
–enable-authn-alias auth provider alias
–disable-authz-host host-based authorization control
–disable-authz-groupfile
‘require group’ authorization control
–disable-authz-user ‘require user’ authorization control
–enable-authz-dbm DBM-based authorization control
–enable-authz-owner ‘require file-owner’ authorization control
–enable-authnz-ldap LDAP based authentication
–disable-authz-default authorization control backstopper
–disable-auth-basic basic authentication
–enable-auth-digest RFC2617 Digest authentication
–enable-isapi isapi extension support
–enable-file-cache File cache
–enable-cache dynamic file caching
–enable-disk-cache disk caching mole
–enable-mem-cache memory caching mole
–enable-dbd Apache DBD Framework
–enable-bucketeer buckets manipulation filter
–enable-mpio I/O mp filter
–enable-echo ECHO server
–enable-example example and demo mole
–enable-case-filter example uppercase conversion filter
–enable-case-filter-in example uppercase conversion input filter
–enable-ext-filter external filter mole
–disable-include Server Side Includes
–disable-filter Smart Filtering
–disable-charset-lite character set translation
–enable-charset-lite character set translation
–enable-deflate Deflate transfer encoding support
–enable-ldap LDAP caching and connection pooling services
–disable-log-config logging configuration
–enable-log-forensic forensic logging
–enable-logio input and output logging
–disable-env clearing/setting of ENV vars
–enable-mime-magic automagically determining MIME type
–enable-cern-meta CERN-type meta files
–enable-expires Expires header control
–enable-headers HTTP header control
–enable-ident RFC 1413 identity check
–enable-usertrack user-session tracking
–enable-unique-id per-request unique ids
–disable-setenvif basing ENV vars on headers
–enable-version determining httpd version in config files
–enable-proxy Apache proxy mole
–enable-proxy-connect Apache proxy CONNECT mole
–enable-proxy-ftp Apache proxy FTP mole
–enable-proxy-http Apache proxy HTTP mole
–enable-proxy-ajp Apache proxy AJP mole
–enable-proxy-balancer Apache proxy BALANCER mole
–enable-ssl SSL/TLS support (mod_ssl)
–enable-distcache Select distcache support in mod_ssl
–enable-optional-hook-export
example optional hook exporter
–enable-optional-hook-import
example optional hook importer
–enable-optional-fn-import
example optional function importer
–enable-optional-fn-export
example optional function exporter
–enable-static-support Build a statically linked version of the support
binaries
–enable-static-htpasswd
Build a statically linked version of htpasswd
–enable-static-htdigest
Build a statically linked version of htdigest
–enable-static-rotatelogs
Build a statically linked version of rotatelogs
–enable-static-logresolve
Build a statically linked version of logresolve
–enable-static-htdbm Build a statically linked version of htdbm
–enable-static-ab Build a statically linked version of ab
–enable-static-checkgid
Build a statically linked version of checkgid
–enable-static-htcacheclean
Build a statically linked version of htcacheclean
–enable-static-httxt2dbm
Build a statically linked version of httxt2dbm
–enable-http HTTP protocol handling
–disable-mime mapping of file-extension to MIME
–enable-dav WebDAV protocol handling
–disable-status process/thread monitoring
–disable-autoindex directory listing
–disable-asis as-is filetypes
–enable-info server information
–enable-suexec set uid and gid for spawned processes
–disable-cgid CGI scripts
–enable-cgi CGI scripts
–disable-cgi CGI scripts
–enable-cgid CGI scripts
–enable-dav-fs DAV provider for the filesystem
–enable-dav-lock DAV provider for generic locking
–enable-vhost-alias mass virtual hosting mole
–disable-negotiation content negotiation
–disable-dir directory request handling
–enable-imagemap server-side imagemaps
–disable-actions Action triggering on requests
–enable-speling correct common URL misspellings
–disable-userdir mapping of requests to user-specific directories
–disable-alias mapping of requests to different filesystem parts
–enable-rewrite rule based URL manipulation
–enable-so DSO capability

Some influential environment variables:
一些有影响的环境变量:
CC C compiler command
CFLAGS C compiler flags
LDFLAGS linker flags, e.g. -L<lib dir> if you have libraries in a
nonstandard directory <lib dir>
CPPFLAGS C/C++/Objective C preprocessor flags, e.g. -I<include dir> if
you have headers in a nonstandard directory <include dir>
CPP C preprocessor