MYSQL¼¼ÊõÎÊÌ⣬½â¾ö¼´¸¶200Ôª
ÎҵķþÎñÆ÷¹¹¼Ü£ºÁ½Ì¨¶ÀÁ¢·þÎñÆ÷£¬Ò»Ì¨ÓÃÓÚweb£¨php£©£¬Áíһ̨MYSQLÊý¾Ý¿âרÓ㬶¼ÊÇwin2003+IIS6.0£¬ÔÚͬһ¸ö¾ÖÓòÍøÄÚ£¬IPµØÖ··Ö±ðΪ£º'**.**.**.58'ºÍ'**.**.**.62'¡£
MYSQLÊý¾Ý¿â´æÔÚÒÔÏÂÁ½¸öÎÊÌ⣺
1¡¢Èç¹ûÎÒÔ¶³Ì×ÀÃæÁ¬½Óµ½Êý¾Ý¿â·þÎñÆ÷£¨3389¶Ë¿Ú£©£¬web·þÎñÆ÷¾Í»áÁ¬²»ÉÏMYSQLÊý¾Ý¿â£¬´íÎóÐÅÏ¢£ºCan't connect to MySQL server on '**.**.**.62' (10060)
2¡¢ÍøÕ¾¾³£³öÏÖ´íÎóÐÅÏ¢£ºCan't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
¿ÉÒÔÈ·Èϲ»ÊÇMYSQL·þÎñÆ÷×ÊÔ´ÎÊÌ⣬·þÎñÆ÷CPU¸ººÉÒ»°ãÔÚ15%×óÓÒ£¬ÄÚ´æ2GµÄ£¬Õ¼ÓÃÔÚ800M×óÓÒ¡£
Çó¸ßÊÖ°ï½â¾ö´ËÎÊÌ⣬Äܽâ¾öÕß¼´¸¶200Ôª³êÀÍ£¬A5Öн齻Ò×£¬¿É·ÅÐı£Ö¤£¨http://bbs.admin5.com/viewthread.php?tid=1394836 £©¡£
×¢£ºÇëÔÚÏß¼ÓQQ:17321454£¨²»ÔÚÏßʱÇë·¢Óʼþµ½QQÓÊÏ䣺17321454@qq.com)£¬ÓÉÄãÀ´Ö¸»Ó£¬ÎÒÀ´²Ù×÷£¬Ë¡²»ÄܸøMYSQLÕʺÅÃÜÂ룬ÎÊÌâ2±ØÐë±£Ö¤24СʱÄÚ²»³öÏÖ¡£
C:\Users\coolwind>perror 10060
Win32 error code 10060: ÓÉÓÚÁ¬½Ó·½ÔÚÒ»¶Îʱ¼äºóûÓÐÕýÈ·´ð¸´»òÁ¬½ÓµÄÖ÷»úûÓз´Ó¦£¬
Á¬½Ó³¢ÊÔʧ°Ü¡£
C:\Users\coolwind>perror 12
OS error code 12: Not enough space
Win32 error code 12: ·ÃÎÊÂëÎÞЧ¡£
1¡¢Èç¹ûÎÒÔ¶³Ì×ÀÃæÁ¬½Óµ½Êý¾Ý¿â·þÎñÆ÷£¨3389¶Ë¿Ú£©£¬web·þÎñÆ÷¾Í»áÁ¬²»ÉÏMYSQLÊý¾Ý¿â£¬´íÎóÐÅÏ¢£ºCan't connect to MySQL server on '**.**.**.62' (1006
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......