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

mysql´æ´¢¹ý³ÌÊý¾ÝÒýÆðµÄËÀÑ­»·ÈçºÎ¶¨Î»

ÔÚÒ»¸öÏîÄ¿ÖдæÔÚ15¸ö×óÓҵĿÉÄÜÒýÆðËÀÑ­»·µÄ´æ´¢¹ý³Ì£¨²»ÊÇ´æ´¢¹ý³Ì±¾ÉíµÄ´úÂëÂß¼­ÓÐÎÊÌ⣬¶¼ÊÇÔàÊý¾ÝÒýÆðµÄ£©£¬·¢ÉúÕâÖÖÇé¿öµÄʱºò£¬·þÎñÆ÷µÄCPUµÄʹÓÃÇé¿ö¾Í200%ÁË£¬ÄÄλ¸øÖ¸µãÏ£¬ÓÐʲô¹¤¾ß»òÓÃʲô·½·¨¿ÉÒÔ¶¨Î»ÕâÑùµÄÇé¿öÊÇÄÄÒ»¸ö´æ´¢¹ý³ÌÒýÆðµÄ£¬Ð»Ð»£¡
´æ´¢¹ý³Ì¶àÂ𣿠¼¸Ê®¸ö»¹ÊǼ¸°Ù¸ö£¿

ûʲôºÃ°ì·¨£¬Ò»°ãÊÇÏÈ show processlist ¿´Ò»Ï¡£

²»¶à£¬µ±Ç°40À´¸ö£¬¿ÉÄÜÒýÆðÎÊÌâµÄÓÐ15¸ö×óÓÒ£¬Ò»³öÎÊÌâÎÒÖ»ÓаÑÊý¾Ý¿â·þÎñÏÈÍ£ÁË£¬ÔÙÖØÆô£¬ÀÏÕâÑùÎÒ¾õµÃ²»Êǰ취£¬ËùÒÔÏ붨λϾßÌåÊÇÄĸöÒýÆðµÄ

ÒýÓÃ
ûʲôºÃ°ì·¨£¬Ò»°ãÊÇÏÈ show processlist ¿´Ò»Ï¡£

show processlist
info?

Óй¦·òµÄ»°Ò»¸öÒ»¸öµÄÅÜÏ  ¿´ÄĸöÓÐÎÊÌâ ¾ÍÕûÄĸö....

´æ´¢¹ý³ÌÀïÃæ¼Ó¡®Êä³ö¡¯¡£
¡®Êä³ö¡¯¿ÉÒÔÊÇдд±í»òÕß¼ÆÊý¡£


Ïà¹ØÎÊ´ð£º

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ