Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

web serverʹÓÃphpÉú³ÉwebÒ³ÃæµÄÈýÖÖ·½Ê½

²éÕÒmysql_pconnectʱÔÚmysql°ïÖúÎĵµÉÏ·¢Ïֵ쬼ÇÔÚÕâÀï¡£
web serverʹÓÃphpÉú³ÉÒ»¸öwebÒ³ÃæµÄÈýʽÓÐÒÔÏÂÈýÖÖ£º
Ò»£º°ÑPHP×÷ΪCGI Wrapper¡£ÕâÖÖ·½Ê½Ï£¬Ã¿¸öµ½´ïweb serverµÄÇëÇ󶼻ᵼÖÂÒ»¸öphp½âÎöÆ÷½ø³Ì±»´´½¨£¬µ±Õâ¸öphpÒ³ÃæÖ´ÐнáÊøÊ±£¬Õâ¸öphp½âÎöÆ÷½ø³ÌÖÕÖ¹¡£
¶þ£º
ÔÚ¶à½ø³ÌµÄweb serverÖУ¬°Ñphp×÷Ϊweb
se ......

MySQL³£Óõĵ¼Èëµ¼³öÃüÁî

³£ÓõÄ:
µ¼³ö
mysqldump -hyour_host -uyour_username -pyour_password database_name > file.sql
µ¼Èë
mysql -hyour_host -uyour_username -pyour_password database_name < file.sql
»òÕßÏÈÓÃmysql¿Í»§¶ËµÇ½ºó£¬
>\. file.sql
Ò²¿ÉÒÔÍê³Éµ¼È빦ÄÜ
ÉÏÃæµÄÁ½¸öÃüÁî½áºÏÆðÀ´Ó㬿ÉÒÔÍê³É½«Ò»¸öÊý¾Ý¿âµÄ ......

mysqlÃÜÂëÐ޸ķ½·¨

MySQLÃÜÂëÐ޸ķ½·¨
   Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£
      ·½·¨Ò»
¡¡¡¡Ê¹ÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬
¡¡¡¡²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
¡¡¡¡·½·¨¶þ
¡¡ ......

mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯

mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯
 
MYSQLµÄÓÅ»¯ÊǷdz£ÖØÒªµÄ¡£ÆäËû×î³£ÓÃÒ²×îÐèÒªÓÅ»¯µÄ¾ÍÊÇlimit¡£mysqlµÄlimit¸ø·ÖÒ³´øÀ´Á˼«´óµÄ·½±ã£¬µ«Êý¾ÝÁ¿Ò»´óµÄʱºò£¬limitµÄÐÔÄܾͼ±¾çϽµ¡£
ͬÑùÊÇÈ¡10ÌõÊý¾Ý
select * from yanxue8_visit limit 10000,10 ºÍ
select * from yanxue8_visit limit 0,10
¾Í²»ÊÇÒ»¸öÊýÁ¿¼¶±ðµ ......

MySQLÊý¾Ý¿âÈÕÖ¾

MySQLÊý¾Ý¿âÈÕÖ¾
selectÈÕÖ¾
slow selectÈÕÖ¾
±ä¸üÈÕÖ¾
¶þ½øÖƱä¸üÈÕÖ¾(binlog)
¸æ¾¯ÈÕÖ¾
´íÎóÈÕÖ¾¡£
¿ÉÒÔÔÚmy.cnfÖÐÅäÖÃ
²ÎÊý
˵Ã÷
log
Îı¾selectÈÕÖ¾£¬¼ÇÏÂËùÓеÄMySQLµÄÃüÁî²Ù×÷£¬
log-update
Îı¾±ä¸üÈÕÖ¾
log-bin
Õâ¸ö¶¼ÖªµÀÁË£¬Êý¾Ý¿â¸´ÖƵÄʱºò±Ø±¸
binlog_cache_size
ÁÙʱ´æ·Åij´ÎÊÂÎñµÄSQL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ