Improving Site Performance�K �����������į�K
I have significantly improved our site performance in the last month.�ڦ���ۧﵽ�ڭ̪���������{�b�L�h�@�Ӥ뤤�C I did all the site optimization steps by the book, found a lot of new things and fine-tuned existing ideas.�ڥ��өҦ��������u�ƪ��B�J�A�����l��ơA�o�{�F�ܦh�s���F��M�L�ղ{�����Q�k�C There are a couple of good ideas I am yet to implement like using Lighttpd server instead of Apache 2.���@��Ұ�n�D�N�A�ڤ�����I���w�ϥ�lighttpd�Ӥ��O�A�Ⱦ���Apache 2 �C
I am writing a detailed article on all the site optimization steps we have taken, what worked and what didn't and why.�ڼg�@���ԲӪ��峹��Ҧ��������u�ƪ��B�J�A�ڭ̤w�Ĩ��u�@�M���M����]�C You would be surprised with the results.�A�|�P��Q����Y�P���G�C It should be ready in 2-3 weeks after I complete this phase of optimizations with master-master replication of MySQL databases & Lighttpd.I have a server in-waiting which we will soon use to replicate our sites.�����ӷdzƦb2-3�g��A�ڧ����o�Ӷ��q���u�ƻP�D�D�ƻs��MySQL�ƾڮw�� lighttpd.i���@�ӪA�Ⱦ��b���ݡA�ڭ̱N�ɧ֨ϥνƻs�ڭ̪������C
In the end the ability to measure the improvements and persistence paid off.�b�~������O�ӿŶq���ﵽ�M�ݤO�����ġC As you had read so far into the article I will offer two hints:���p�A�ݹL�o���峹�A�ڷ|���Ѩ�ش��ܡG
1. 1 �C Watch your MySQL.�[��A��MySQL �C It is most likely where the bottleneck is, specially for WordPress sites.�o�O�̦��i��a��O�~�V�A�S�O�O���bWordPress�����C
2. 2 �C Use ajaxMyTop to watch MySQL during heavy load period.�ϥ�ajaxmytop�[�MySQL�b����ɴ��C You can also use the MySQL's slow query log, but I found using mtop to be the best idea.�z�]�i�H�ϥ�MySQL���w�C�d�ߤ�x�A��ڵo�{�ϥ�mtop�{���̦n���Q�k�C
Filed under���_�U Database�ƾڮw , �A Database Replication�ƾڮw�ƻs , �A Enterprise Software��~�n�� , �A Headline News�Y��s�D , �A How To�p�� , �A Linux Linux�� , �A MySQL MySQL�� , �A Open Source Software�}�X�n�� , �A Pro Blogging�٦�Blogging , �A RDBMS RDBMS�� , �A Web���� , �A Web 2.0 Web 2.0�� , �A Web Hosting�����D�� , �A Web Services Web�A�� , �A WordPress�bWordPress | |
| |
RSS 2.0 2.0 | |
Trackback Trackback��踪 this Article |���峹|
Email this Article�q�l�l�峹
You may also like to read�z�]�i�H�QŪ |





































September 26th, 2007 at 1:45 am 2007�~9��26��b�W��01��45��
lighttpd should be a breeze for you since you don��t use ��pretty permalink�� (urls without ��index.php��) lighttpd���ӬO�@�ӷL�����z�J�M�A���ϥΡ��}�G���ä[�� �]���}�L����index.php �� �^
It sucks if you want to use real clean permalinks, because there is no such things as ��if file does not exist, redirect�� as the generic rewrite rule in WP .htaccess��sucks���p�G�A�Q�ϥίu�����M��A�ä[�A�]�����̬O�S���o�˪��Ʊ��G ���p�G��s�b�A���s�ɦV���@���q�έ��g�W�h���i��ʯ����C htaccess��
September 27th, 2007 at 9:54 pm 2007�~9��27��b�U��9�I54��
I do use pretty permalinks for most of my blogs, except the early ones like simple thoughts.�ڨϥκ}�G���ä[���j�����ɶ��ڪ�Blog �A���F�����@�ˡA²�檺�Q�k�C
How did you solve it?�A�̬O���ѨM�O�H