nginx mysqlnd驅動引擎提升mysql性能

nginx mysqlnd驅動引擎提升mysql性能

前期要安裝 mysql mysqli pdo_mysql libiconv

1 先去PHP官網下個 php-5.6.29.tar.gz wget http://cn2.php.net/distributions/php-5.6.29.tar.gz

2 <pre>

./configure --prefix=/usr/local/php --with-iconv=/usr/local/libiconv --enable-sysvsem --with-curl --enable-mbregex --enable-mbstring --with-mcrypt --with-gd --with-openssl --with-mhash --enable-sockets --with-xmlrpc --with-zlib --enable-fpm --with-config-file-path=/usr/local/php/etc --with-mysql=mysqlnd --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd

</pre>

如果報錯

make: *** [ext/fileinfo/libmagic/apprentice.lo] Error 1

這是由于記憶體小于1G所導緻.

在./configure加上選項:

<pre>

--disable-fileinfo

Disable fileinfo support 禁用 fileinfo

接下來 make && make install

編譯成功記得重新開機php-fpm

/usr/local/php/sbin/php-fpm -y /usr/local/php/etc/php-fpm.conf -c /usr/local/php/etc/php.ini

phpinfo()可以看到如下資訊

mysql mysqli pdo_mysql

Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a

說明成功了