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

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µÄÈÕÖ¾À­£©


Èç¹ûµÇ½Óû§Ò»ÑùµÄ»°£¬ÄÇÄ㿼ÂÇÔÚ³ÌÐò¶Ë×÷´¦ÀíÁË


Ïà¹ØÎÊ´ð£º

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

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

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

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

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

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 ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

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.
¿ÉÊÇÎÒÕÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ