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

[MySQLÓÅ»¯] ÈçºÎÁ˽âSQLµÄÖ´ÐÐÆµÂÊ


[MySQLÓÅ»¯] -- ÈçºÎÁ˽âSQLµÄÖ´ÐÐÆµÂÊ
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chuxu
MySQL ¿Í»§¶ËÁ¬½Ó³É¹¦ºó£¬Í¨¹ý show [session|global]status ÃüÁî ¿ÉÒÔÌṩ·þÎñÆ÷״̬ÐÅÏ¢£¬Ò²¿ÉÒÔÔÚ²Ù×÷ϵͳÉÏʹÓà mysqladmin extended-status ÃüÁî»ñµÃÕâЩÏûÏ¢¡£ show [session|global] status ¿ÉÒÔ¸ù¾ÝÐèÒª¼ÓÉϲÎÊý“ session ”»òÕß“ global ”À´ÏÔʾ session ...
MySQL ¿Í»§¶ËÁ¬½Ó³É¹¦ºó£¬Í¨¹ý show [session|global]status ÃüÁî ¿ÉÒÔÌṩ·þÎñÆ÷״̬ÐÅÏ¢£¬Ò²¿ÉÒÔÔÚ²Ù×÷ϵͳÉÏʹÓà mysqladmin extended-status ÃüÁî»ñµÃÕâЩÏûÏ¢¡£ 
    show [session|global] status ¿ÉÒÔ¸ù¾ÝÐèÒª¼ÓÉϲÎÊý“ session ”»òÕß“ global ”À´ÏÔʾ session ¼¶£¨µ±Ç°Á¬½Ó£©µÄͳ¼Æ½á¹ûºÍ global ¼¶£¨×ÔÊý¾Ý¿âÉÏ´ÎÆô¶¯ÖÁ½ñ£©µÄͳ¼Æ½á¹û¡£Èç¹û²»Ð´£¬Ä¬ÈÏʹÓòÎÊýÊÇ“ session ”¡£ 
    Com_xxx ±íʾÿ¸ö xxx Óï¾äÖ´ÐеĴÎÊý£¬ÎÒÃÇͨ³£±È½Ï¹ØÐĵÄÊÇÒÔϼ¸¸öͳ¼Æ²ÎÊý £º 
Com_delete £ºÖ´ÐÐ DELETE ²Ù×÷µÄ´ÎÊý¡£
    ÖªµÀÁËÕâЩÐÅÏ¢¾Í·½±ãÎÒÃÇÈ·¶¨ÎÒÃǵ½µ×ÐèҪʲôÑùµÄ´æ´¢ÒýÇæÁË£¬Ò»°ãÀ´Ëµupdate½Ï¶àµÄʱºò Innodb ÒýÇæÐ§ÂÊ»áÉÔ΢¸ßһЩ£¡
    ÉÏÃæÕâЩ²ÎÊý¶ÔÓÚËùÓд洢ÒýÇæµÄ±í²Ù×÷¶¼»á½øÐÐÀۼơ£ÏÂÃæÕ⼸¸ö²ÎÊýÖ»ÊÇÕë¶Ô InnoDB ´æ´¢ÒýÇæµÄ£¬ÀÛ ¼ÓµÄËã·¨Ò²ÂÔÓв»Í¬£º 
Innodb_rows_deleted £ºÖ´ÐÐ DELETE ²Ù×÷ɾ³ýµÄÐÐÊý¡£
    ͨ¹ýÒÔÉϼ¸¸ö²ÎÊý£¬¿ÉÒÔºÜÈÝÒ×µØÁ˽⵱ǰÊý¾Ý¿âµÄÓ¦ÓÃÊÇÒÔ²åÈë¸üÐÂΪÖ÷»¹ÊÇÒÔ²éѯ²Ù×÷ΪÖ÷£¬ÒÔ¼°¸÷ÖÖÀàÐ굀 SQL ´óÖµÄÖ´ÐбÈÀýÊǶàÉÙ¡£¶ÔÓÚ¸üвÙ×÷µÄ¼ÆÊý£¬ÊǶÔÖ´ÐдÎÊýµÄ¼ÆÊý£¬²»ÂÛÌá½»»¹Êǻعö¶¼»á½øÐÐÀÛ¼Ó¡£ 
    ¶ÔÓÚÊÂÎñÐ͵ÄÓ¦Óã¬Í¨¹ý Com_commit ºÍ Com_rollback ¿É ÒÔÁ˽âÊÂÎñÌá½»ºÍ»Ø¹öµÄÇé¿ö£¬¶ÔÓڻعö²Ù×÷·Ç³£Æµ·±µÄÊý¾Ý¿â£¬¿ÉÄÜÒâζ×ÅÓ¦Óñàд´æÔÚÎÊÌâ¡£ 
    ´ËÍ⣬ÒÔϼ¸¸ö²ÎÊý±ãÓÚÎÒÃÇÁ˽âÊý¾Ý¿âµÄ»ù±¾Çé¿ö£º 
Slow_queries £º Âý²éѯµÄ´ÎÊý¡£
http://blog.chinaunix.net/u3/93470/showart_2001435.html


Ïà¹ØÎĵµ£º

Geoserver+MYSQLÊý¾ÝÅäÖã¬openlayerÔ¤ÀÀͼ²ãÒì³£

×î½üÕÛÌÚGeoServerÓëMysqlµÄÁ¬½Ó£¬ÊÔÁ˲»ÉÙʱ¼ä£¬³öÏÖÁ˼¸¸öÎÊÌâ
   1 ·¢²¼µÄ»ùÓÚmysqlÊý¾Ý¿âLayer£¬ÔÚÔ¤ÀÀʱʧ°Ü
   Ïà¹Ø°æ±¾ÈçÏ£º
  Gerserver 2.0.1
  Mysql 5.5.1
  mysql-connector-java-5.1.5.jar
  gt-mysql-2.6.0.jar
  ºó³¢ÊÔÌæ»»MysqlÊý¾Ý¿â°æ±¾Îª5.0 ......

LinuxÏÂApache 2.2, MySQL 5.0ºÍPHP 5.0µÄ°²×°ÓëÅäÖÃ

¡¾×ª¡¿http://www.linuxsir.org/main/?q=node/241
1.°²×°»·¾³
²Ù×÷ϵͳ£ºRed Hat Linux Enterprise AS 4.0
Êý¾Ý¿â£ºMySQL 5.0.24
Web·þÎñÆ÷£ºApache 2.2.3
½Å±¾ÓïÑÔ£ºPHP 5.1.6
2.°²×°MySQL 5.0.24
-------------ÏÂÔØÈí¼þ°ümysql-5.0.24.tar.gz£¬µØÖ·http://www.mysql.com-------------
# tar zvxf mysql-5.0.24.ta ......

VC ³ÌÐòÖÐÈçºÎÓÃADOÁ¬½ÓSQL Server 2005?

Ê×ÏÈ˵Ã÷Ò»µã£ºVC³ÌÐòÖÐÓÃADOÁ¬½ÓSQL Server 2005 ºÍÁ¬½Ó SQL Server 2000µÄÓï¾äºÍÁ¬½Ó×Ö·û´®ÊÇÍêȫһÑùµÄ£¬ÏÂÃæµÄ´úÂëÊÊÓÃÓÚÁ½¸öÊý¾Ý¿âµÄÁ¬½Ó¡£
ÁíÒ»µã˵Ã÷£ºÈç¹ûÄãÒÔǰ°²×°¹ýSQL Server 2000£¬ºóÔÚûÓÐÐ¶ÔØµÄÇé¿öÏÂÓÖ°²×°ÁË2005£¬ÄÇôÄã֮ǰÔÚ2000ÖÐÉèÖõÄÓû§ÃûºÍÃÜÂëÔÚ2005Öлᱣ³Ö£¬¼´Ê¹Äã°²×°2005ʱδÉèÖÃÈκÎÓû§Ãû ......

SQL Ñ­»·

declare @i int
set @i=1
while @i<30
begin
insert into test (userid) values(@i)
set @i=@i+1
end
---------------
while Ìõ¼þ
begin
Ö´ÐвÙ×÷
set @i=@i+1
end
WHILE
ÉèÖÃÖØ¸´Ö´ÐÐ SQL Óï¾ä»òÓï¾ä¿éµÄÌõ¼þ¡£Ö»ÒªÖ¸¶¨µÄÌõ¼þÎªÕæ£¬¾ÍÖØ¸´Ö´ÐÐÓï¾ä¡£¿ÉÒÔʹÓà BREAK ºÍ CONTINUE ¹Ø¼ü×ÖÔÚÑ­»·ÄÚ²¿¿ØÖÆ W ......

[MySQLÓÅ»¯] ÈçºÎ¶¨Î»Ð§Âʽϵ͵ÄSQL


[MySQLÓÅ»¯] -- ÈçºÎ¶¨Î»Ð§Âʽϵ͵ÄSQL
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:zhenpao
Ò»°ãͨ¹ýÒÔÏÂÁ½ÖÖ·½Ê½¶¨Î»Ö´ÐÐЧÂÊ½ÏµÍµÄ SQL Óï¾ä¡£ Âý²éѯÈÕÖ¾ÔÚ²éѯ½áÊøÒÔºó²Å¼Í¼£¬ËùÒÔÔÚÓ¦Ó÷´Ó³Ö´ÐÐЧÂʳöÏÖÎÊÌâµÄʱºò²éѯÂý²éѯÈÕÖ¾²¢²»Äܶ¨Î»ÎÊÌ⣬¿ÉÒÔʹÓà show processlist ÃüÁî²é¿´µ±Ç° MySQL ÔÚ½øÐеÄỊ̈߳¬° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ