¶àÏß³Ì Mysql Çó¾È
ÎÒÓÃsocket+mysql½øÐÐÍøÂç±à³Ì. ÓÃUDP¡£ ÏÖÔÚÓÐ2¸öÎÊÌâÇë½Ì 1.ÎÒÓ¦¸ÃÏÈÁ¬½Ómysql.È»ºóÊÕµ½Ò»¸öÓû§ÏûÏ¢ºó¾Í¿ªÆôÒ»¸öÏß³Ì,¸ù¾ÝÏûÏ¢µÄÄÚÈÝ¿ÉÄÜ»áÖ´ÐвåÈë»ò²éѯ»ò¸üлòɾ³ýÆäÖÐÒ»ÖÖ²Ù×÷. ÎÒÊÇËùÓÐÏ̶߳¼ÊÇÓÃÏÈǰµÄÁ¬½Ó »¹ÊÇÔÚÿ¸öÏß³ÌÖе¥¶À´´½¨Á¬½Ó½øÐвÙ×÷? 2.¶¼ËµMysqlÊǶàÏ̵߳Ä.ÎÒÏëÖªµÀÈç¹ûÎÒʹÓÃ1¸öÁ¬½Ó½øÐÐËùÓвÙ×÷ÐèҪͬ²½Âð,Èç¹ûÐèÒªÄÇôÊÇ·ñÒÔÉϲÙ×÷¶¼ÐèҪͬ²½?ͬÀíÈç¹ûʹÓÃÿ¸öÏ̶߳¼µ¥¶À´´½¨1¸öÁ¬½ÓµÄ·½Ê½ÐèҪͬ²½Âð,Èç¹ûÐèÒªÄÇôÊÇ·ñÒÔÉϲÙ×÷¶¼ÐèҪͬ²½? Èç¹ûʹÓÃÿ¸öÏ̶߳¼µ¥¶À´´½¨1¸öÁ¬½ÓµÄ·½Ê½ Mysql»á²»»áÒòΪÁ¬½Ó¶àÁË ¶ø¾Ü¾øÁ¬½Ó?
mysql Óиömax connection ²ÎÊýÏÞÖÆÁ´½Ó MySQL µÄÁ¬½Ó¸ÅÄî·Ç³£¼òµ¥£¬ Ò»¸öÁ¬½Ó¶ÔÓ¦Ò»¸öTCP/IPÁ¬½Ó¡£ ÄÇôÇëÎÊ Èç¹û ÎÒÒѾÁ¬½ÓÁËÒ»¸öMysql ±ÈÈçMySql AÁË. ÏÖÔÚÎÒÔÚÏß³ÌÀïÃæ´´½¨Ò»¸öMySql B,È»ºóB=A¡£ ÔÚÓÃBÀ´Ö´ÐÐÃüÁî... ÕâËãÊÇ Ð¿ªÒ»¸öÁ¬½ÓÂð ÒýÓà ÒýÓô´½¨Ò»¸öMySql B ÄãµÄ´´½¨µÄ´úÂëÊÇʲô£¿ ÖîÈç MySql A;mysql_init(&A);AҲͨ¹ýÓû§Ãû£¬ÃÜÂ룬Á¬½ÓÉÏÁËÊý¾Ý¿â. ÒÔºó ÎÒÔÙ½¨MySql B; Ö´ÐÐB=A; È»ºó¾Í¿ÉÒÔÖ±½Ó µ÷ÓÃÃüÁî²»ÐèÒªÔÙ¶ÔÓÃÓû§ÃûºÍÃÜÂëÁ¬½ÓÊý¾Ý¿â£¬¿ÉÒÔÖ±½Óµ÷ÓÃmysql_queryÖ®ÀàµÄº¯ÊýÖ´ÐÐÃüÁîÁË.ÕâËãÊÇÐÂÔöÁË1Á¬½ÓÂð ²»Ëã¡£ÓõϹÊÇͬһ¸ö¡£ Æäʵ£¬Äãµ½mysqlÖп´Ò»Ï show processlist; ¾ÍÖªµÀµ±Ç°ÓжàÉÙ¸öÁ¬½ÓÁË¡£ ÔÀ´Èç´Ë лл,ÎÒ¶ÔÊý¾Ý¿â²»Á˽âºÇºÇ.. ÎÒ»¹ÏëÎÊÏÂ... ÓкܶàÓû§·¢ÏûÏ¢¹ýÀ´... ÎÒÔÚÊÕµ½ÏûÏ¢ºó¾Í´´½¨1¸öÏß³ÌÈ¥´¦Àí... ¾ÍÓÃ1¸öÁ¬½ÓºÃ»¹ÊÇÔÚÿ¸öÏß³ÌÖж¼µ¥¶À´´½¨Ò»¸öÁ¬½ÓºÃ? <
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂ𣿠ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡ ×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£ win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£ µ±È»Äã×î ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿ ÄãÊÇÈçºÎɾ³ýµÄ£¿ ÓÐʲôÌáʾ£¿ ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì, ·ÃÎÊoracleµÄÊý¾Ý. Ŀǰ²»ÄÜ oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬ ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý
......
ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð» ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿ ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öÊ²Ã´ÄØ ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´Ómemcac ......