Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

PHPÖеÄmysql_real_escape_stringº¯Êý

¸ù¾ÝÄãµÄʹÓÃÄ¿µÄÎÒ¾õµÃÕâ¸öº¯ÊýÓÐÁ½·½ÃæµÄÓÃ;£º
·ÀÖ¹SQL Injection¹¥»÷£¬Ò²¾ÍÊÇÄã±ØÐëÑéÖ¤Óû§µÄÊäÈë
²Ù×÷Êý¾ÝµÄʱºò±ÜÃâ²»±ØÒªµÄ×Ö·ûµ¼Ö´íÎó
mysql_real_escape_string() º¯ÊýתÒå SQL Óï¾äÖÐʹÓõÄ×Ö·û´®ÖеÄÌØÊâ×Ö·û¡£
ÏÂÁÐ×Ö·ûÊÜÓ°Ï죺
\x00
\n
\r
\
'
"
\x1a
Èç¹û³É¹¦£¬Ôò¸Ãº¯Êý·µ»Ø±»×ªÒåµÄ×Ö·û´ ......

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 ......

VS2010Öд´½¨×Ô¶¨ÒåSQL Rule£¨ºÂÏÜç⣩

VS2010ÒѾ­·¢²¼¼¸Ììʱ¼äÁË£¬Ò»Ð©ÐµÄÌØÐÔÌØ±ðÒýÈËעĿ£¬±ÈÈ磺 ÐÔÄܵÄÎȶ¨ºÍÌáÉý£¬±íÏÖÔÚWPF GUIºÍWPFÎı¾³ÊÏÖ¡£ Windows Azure ToolsÄ£°å¡£ ¶àÏÔʾÆ÷Ö§³Ö£¬Êä³ö´°¿Ú£¬Ààͼ´°¿Ú£¬´úÂ붨Òå´°¿ÚµÈÌṩ¸¨ÖúÐÅÏ¢µÄ´°¿Ú·ÅÖÃÔÚ¸±ÏÔʾÆ÷ÖС£ ¶Ô²¢ÐмÆË㿪·¢µÄ´óÁ¿Ö§³Ö¡£ °üº¬ÁËSharePointµÄÏîĿģ°åºÍµ÷ÊÔÖ§³Ö ......

[MySQLÓÅ»¯] ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷


[MySQLÓÅ»¯] -- ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:diesou
mysql µÄ sql ÐÔÄÜ·ÖÎöÆ÷Ö÷ÒªÓÃ;ÊÇÏÔʾ sql Ö´ÐеÄÕû¸ö¹ý³ÌÖи÷Ïî×ÊÔ´µÄʹÓÃÇé¿ö¡£·ÖÎöÆ÷¿ÉÒÔ¸üºÃµÄչʾ³ö²»Á¼ SQL µÄÐÔÄÜÎÊÌâËùÔÚ¡£ ÏÂÃæÎÒÃǾÙÀý½éÉÜһϠMySQL SQL Profiler µÄʹÓ÷½·¨£º Ê×ÏÈ£¬¿ªÆô MySQL SQL ......

[MySQLÓÅ»¯] ÈçºÎ²éÕÒSQLЧÂʵØÏµÄÔ­Òò


[MySQLÓÅ»¯] -- ÈçºÎ²éÕÒSQLЧÂʵØÏµÄÔ­Òò
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chusong
²éѯµ½Ð§ÂÊµÍµÄ SQL Óï¾ä ºó£¬¿ÉÒÔͨ¹ý EXPLAIN »òÕß DESC ÃüÁî»ñÈ¡ MySQL ÈçºÎÖ´ÐÐ SELECT Óï¾äµÄÐÅÏ¢£¬°üÀ¨ÔÚ SELECT Óï¾äÖ´Ðйý³ÌÖбíÈçºÎÁ¬½ÓºÍÁ¬½ÓµÄ˳Ðò£¬±ÈÈçÎÒÃÇÏë¼ÆËã 2006 ÄêËùÓй«Ë¾µÄÏúÊ۶ÐèÒª¹ØÁª sales ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ