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

¶àÏß³Ì 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¸öÁ¬½ÓºÃ»¹ÊÇÔÚÿ¸öÏß³ÌÖж¼µ¥¶À´´½¨Ò»¸öÁ¬½ÓºÃ? <


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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

ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ

oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó

ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬

ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý ......

Çë½ÌÒ»¸ömysql triggerµÄÎÊÌâ

ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð»
ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿

ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öÊ²Ã´ÄØ


ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´Ómemcac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ