[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
Ïà¹ØÎĵµ£º
¸ù¾ÝÄãµÄʹÓÃÄ¿µÄÎÒ¾õµÃÕâ¸öº¯ÊýÓÐÁ½·½ÃæµÄÓÃ;£º
·ÀÖ¹SQL Injection¹¥»÷£¬Ò²¾ÍÊÇÄã±ØÐëÑéÖ¤Óû§µÄÊäÈë
²Ù×÷Êý¾ÝµÄʱºò±ÜÃâ²»±ØÒªµÄ×Ö·ûµ¼Ö´íÎó
mysql_real_escape_string() º¯ÊýתÒå SQL Óï¾äÖÐʹÓõÄ×Ö·û´®ÖеÄÌØÊâ×Ö·û¡£
ÏÂÁÐ×Ö·ûÊÜÓ°Ï죺
\x00
\n
\r
\
'
"
\x1a
Èç¹û³É¹¦£¬Ôò¸Ãº¯Êý·µ»Ø±»×ªÒåµÄ×Ö·û´ ......
×î½üÕÛÌÚ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ÒѾ·¢²¼¼¸Ììʱ¼äÁË£¬Ò»Ð©ÐµÄÌØÐÔÌØ±ðÒýÈËעĿ£¬±ÈÈ磺 ÐÔÄܵÄÎȶ¨ºÍÌáÉý£¬±íÏÖÔÚWPF GUIºÍWPFÎı¾³ÊÏÖ¡£ Windows Azure ToolsÄ£°å¡£ ¶àÏÔʾÆ÷Ö§³Ö£¬Êä³ö´°¿Ú£¬Ààͼ´°¿Ú£¬´úÂ붨Òå´°¿ÚµÈÌṩ¸¨ÖúÐÅÏ¢µÄ´°¿Ú·ÅÖÃÔÚ¸±ÏÔʾÆ÷ÖС£ ¶Ô²¢ÐмÆË㿪·¢µÄ´óÁ¿Ö§³Ö¡£ °üº¬ÁËSharePointµÄÏîĿģ°åºÍµ÷ÊÔÖ§³Ö ......
[MySQLÓÅ»¯] -- ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:diesou
mysql µÄ sql ÐÔÄÜ·ÖÎöÆ÷Ö÷ÒªÓÃ;ÊÇÏÔʾ sql Ö´ÐеÄÕû¸ö¹ý³ÌÖи÷Ïî×ÊÔ´µÄʹÓÃÇé¿ö¡£·ÖÎöÆ÷¿ÉÒÔ¸üºÃµÄչʾ³ö²»Á¼ SQL µÄÐÔÄÜÎÊÌâËùÔÚ¡£ ÏÂÃæÎÒÃǾÙÀý½éÉÜһϠMySQL SQL Profiler µÄʹÓ÷½·¨£º Ê×ÏÈ£¬¿ªÆô MySQL SQL ......
[MySQLÓÅ»¯] -- ÈçºÎ²éÕÒSQLЧÂʵØÏµÄÔÒò
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chusong
²éѯµ½Ð§ÂÊµÍµÄ SQL Óï¾ä ºó£¬¿ÉÒÔͨ¹ý EXPLAIN »òÕß DESC ÃüÁî»ñÈ¡ MySQL ÈçºÎÖ´ÐÐ SELECT Óï¾äµÄÐÅÏ¢£¬°üÀ¨ÔÚ SELECT Óï¾äÖ´Ðйý³ÌÖбíÈçºÎÁ¬½ÓºÍÁ¬½ÓµÄ˳Ðò£¬±ÈÈçÎÒÃÇÏë¼ÆËã 2006 ÄêËùÓй«Ë¾µÄÏúÊ۶ÐèÒª¹ØÁª sales ......