科技常识:基于Nginx0.8.54+PHP5.3.4+MySQL5.5.8的全新LNMP稳定版架构搭建的VPS

2021-04-10 03:25:15
导读 今天小编跟大家讲解下有关科技常识:基于Nginx0 8 54+PHP5 3 4+MySQL5 5 8的全新LNMP稳定版架构搭建的VPS,相信小伙伴们对这个话题应该也很

今天小编跟大家讲解下有关科技常识:基于Nginx0.8.54+PHP5.3.4+MySQL5.5.8的全新LNMP稳定版架构搭建的VPS,相信小伙伴们对这个话题应该也很关注吧,小编也收集到了有关科技常识:基于Nginx0.8.54+PHP5.3.4+MySQL5.5.8的全新LNMP稳定版架构搭建的VPS的相关资料,希望小伙伴会喜欢也能够帮助大家。

虽然开始在MySQL5.5.8的编译过程中遇到了一些问题,因为之前从未接触过Cmake方式的编译,在查阅官方手册并结合谷歌,终于把问题搞定了。 目前Nginx的worker_processes设置为4,php-fpm设置为dynamic模式,max_children=32,start_servers=8,min_spare_servers=4,max_spare_servers=16,max_request=512的环境下,540MB内存剩余380MB,相比之前用Zend Server CE搭建的LAMP内存开销,优化效果还是十分明显的,而且网站速度也很理想,给我最大的感受就是页面请求的响应速度比以前大大提升了。 鉴于MySQL5.5.8这个新产品发布不久,网上的相关资料匮乏,补充一些自己在编译上的内容(注意,我因为自己对innodb无需求,因此屏蔽了innodb引擎,如果需要可以开启参数-DWITH_INNOBASE_STORAGE_ENGINE=1。 复制代码 代码如下: #download software package wget http://www.cmake.org/files/v2.8/cmake-2.8.3.tar.gz wget http://ftp.gnu.org/gnu/bison/bison-2.4.3.tar.gz tar zxvf cmake-2.8.3.tar.gz cd cmake-2.8.3/ ./configure --prefix=/usr gmake gmake install cd ../ tar zxvf bison-2.4.3.tar.gz cd cd bison-2.4.3 ./configure make make install #install mysql5.5.8 /usr/sbin/groupadd mysql /usr/sbin/useradd -g mysql mysql mkdir -p /data/mysql chown -R mysql:mysql /data/mysql tar zxvf mysql-5.5.8.tar.gz cd mysql-5.5.8 cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DWITHOUT_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DSYSCONFDIR=/etc/ -DWITH_SSL=yes -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=on make make install /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/mysql --user=mysql #modify mysql config vim /etc/my.cnf [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-external-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M thread_concurrency = 1 basedir = /usr/local/mysql datadir = /data/mysql default-storage-engine = myisam log-bin=mysql-bin binlog_format=mixed server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout #add to boot config cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld chkconfig --add mysqld /etc/rc.d/init.d/mysqld start /usr/local/mysql/bin/mysql -u root -p -S /tmp/mysql.sock PS:如果在编译PHP的时候报错error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory,可以通过以下方法解决: 复制代码 代码如下: ln -s /usr/local/mysql/lib/mysql/libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16

来源:爱蒂网

免责声明:本文由用户上传,如有侵权请联系删除!

猜你喜欢

最新文章