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

mysql 5.0 to mysql 5.1µÄBTREEË÷ÒýÎÊÌâ


ÎÒ±¾»ú²âÊÔÊÇ°²×°µÄ mysql 5.1 , µ« centos ·þÎñÆ÷ÉÏÈ·ÊÇʹÓÃµÄ mysql 5.0 , ƽʱû·¢ÏÖ²î±ð, µ«×î½üsql Îļþµ¼Èëµ¼³öʱ·¢ÏÖÁË, Ò»µãСС²î±ð.
Ö÷ÒªÊÇÔÚ´¦Àíµ½Ë÷ÒýÓï¾äʱ³öÏÖÁ˲»¼æÈݵÄÇé¿ö, ±ÈÈçÏÂÃæÓï¾äÊÇÔÚ mysql 5.1 µ¼³öµÄ:
KEY `index_2` (`datatype`,`stime`,`line`,`mcode`) USING BTREE
Èç¹ûÏëµ¼Èëµ½ mysql 5.0 Ôòµ÷Õû USING BTREE ÕâÀàÖ¸¶¨Ë÷ÒýÀàÐÍÓï¾äµÄλÖõ½Öмä, Ϊ:
KEY `index_2` USING BTREE (`datatype`,`stime`,`line`,`mcode`)


Ïà¹ØÎĵµ£º

MySQLС¼¼ÇÉ 1

1,Íü¼ÇrootÃÜÂë,Èç¹ûÄÜ»¹ÄܽøÈëmysqlÇÒ»¹ÓÐmysql¿âµÄȨÏÞ,ÄÇô¾ÍÖ±½ÓÖ´ÐÐ update user set password=password(¡®XXX¡¯) where user=¡¯root¡¯ and host=¡¯XX¡¯; flush privileges; ¼´¿É.Èç¹û²»ÄܽøÈëmysql,ÐèÒªÓÐmysqlÆô¶¯µÄȨÏÞ,ÔÚÆô¶¯mysqlµÄʱºò¼ÓÉÏ--skip-grant-tablesÑ¡Ïî,´Ëʱ½øÈëmysqlÎÞÐèÃÜÂë,ÔÙÖظ´ÉÏÊö²Ù ......

spring+hibernateÔÚMYSQLϵÄһЩÎÊÌâ

½ñÌìÔÚ°ïÅóÓѵ÷ÊÔÒ»¸ö¹ØÓÚ¶àÏ̷߳ÃÎÊͬһÕűíÒýÆðµÄLock wait timeout exceedeµÄÎÊÌ⣬¸Ð¾õÒýÆðµÄÔ­ÒòÓУº
1£¬Ã»ÓнøÐÐÓÅ»¯£¬¾¡Á¿±ÜÃâ¶àÏß³Ì
2£¬¸ù¾ÝËüºóÃ汨µÄÒì³££¬ÌáÐÑÎÒ¿ÉÒÔHibernate µÄSessionûÓÐʹÓõõ±£¬(Ò²ÊÇÎÒ½â¾öµÄ·½°¸)
3£¬ÓÃsynchronizedÐÞÊθüбíµÄº¯Êý
¹À¼ÆÊÇÔ­À´³ÌÐòÔÚÐÞ¸ÄÍê¸Ã±íʱÁ¢¿Ì½øÐÐÁ˲åÈë²Ù× ......

mysql¼òµ¥ÌáȨ

S- servÌáȨ·½Ê½ÈËÈ˶¼»áÓÃÁË£¬¸ãµÃÏÖÔÚµÄÖ÷»ú¶¼ÅäÖõ÷dz£°²È«£¬¿´À´¹¥»÷ÊÖ·¨µÄ²ã³ö²»ÇîÒ²ÊÇÔì³ÉÖйúÍøÂ簲ȫ½ø²½µÄÒ»´óÔ­ÒòÖ®Ò»£¬»¹ÓÐÆäËûµÄ pcanywhere»ñÈ¡ÃÜÂ룬Ìæ»»·þÎñ£¬µÈµÈ¡£µ«ÊÇÏÖÔÚҲûÕâôºÃ¸ãÁË£¬Ëæ×Å°²È«ÒâʶµÄÌá¸ß£¬Ö®Ç°µÄ·½Ê½¹À¼Æ²»Ôõô¹ÜÓã¬ÏÖÔÚÎÒ¸ø´ó¼Ò½éÉÜÒ»ÏÂÒ»ÖÖеÄÌáȨ·½Ê½£¬¿´¹ý¹ÅµäLM×öµÄÄǶ¯»­µÄ ......

MySQL²»Ö§³ÖINTERSECTºÍMINUS£¬¼°ÆäÌæ´ú·½·¨

Doing INTERSECT and MINUS in MySQL
By Carsten | October 3, 2005
Doing an INTERSECT
An INTERSECT is simply an inner join where we compare the tuples of one table with those of the other, and select those that appear in both while weeding out duplicates. So
SELECT member_id, name from a
INTERSECT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ