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

Wireshark ×¥°üMySQLµÄ²éѯÓï¾ä

¹ýÂËÆ÷Ìõ¼þ
mysql.query contains "SELECT"
..
..
..
..
MySQL Protocol
    Packet Length: 168
    Packet Number: 0
    Command
        Command: Query (3)
        Statement: EXPLAIN SELECT `GROUP_ID`,`MEMBER_ID`,`JOIN_DATETIME`,`IS_GROUP_MANAGER`,`IS_ADMIN` from `users` WHERE (`GROUP_ID` = '1') AND (`IS_GROUP_MANAGER` = 'T')


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿âÒýÇæ½éÉÜ

Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊǰ´°´Å¥»»
ÒýÇæ£»ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇæ£¬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ÒâµÄ ......

¶ÔMySQLÖеÄËø»úÖÆµÄ×ܽá

½ñÌìÀ´¼òµ¥×ܽáÒ»ÏÂMySQL
µÄ
Ëø»úÖÆ£¬²»Í׵϶ӭÅÄש£¡
¡¡¡¡1¡¢¶ÔÓÚMySQLÀ´Ëµ£¬ÓÐÈýÖÖËøµÄ¼¶±ð£ºÒ³¼¶¡¢±í¼¶¡¢Ðм¶¡£
¡¡¡¡Ò³¼¶µÄµäÐÍ´ú±íÒýÇæÎªBDB¡£
¡¡¡¡±í¼¶µÄµäÐÍ´ú±íÒýÇæÎªMyISAM,MEMORYÒÔ¼°ºÜ¾ÃÒÔǰµÄISAM¡£
¡¡¡¡Ðм¶µÄµäÐÍ´ú±íÒýÇæÎªINNODB¡£
¡¡¡¡2¡¢ÎÒÃÇʵ¼ÊÓ¦ÓÃÖÐÓõÄ×î¶àµÄ¾ÍÊÇÐÐËøÁË¡£
¡¡¡¡Ðм¶ËøµÄÓŵãÈç ......

mysqlѧϰ1 ¸ÅÊö¼°ÌØÕ÷

·   ÄÚ²¿¹¹¼þºÍ¿ÉÒÆÖ²ÐÔ 
o  ÌṩÁËÊÂÎñÐԺͷÇÊÂÎñÐÔ´æ´¢ÒýÇæ¡£
--ÊÇ·ñÖ¸Èç¹ûÒª²ÉÓÃÊÂÎñ¹ÜÀí£¬±ØÐëÇл»´æ´¢ÒýÇæ£¿£¿£¿
·         Óï¾äºÍº¯Êý
DELETE¡¢INSERT¡¢REPLACEºÍUPDATE·µ»Ø¸ü¸Ä£¨Ó°Ï죩µÄÐÐÊý¡£Á¬½Óµ½·þÎñÆ÷ʱ£¬¿Éͨ¹ýÉèÖ ......

php ½âÎö excel ´æ´¢µ½ mysql ÂÒÂë


±àÂëÊǸöºÜ»ù´¡µÄÎÊÌ⣬ҲÊÇ´ó¼ÒºÜÈÝÒ׺öÂÔµÄÎÊÌ⣬д´úÂë֮ǰ¶à¶à¿¼ÂÇ£¬ÒÔºó»áÉٺܶàÂé·³¡£
PHP·¢Õ¹Á˲»ÉÙ£¬ÏÖÔÚpearÓÃÆðÀ´ºÜ·½±ã£¬ÆäÖоÍÓÐÏà¹ØµÄclassÀ´¶ÁÈ¡ExcelÎļþÀïÃæµÄÄÚÈÝ£¬Èç¹û²»ÏëʹÓÃpearµÄ»°£¬¿ÉÒÔ¿¼ÂÇʹÓÃexcel_class.php£¬googleһϣ¬¿ÉÒÔÕÒµ½Õâ¸öclassµÄsource codeÏÂÔØ£¬Ò²ÄÜÕÒµ½»ù±¾µÄexample c ......

linux,nginx,mysql,php°²×°±¸Íü

niginx°²×°Á÷³Ì
Èí¼þÏÂÔØ:--->
mkdir -p /home/dancebear/programe
cd /home/dancebear/programe
wget http://sysoev.ru/nginx/nginx-0.6.31.tar.gz
wget http://www.php.net/get/php-5.2.6.tar.gz/from/this/mirror
wget http://php-fpm.anight.org/downloads/head/php-5.2.6-fpm-0.5.8.diff.gz
wget http://dev ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ