Centos7--lnmp+jemalloc优化nginx与mysql
1：基础环境准备1
2
3
4
5
6
# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
# uname -r
3.10.0-327.18.2.el7.x86_64
# getenforce
Disabled
2：编译安装Nginx 2.1 准备工作
1
2
3
# useradd -u 7005 -s /sbin/nologin -M nginx
# yum install wget gcc gcc-c++ autoconf automake bzip2-y
# yum install zlib zlib-devel pcre pcre-devel openssl openssl-devel -y
2.2 下载需要的软件包
1
2
3
4
5
6
# mkdir source
# cd source/
# wgetftp://ftp.csx.cam.ac.uk/pub/software/programming/pcre/pcre-8.38.tar.bz2
# wgethttp://zlib.net/zlib-1.2.8.tar.gz
# wget http://nginx.org/download/nginx-1.10.0.tar.gz
# wgethttps://github.com/jemalloc/jemalloc/releases/download/4.2.0/jemalloc-4.2.0.tar.bz2
2.3 安装jemalloc优化nginx，mysql
1
2
3
4
5
6
7
# tar -xf jemalloc-4.2.0.tar.bz2 -C /usr/local/src/
# cd !$
cd /usr/local/src/
# cd jemalloc-4.2.0/
# ./configure && make && make install
# echo '/usr/local/lib' > /etc/ld.so.conf.d/local.conf
# ldconfig
2.4 编译安装Nginx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
# tar -xf zlib-1.2.8.tar.gz -C /usr/local/src/
# tar -xf pcre-8.38.tar.bz2 -C /usr/local/src/
# tar -xf nginx-1.10.0.tar.gz -C /usr/local/src/
# cd /usr/local/src/nginx-1.10.0/
# vim auto/cc/gcc
178 # debug #取消debug模式
179 #CFLAGS="$CFLAGS -g"
# ./configure --prefix=/usr/local/nginx --with-http_ssl_module --with-http_dav_module --with-http_stub_status_module --with-http_addition_module --with-http_sub_module --with-http_gzip_static_module --with-zlib=/usr/local/src/zlib-1.2.8 --with-pcre=/usr/local/src/pcre-8.38--pid-path=/usr/local/nginx/nginx.pid--with-ld-opt="-ljemalloc" --with-http_flv_module --user=nginx --group=nginx
# make -j 4 && make install
# /usr/local/nginx/sbin/nginx
# lsof -i :80
COMMAND PIDUSER FD TYPE DEVICE SIZE/OFF NODE NAME
nginx 11712root 7uIPv427174 0t0TCP *:http (LISTEN)
nginx 11713 nginx 7uIPv427174 0t0TCP *:http (LISTEN)
3：编译安装MySQL5.7.12
3.1 准备工作
1
2
3
# useradd -u 7003 -s /sbin/nologin -M mysql
# mkdir -p /data/mysql
#yum -y install gcc gcc-c++ ncurses ncurses-devel wget bzip2 openssl openssl-devel cmake bison
3.2 下载软件包
1
2
# wget http://120.52.73.44/nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
# wget http://fossies.org/linux/misc/mysql-5.7.12.tar.gz
3.3 安装zlib
1
2
3
# cd /usr/local/src/zlib-1.2.8/
# ./configure --prefix=/usr/local/zlib
# make && make install
3.4 安装boost boost使用1.6的没成功，自行尝试
1
2
# mkdir /usr/local/boost
# cp boost_1_59_0.tar.gz /usr/local/boost/
3.5 安装mysql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
# tar -xf mysql-5.7.12.tar.gz -C /usr/local/src
# cd !$/mysql-5.7.12
cd /usr/local/src/mysql-5.7.12
# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
> -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
> -DMYSQL_DATADIR=/data/mysql/ \
> -DSYSCon\=/etc \
> -DMYSQL_TCP_PORT=3306 \
> -DWITH_INNOBASE_STORAGE_ENGINE=1 \
> -DWITH_PARTITION_STORAGE_ENGINE=1 \
> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
> -DWITH_MYISAM_STORAGE_ENGINE=1 \
> -DENABLED_LOCAL_INFILE=1 \
> -DWITH_DEBUG=0 \
> -DDEFAULT_CHARSET=utf8 \
> -DDEFAULT_COLLATION=utf8_general_ci \
> -DWITH_EXTRA_CHARSETS=all \
> -DMYSQL_MAINTAINER_MODE=0 \
> -DWITH_EDITLINE=bundled \
> -DWITH_SSL:STRING=bundled \
> -DWITH_ZLIB:STRING=bundled \
> -DZLIB_LIBRARY:FILEPATH=/usr/local/zlib/lib/ \
> -DZLIB_INCLUDE_DIR:PATH=/usr/local/zlib/include/ \
> -DCMAKE_EXE_LINKER_FLAGS="-ljemalloc" \
> -DENABLE_DOWNLOADS=1 \
> -DWITH_BOOST=/usr/local/boost
# make -j 8
# make install
3.6 初始化MySQL
1
2
3
4
5
6
7
8
9
10
11
12
# chown -R mysql.mysql /usr/local/mysql/
# chown -R mysql.mysql /data/
# echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile
# source !$
source /etc/profile
# mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/
2016-05-19T20:14:50.116815Z 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-05-19T20:14:52.295861Z 0 InnoDB: New log files created, LSN=45790
2016-05-19T20:14:52.830312Z 0 InnoDB: Creating foreign key constraint system tables.
2016-05-19T20:14:52.900305Z 0 No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 58bc254a-1dfe-11e6-b44e-000c29a693ba.
2016-05-19T20:14:52.901926Z 0 Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-05-19T20:14:52.903104Z 1 A temporary password is generated for root@localhost: pgVUH?ypG6fe #随机生成的密码
3.7 配置文件和启动脚本
1
2
3
4
5
6
7
8
9
# mv /etc/my.cnf /etc/my.cnf.bk
# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
# sed -i '/^\/adatadir = /data/mysql' /etc/my.cnf
# sed -i '/^\/abasedir = /usr/local/mysql' /etc/my.cnf
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
# chmod +x /etc/init.d/mysqld
# chkconfig mysqld on
# sed -i 's@executing mysqld_safe@executing mysqld_safe\nexport LD_PRELOAD=/usr/local/lib/libjemalloc.so@' /usr/local/mysql/bin/mysqld_safe
# service mysqld restart
3.8 启动mysql修改root密码
1
2
3
4
5
6
7
# systemctl start mysqld.service
# mysql -uroot -ppgVUH?ypG6fe
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
4：编译安装PHP 4.1 编译安装
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
# yum -y install libxml2 libxml2-devel openssl openssl-devel curl-devel libjpeg-devel libpng-devel freetype-devel libmcrypt-devel
# wget http://hk1.php.net/distributions/php-7.0.6.tar.gz
# tar -xf php-7.0.6.tar.gz -C /usr/local/src/
# cd /usr/local/src/php-7.0.6/
# ./configure \
> --prefix=/usr/local/php \
> --with-mysql-sock=/data/mysql/mysql.sock \
> --with-config-file-path=/usr/local/php/etc \
> --with-mcrypt=/usr/include \
> --with-mhash \
> --with-openssl \
> --with-mysqli=shared,mysqlnd \
> --with-pdo-mysql=shared,mysqlnd \
> --with-gd \
> --with-iconv \
> --with-zlib \
> --enable-zip \
> --enable-inline-optimization \
> --disable-debug \
> --disable-rpath \
> --enable-shared \
> --enable-xml \
> --enable-bcmath \
> --enable-shmop \
> --enable-sysvsem \
> --enable-mbregex \
> --enable-mbstring \
> --enable-ftp \
> --enable-gd-native-ttf \
> --enable-pcntl \
> --enable-sockets \
> --with-xmlrpc \
> --enable-soap \
> --without-pear \
> --with-gettext \
> --enable-session \
> --with-curl \
> --with-jpeg-dir \
> --with-freetype-dir \
> --enable-opcache \
> --enable-fpm \
> --with-fpm-user=nginx \
> --with-fpm-group=nginx \
> --without-gdbm \
> --disable-fileinfo
# make -j 8 && make install
4.2 简单的设置
1
2
3
4
5
6
# ls /usr/local/php/lib/php/extensions/no-debug-non-zts-20151012/#查看生成的模块
mysqli.amysqli.soopcache.aopcache.sopdo_mysql.apdo_mysql.so
# cp /usr/local/src/php-7.0.6/php.ini-production /usr/local/php/etc/php.ini
# cp /usr/local/src/php-7.0.6/sapi/fpm/init.d.php-fpm /etc/init.d/php-fpm
# cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf
# cp /usr/local/php/etc/php-fpm.d/www.conf.default /usr/local/php/etc/php-fpm.d/www.conf
4.3 添加php的环境变量
1
export PATH=$PATH:/usr/local/mysql/bin:/usr/local/php/bin:/usr/local/php/sbin
4.4 创建php数据库文件的存放路径以及相关安全配置
1
2
3
# mkdir -p /var/log/php-fpm/ && mkdir -p /run/php-fpm && cd /run/ && chown -R nginx:nginx php-fpm
# mkdir -p /var/lib/php/session
# chown -R nginx:nginx /var/lib/php
4.5 设置PHP开机启动以及测试配置文件是否正确
1
2
3
4
5
6
7
8
9
10
11
12
# chmod +x /etc/init.d/php-fpm
# chkconfig php-fpm on
# php-fpm -t
NOTICE: configuration file /usr/local/php/etc/php-fpm.conf test is successful
# service php-fpm start
Starting php-fpmdone
# lsof -i :9000
COMMAND PIDUSER FD TYPE DEVICE SIZE/OFF NODE NAME
php-fpm 97375root 7uIPv4 136018 0t0TCP localhost:cslistener (LISTEN)
php-fpm 97376 nginx 0uIPv4 136018 0t0TCP localhost:cslistener (LISTEN)
php-fpm 97377 nginx 0uIPv4 136018 0t0TCP localhost:cslistener (LISTEN)
5：配置LNMP
5.1 配置nginx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
# ln -s /usr/local/nginx/sbin/nginx /usr/sbin/nginx
# mkdir /website
# chown -R nginx:nginx /website/
# vim /usr/local/nginx/conf/nginx.conf
usernginx nginx;
worker_processesauto;
error_loglogs/error.logerror;
pid /run/nginx.pid;
events {
use epoll;
worker_connections65535;
}
http {
include mime.types;
default_typeapplication/octet-stream;
log_formatmain'$remote_addr - $remote_user [$time_local] "$request" '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';
sendfile on;
tcp_nopush on;
tcp_nodelay on;
#keepalive_timeout0;
keepalive_timeout65;
gzipon;
gzip_min_length 1k;
gzip_buffers 4 16k;
gzip_http_version 1.1;
gzip_comp_level 2;
gzip_types text/plain application/ application/x- text/ text/css application/xml application/xml+rss;
gzip_vary on;
gzip_proxied expired no-cache no-store private auth;
gzip_disable "MSIE \.";
server {
listen 80;
server_nameoslinux.cn;
charset UTF-8;
location / {
root /website;
indexindex.html index.htm index.php;
}
location /NginxStatus {
stub_status on; #启用StubStatus的工作状态统计功能*/
access_log logs/NginxStatus.log; #/*StubStatus模块的访问日志文件*/
auth_basic "NginxStatus"; #/*StubStatus的一种认证机制*/
}
#error_page404 /404.html;
# redirect server error pages to the static page /50x.html
#
error_page 500 502 503 504/50x.html;
location = /50x.html {
root html;
}
location ~ \.php$ {
root /website;
fastcgi_pass 127.0.0.1:9000;
fastcgi_indexindex.php;
fastcgi_paramSCRIPT_FILENAME/website$fastcgi_script_name;
include fastcgi_params;
}
}
}
# nginx -s reload
5.2 配置PHP
1
2
3
4
5
6
7
8
9
10
11
# vim /usr/local/php/etc/php.ini
202 short_open_tag = On
359 expose_php = Off
722 extension_dir = "/usr/local/php/lib/php/extensions/no-de
bug-non-zts-20151012/"
901 zend_extension=opcache.so
902 extension=mysqli.so
903 extension=pdo_mysql.so
915 date.timezone = Asia/Shanghai
1732
1734 opcache.enable=1
1
2
3
4
5
6
7
8
# /etc/init.d/php-fpm restart
Gracefully shutting down php-fpm . done
Starting php-fpmdone
# nginx -s reload
# vim /website/index.php
<?php
phpinfo();
?>
页:
[1]