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

Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú

 Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú
  Ò»¡¢Ó²¼þ»·¾³
      CPU:4ºËIntel(R) Xeon(R) CPU           E5504  @ 2.00GHz
      6GÄڴ棬120GÓ²ÅÌ
  ¶þ¡¢Èí¼þ»·¾³
     Linux centos12 2.6.18-164.6.1.el5 #1 SMP x86_64 GNU/Linux
     nginx-0.7.61.tar.gz
     mysql-5.1.35.tar.gz
     php-5.2.10.tar.gz
     memcache-2.2.5.tgz
     eaccelerator-0.9.5.3.tar.bz2
     ZendOptimizer-3.3.9-linux-glibc23-x86_64.tar.gz
  Èý¡¢Ïà¹ØÈí¼þÅäÖÃ
     1¡¢NginxÅäÖÃÎļþ
       user www www;
#worker_processes 1;
#ÒòΪÎÒÊÇ4ºËcpuËùÒÔÉèÖÃΪ4
worker_processes 4;
error_log /web/logs/nginx_error.log crit;
pid /usr/local/nginx/logs/nginx.pid;
#Specifies the value for maximum file descriptors that can be opened by this process.
worker_rlimit_nofile 51200;
events
{
use epoll;
worker_connections 51200;
}
http
{
include mime.types;
default_type application/octet-stream;
#charse gb2312;
server_names_hash_bucket_size 128;
client_header_buffer_size 32k;
large_client_header_buffers 4 64k;
client_max_body_size 8m;
sendfile on;
tcp_nopush on;
keepalive_timeout 60;
tcp_nodelay on;
#Ôö¼Ó³¬Ê±£¬ÒÔ±ÜÃâ502´íÎó
fastcgi_connect_timeout 600;
fastcgi_send_timeout 600;
fastcgi_read_timeout 600;
fastcgi_buffer_size 128k;
fastcgi_buffers 8 128k;
fastcgi_busy_buffers_size 256k;
fastcgi_temp_file_write_size 256k;
gzip on;
gzip_min_length 1k;
gzip_buffers 4 16k;
gzip_http_version 1.0;
gzip_comp_level 2;
gzip_types text/plain application/x-javascript text/css application/xml;
gzip_vary on;
#limit_zone crawler $binary_remote_addr 10m;
server
{


Ïà¹ØÎĵµ£º

dz̸MysQLÖÐHANDLERÓï·¨½éÉܼ°Ê¹ÓÃ

½ñÌìС±àÒªºÍ´ó¼Ò˵µÄÊÇhandlerµÄÓ÷¨£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
HANDLER tbl_name OPEN [ AS alias ]
HANDLER tbl_name READ index_name { = | >= | <= | < } (value1,value2,...)
    [ WHERE where_condition ] [LIMIT ... ]
HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } ......

ubuntuÖÐmysqlÂÒÂëÎÊÌâ

 ÏÈ¿´ÏÂÃæ×¢ÒâÄÚÈÝ
ÕûÕûŪÁËÒ»Ì죬ÖÕÓÚ½â¾öÁËjdbc(mysql-connector-java-5.0.30)ºÍmysqͨÐÅÖÐÎÄÂÒÂëµÄÎÊÌ⣡ÎÒµÄϵͳÊÇ
linux£¨ubuntu£©¡£ÔÚjavaÖУ¨Myeclipse»·¾³£©Ê¹ÓÃhibernateÁ¬½Ómysql¡£´æ´¢Ó¢ÎÄûÎÊÌ⣬д£¨insert
into£©ºÍ¶Á£¨select£©¶¼ÄÜÕýÈ·ÏÔʾ£¬µ«ÊÇÈôÆäÖдøÓÐÖÐÎÄ×Ö·û¾Í³ÉÂÒÂëÁË¡£µ½ÍøÉϲéÕÒÁ˰ëÌì×ÊÁ ......

½«MySQLÖÐsqlÔËÐнá¹û±£´æµ½Îļþ

 ÓÐÁ½ÖÖ·½·¨¡£
·½·¨Ò»£ºÔÚmysql>Ìáʾ·ûÖÐʹÓÃtee
mysql> tee output.txt
Logging to file 'output.txt'
mysql> notee
Outfile disabled.
»òÕß
mysql> \T output.txt
Logging to file 'output.txt'
mysql> \t
Outfile disabled.
Õâ¸öÀàËÆÓÚsqlplusµÄspool¹¦ÄÜ£¬¿ÉÒÔ½«ÃüÁîÐÐÖеĽá¹û±£´æµ½Í ......

PHP

ÎÒÊÇѧµç×ÓÉÌÎñµÄѧÉú£¬Ö÷Ҫѧϰ·½ÏòÊǵç×ÓÉÌÎñ¼¼Êõ²ãÃæµÄ¶«Î÷¡£Ñ§ÁËÒ»Äê¶àµÄʱ¼äÁË£¬¸Ð¾õСÓÐÊÕ»ñ¡£
ǰ¶Îʱ¼ä³öÈ¥ÃæÊÔflashµÄʱºò·¢ÏÖ×Ô¼ººÍ±ðÈ˵ÄÒªÇó²î¾àÉõÔ¶£¬»Øµ½Ñ§Ð£ºóŬÁ¦µÄѧϰPHP£¬×ÔÎҸоõ»¹²»´í£¬È«°àֻʣϼ¸¸öÈËÔÚѧºǫ́ÓïÑÔÁË£¬²»ÖªµÀÊÇÒòΪÓÐÁËÉÏÒ»´ÎµÄ´ò»÷»¹ÊÇÒòΪÎÒÊʺÏѧPHP£¬×ÔÈÏΪѧµÃ±È½Ï¿ì£¬ÖÁÉÙ±ÈÖ ......

×îÁîPHP³õѧÕßÍ·Í´µÄÊ®ËĸöÎÊÌâ

 ¡¾1¡¿Ò³ÃæÖ®¼äÎÞ·¨´«µÝ±äÁ¿ get,post,sessionÔÚ×îеÄphp°æ±¾ÖÐ×Ô¶¯È«¾Ö±äÁ¿Êǹرյģ¬ËùÒÔÒª´ÓÉÏÒ»Ò³ÃæÈ¡µÃÌá½»¹ýÀ´µÃ±äÁ¿ÒªÊ¹ÓÃ$_GET['foo'],$ _POST['foo'],$_SESSION['foo']À´µÃµ½¡£µ±È»Ò²¿ÉÒÔÐÞ¸Ä×Ô¶¯È«¾Ö±äÁ¿Îª¿ª(php.ini¸ÄΪ register_globals = On)£»¿¼Âǵ½¼æÈÝÐÔ£¬»¹ÊÇÇ¿ÆÈ×Ô¼ºÊìϤеÄд·¨±È½ÏºÃ¡£¡¡¡¡
¡¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ