Skip to main content

Yet another Nginx story

Last night one of my friend gtalk me and complaining about his vps is slow and lagging. Further checking the process is highly spike where load average: 173.68, 165.51, 146.09 which is abnormal.

I'm thinking the MySQL is consuming all the resources and when I try to restart the process it's come to timeout. No chance at all.. I tried to stop httpd, also timeout and kill come to my hand :)

kill -9 [processid]

After restart httpd, the load is still high around 4 to 6. I plan to replace Apache with latest Nginx and using php-cgi for communicate with PHP. Surprisingly after I start Nginx the process come to 0.35 not even close to 1..

And that how Nginx act as a hero..

yatta~

Comments

Post a Comment

Popular posts from this blog

MySQL Enterprise thingy

It's been a weird thing when you install MySQL server especially the one that is 'enterprise' version is not working with your PHP. That is the problem that my friend and I facing today. Since PHP require php-mysql extension to connect to MySQL server but php-mysql is only work with mysql-server from the Repos (Redhat/Centos). 1) Remove default mysql-server/php-mysql 2) Install MySQL Enterprise 3) Dependencies conflict occur + headache + install php-mysql shell> yum install php-mysql Loaded plugins: rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package php-mysql.x86_64 0:5.1.6-27.el5 set to be updated --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: php-mysql --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: php-mysql --> Running transaction check ---> Package mysql.x86_64 0:5.0.77-4.el5_4.2 set to be updated --> Process...
2 comments
Read more

DirectAdmin - Upgrading MySQL from 5.5 to 5.6

cd /usr/local/directadmin/custombuild mkdir -p mysql cd mysql wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-client-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-devel-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-server-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-shared-5.5.41-1.linux2.6.x86_64.rpm cd .. ./build mysql_backup mv mysql_backups mysql_backups.`date +%F` #after this point, you can't abort rpm -e --noscripts `rpm -qa | grep MariaDB` cd mysql rpm -ivh MySQL*5.5.41*.rpm #ensure it's running. cd .. ./build set mysql 5.6 ./build set mysql_inst yes ./build mysql # confirm mysqld is running. ./build php n
Post a Comment
Read more

Upgrading MySQL to MariaDB

Ever since MariaDB exists, I really like to install and test the performance but time consume for my daily work stopped me to try MariaDB, today I plan to update my MySQL server that serve lot of data in and out to MariaDB 10.0 (today latest version :P ) So there's a few step that should be considered before we can proceed further. 1. BACKUP - Always backup your data at the first place. - Save it to the proper place so that if anything goes wrong, you can export back your data. mysqldump -u root -pYOURPASSWORD --all-databases > allbackup.sql & If you don't want to wait and you know that the current database is big, just put the process at the background so that you can monitor the process using top :) - Backup your current configuration files cp /etc/my.cnf /tmp/my.cnf.bak 2. Let's go If you're installing mysql from webtatic and made a replacing package name , you may encountered an error like Error: mysql55w conflicts with MariaDB-server-5.5....
Post a Comment
Read more