mysql ÓÐûÓÐʲô·½·¨»òÕß¹¤¾ßÖªµÀµ±Ç°µÇ¼µÄÓû§
mysql ÓÐûÓÐʲô·½·¨»òÕß¹¤¾ß ÖªµÀµ±Ç°µÇ¼µÄÓû§ ÒÔ¼°Óû§ÔÚÒ»¶Îʱ¼ä×ö¹ýµÄactivity(like SQL query, insert/delete/update)?
ÆÕͨÈÕÖ¾ÖС£¿ÉÒÔ¿´µ½ÕâЩÐÅÏ¢¡£ »òÕßÖ±½Ó show processlist; ÁíÍâͼÐλ¯¹¤¾ß MySQL Administrator µÄ connection ÖÐÒ²¿ÉÒÔ¿´µ½¡£ µ±Ç°Ó¦Óüܹ¹ÊÇ website £« mysql websiteÀïÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄÓû§£¯ÃÜÂë Ö®ºó¶Ô±í½øÐвÙ×÷¡£ £¨Èç¹ûÒª¿´ Ö»ÄÜ¿´tomcatµÄÈÕÖ¾À£© WEB application ÓÉÓÚÄãµÄÁ¬½ÓÀ´Ô´¶¼ÊÇͬһÖ÷»ú£¬Í¬Ò»Óû§£¬ËùÒÔÔÚMYSQLÖÐÎÞ·¨Çø±ð¡£Ö»ÄÜÔÚÄãµÄWEB application ÖнøÐÐʶ±ð¡£ general_log_file general_log ¼ÇÔØÁËÄãµÇ¼ºó²éѯµÈ»ù±¾ÐÅÏ¢ mysqlÉèÖÿªÆôlogºóÄÜ¿´µ½ÒýÓà µ±Ç°Ó¦Óüܹ¹ÊÇ website £« mysql websiteÀïÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄÓû§£¯ÃÜÂë Ö®ºó¶Ô±í½øÐвÙ×÷¡£ £¨Èç¹ûÒª¿´ Ö»ÄÜ¿´tomcatµÄÈÕÖ¾À£© Èç¹ûµÇ½Óû§Ò»ÑùµÄ»°£¬ÄÇÄ㿼ÂÇÔÚ³ÌÐò¶Ë×÷´¦ÀíÁË
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂ𣿠ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡ ×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£ win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£ µ±È»Äã×î ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓᣠÊý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿ 1 nike 100 ϵͳʱ¼ä 2 nike 300 &n ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ÉÊÇÎÒÕÒ ......