Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 »Ö¸´±»É¾µÄ root ÕË»§

.¹Ø±ÕÏÖÓÐmysql
.²»¼ÓÔØgrant_tables¶ø½øÈëmysql
D:\>mysqld-nt --skip-grant-tables OR mysqld_safe --skip-grant-tables
.пªÒ»¸öcmd´°¿Ú,È»ºó°´ÏÂÃæÖ´ÐÐ
D:\>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-community-nt ......

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

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

Linux ÏÂMySQL NDBÅäÖÃ

A) Shutdown management node and data node
devmysql3# ndb_mgm -e shutdown
devmysql4# ndb_mgm -e shutdown
B) Shutdown MySQL proccess
devmysql3# mysqladmin shutdown
devmysql4# mysqladmin shutdown
devmysql3 ip: 10.130.30.217
devmysql4 ip: 10.130.30.218
rpm -ivh MySQL-Cluster-gpl-storage ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ