lighttpd + mysql + php(fast cgi)°²×°ÓëÅäÖÃ
×¼±¸:
lighttpd-1.4.15.tar.gz
php-4.4.2.tar.gz
mysql-5.0.20a.tar.gz
¿ªÊ¼:
1 ±àÒë°²×°lighttpd
# tar zxvf lighttpd-1.4.15.tar.gz
# cd lighttpd-1.4.15
# ls
# ./configure --prefix=/usr/local/lighttpd //´Ë²¿ÎÞ·¨±àÒëʱÌáʾ°²×°prce-devel
# make
# make install
´´½¨ÍøÕ¾¸ùĿ¼
# mkdir /usr/local/lighttpd/htdocs
´´½¨ÅäÖÃÎļþ·ÅÖÃĿ¼
#mkdir /usr/local/lighttpd/etc
´´½¨ÈÕ־Ŀ¼
#mkdir /usr/local/lighttpd/logs
½«ÅäÖÃÎļþ¿½±´µ½/usr/local/lighttpd/etc
#cp doc/lighttpd.conf /usr/local/lighttpd/etc
Æô¶¯lighttpd
#/usr/local/lighttpd/sbin/lighttpd -f /usr/local/lighttpd/etc/lighttpd.conf
ÎÒÔÚ°²×°µÄʱºòÔÚerrorÈÕÖ¾³öÏÖ opening errorlog '/var/log/lighttpd/access.log
ÔÚ/var/logϽ¨Á¢lighttpdĿ¼¾Í¿ÉÒÔÁË
2 °²×° MYSQL
# tar zxvf mysql-5.0.20a.tar.gz
# cd mysql-5.0.20a
# ./configure --prefix=/usr/local/mysql
# make;make install
# groupadd mysql
# useradd -g mysql mysql
# cp support-files/my-medium.cnf /etc/my.cnf
# cd /usr/local/mysql/
³õʼ»¯
# bin/mysql_install_db --user=mysql
ÔËÐÐ
bin/mysqld_safe --user=mysql &
ÉèÖÃ×Ô¶¯Æô¶¯£¨ÂÔ£©
3 °²×° php (fast-cgi)
# tar zxvf php-4.4.2.tar.gz
# cd php-4.4.2
±àÒ룬¼Ó --enable-fastcgi ºÍ --enable-force-cgi-redirect Ñ¡Ïî
# ./configure --prefix=/usr/local/php-fastcgi --enable-fastcgi --enable-force-cgi-redirect --with-zlib --
with-gd --with-ttf --with-png --with-expat-dir=/usr --with-gmp --with-xml --with-mysql=/usr/local/mysql --with-
charset=utf-8 --disable-debug --disable-posix --disable-rpath --enable-safe-mode --enable-magic-quotes --disabl
e-dmalloc --enable-bcmath --enable-dio --enable-gd-native-ttf --enable-sysvsem --enable-sysvshm --enable-wddx -
-enable-versioning --enable-pic --enable-inline-optimization --enable-memory-limit --enable-mbstring --enable-m
bregex --enable-mbstr-enc-trans --with-config-file-path=/usr/local/lib --enable-ft
Ïà¹ØÎĵµ£º
ÖªµÀ²î¾àÁË£¬Å¬Á¦°É£¡
1. Which of the following will not add john to the users array?
1. $users[] = 'john';
2. array_add($users,'john');
3. array_push($users,'john');
4. $users ||= 'john';
2. What's the difference between sort(), asort() and ksort? Under what circumstances would you use each o ......
±ÈÈçÒª¸øÓû§±¨¸æÒ»¸ö´íÎó£¬ÓÃÏÂÃæµÄ·½·¨£º
ʹÓÃset_error_handlerÉèÖÃ×Ô¼ºµÄ´íÎó´¦Àíº¯Êý£¬ÔÚ±¨´íµÄµØ·½Ê¹ÓÃtrigger_error£¬ÔÚ×Ô¶¨ÒåµÄ´íÎó´¦Àíº¯ÊýÖиøÓû§ÏÔʾһ¸ö³ö´íÐÅÏ¢Ò³Ãæ¡£
µ«
ÊÇÈç¹ûµ÷ÓÃtrigger_errorµÄÕâ¸öÒ³ÃæÊDZ»Ò»´ÎajaxÇëÇó´¥·¢µÄ£¬ÄÇôajax·µ»Øºó½«µÃµ½Ò»´ó¶ÑÓÃÓÚÏÔʾ´íÎóµÄhtml´úÂë¡£¶øÒ»°ã
ajaxµ÷Óö ......
MySQLÊý¾Ý¿âÈÕÖ¾
selectÈÕÖ¾
slow selectÈÕÖ¾
±ä¸üÈÕÖ¾
¶þ½øÖƱä¸üÈÕÖ¾(binlog)
¸æ¾¯ÈÕÖ¾
´íÎóÈÕÖ¾¡£
¿ÉÒÔÔÚmy.cnfÖÐÅäÖÃ
²ÎÊý
˵Ã÷
log
Îı¾selectÈÕÖ¾£¬¼ÇÏÂËùÓеÄMySQLµÄÃüÁî²Ù×÷£¬
log-update
Îı¾±ä¸üÈÕÖ¾
log-bin
Õâ¸ö¶¼ÖªµÀÁË£¬Êý¾Ý¿â¸´ÖƵÄʱºò±Ø±¸
binlog_cache_size
ÁÙʱ´æ·Åij´ÎÊÂÎñµÄSQL ......
ÓÅ»¯MySQLÊý¾Ý¿â²éѯ
ÔÚÓÅ»¯²éѯÖУ¬Êý¾Ý¿âÓ¦ÓÃ(ÈçMySQL)¼´Òâζ×ŶԹ¤¾ßµÄ²Ù×÷ÓëʹÓá£Ê¹ÓÃË÷Òý¡¢Ê¹ÓÃEXPLAIN·ÖÎö²éѯÒÔ¼°µ÷ÕûMySQLµÄÄÚ²¿ÅäÖÿɴﵽÓÅ»¯²éѯµÄÄ¿µÄ
¡¡¡¡ÈκÎһλÊý¾Ý¿â³ÌÐòÔ±¶¼»áÓÐÕâÑùµÄÌå»á£º¸ßͨÐÅÁ¿µÄÊý¾Ý¿âÇý¶¯³ÌÐòÖУ¬Ò»ÌõÔã¸âµÄSQL²éѯÓï¾ä¿É¶ÔÕû¸öÓ¦ÓóÌÐòµÄÔËÐвúÉúÑÏÖØµÄ ......