ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇûÓдíµÄ¡£
³ö´íºóÎÒÔÚÊý¾Ý¿âÀï¿´insertÁ˶àÉÙÊý¾Ý£¬´ó¶àÊýÔÚ:75-93Ìõ×óÓÒ.
ÇëÎÊÕâÊÇΪʲô£¿
& ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
Çл»µ½´ËĿ¼
mysqld.exe --defaults-file=..\my.ini --console
Æô¶¯ mysql·þÎñ½ø³Ì
......
Ò»¿ªÊ¼½¨Á˸öÊý¾Ý¿â ftp,ÀïÃæÓÐÕűí user,
root ÊÚȨ Óû§ vhost ¿ÉÒÔ²éѯÕâÕűí.
SQL code:
GRANT select ON ftp.user TO 'vhost'@'localhost' identified by PASSWORD('xx');
Ë¢ÐÂÊÚȨ
SQL code:
flush privileges;
²âÊÔok.
È»ºó ÎÒÔÚphpmyadmin ÀïÃæÉ¾µôÁËÕâ¸öÊý¾Ý¿â. ......
ÓÖÊÇÊý¾Ý¿âÎÊÌ⣬±¯°§---ËÍÆ¼öµãÊý¾Ý¿â×ÊÁÏ£¿
mysql¸ÄµôÃÜÂëºóÖØÆômysql·ÃÎÊÍøÕ¾Ã»ÎÊÌâÁË---²»¹ý½ñÌìÈ´·¢ÏÖÍøÕ¾ÂÛ̳¿ÉÒԵǽ£¬µ«ÊÇÌá½»×¢²áÐÅÏ¢µÄ»°[img=C:\Documents and Settings\Administrator\×ÀÃæ\ÔÓͼ\δÃüÃû.jpg][/img].¶øÇҵǽºó·¢²¼µÄÐÅÏ¢Ó¦¸ÃÒ²ÊÇû´æµ½Êý¾Ý¿â---ÒòΪËüËäÈ»ÌáʾÐÅÏ¢·¢²¼³É¹¦£¬ ......
±íµÄ½á¹¹ÊÇ
ÈÕÆÚ ºÅÂë ½ð¶î ״̬
2009-11-23 9874 1000 0
ÐèÒª´Ó± ......
MySQlÔõô֪µÀÊý¾Ý¿â·þÎñÆ÷µÄÇé¿öÐÅÏ¢?
·þÎñÆ÷cpu Õ¼ÓÐÂÊ
·þÎñÆ÷ÄÚ´æ Õ¼ÓÐÂÊ
SQL code:
SHOW PROCESSLIST;
ÒýÓ÷þÎñÆ÷cpu Õ¼ÓÐÂÊ
·þÎñÆ÷ÄÚ´æ Õ¼ÓÐÂÊ
ÕâÁ½¸ö¶¼ÊDzÙ×÷ϵͳµÄ£¬²»ÊÇMYSQLµÄ¡£ÎÞ·¨Ö±½ÓÔÚMYSQLÖеõ½¡£
......