mysql編譯參數查看（mysql設置參數查詢sql語句）

• 1、怎麼查看編譯mysql時使用了那些參數
• 2、如何查看apache，php，mysql的編譯參數
• 3、怎麼查mysql5.5，用cmake安裝時的編譯參數
• 4、如何查看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會有更專業的人來為您解答。如果我的回答沒能幫助您，請繼續追問。

查看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

# cd /usr/local/mysql5.5/docs

# vim INFO_BIN （其中 Pointer size: 4 一行之後的內容就是所要的參數，需要注意的是，這裡的參數的書寫格式並不是在執行 cmake 命令時參數的標準格式 ，使用的時候要去掉 :BOOL或 PATH: 等字元）

===== Information about the build process: =====

Build was run at 2014-09-13 23:14:29 on host ‘rhel5-8-1.breeze.com’

Build was done on Linux-2.6.18-308.el5 using i686

Build was done using cmake 3.0.2

===== Compiler flags used (from the ‘sql/’ subdirectory): =====

# compile C with /usr/bin/cc

# compile CXX with /usr/bin/c++

C_DEFINES = -DHAVE_CONFIG_H -DHAVE_EVENT_SCHEDULER -DMYSQL_SERVER

CXX_DEFINES = -DHAVE_CONFIG_H -DHAVE_EVENT_SCHEDULER -DMYSQL_SERVER

Pointer size: 4

===== Feature flags used: =====

— Cache values

CMAKE_BUILD_TYPE:STRING=RelWithDebInfo

CMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql5.5

COMMUNITY_BUILD:BOOL=ON

如何查看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