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

mysqlÈçºÎ°ÑÔÚÆÁÄ»ÉÏÊä³öµÄ½á¹ûÊä³öµ½Ò»¸öÎļþÉÏ£¿

show profile cpu, block io for query 15 µÄ½á¹ûÌ«´ó£¬Ò»ÆÁÄ»×°²»Ï£¬Ï뽫½á¹ûÊä³öµ½Ò»¸öÎļþÉÏÔÙ¿´£¡
ûÓÐʲôºÃ°ì·¨£¬mysql.exe ±¾ÉíûÓУϣңÁ£Ã£Ì£ÅÄÇÖÖspool µÄÃüÁî¡£Èç¹ûÊǣףɣģΣϣףӣ¬ÔòÔÚËüµÄÃüÁîÐй¤¾ßµÄÊôÐÔÖаѣ£գƣƣţÒÉèÖøßһЩ¡£

Èç¹ûÊǣգΣɣØÖ®ÀàµÄ£¬µ¹ÊÇ¿ÉÒÔÓÃһЩtelnet µÄ¹¤¾ß±¾ÉíÓмǼ¹¦ÄÜ¡£

Ö»ÓÐCOPY¡¢PASTE£¬Ã»Óа취

SQL code:
D:\>mysql -uroot -p -e "show profile cpu, block io for query 15" > e:\aa.txt
Enter password:

D:\>


linuxÏÂÒ²¿ÉÒÔÓÃÀàËÆÉÏÃæµÄshellÃüÁî·½·¨

ÈýÂ¥·½·¨²»´í£¬Ö±½ÓÖØ¶¨Ïò¡£

¿ÉÊÇÔÚÒ»¸ösessionÖÐÎÒ±ØÐëÏÈÖ´ÐÐ set profiling=1ºÍÎÒÒª²âÊÔµÄsql£¬Ö®ºó²ÅÄÜÖ´ÐÐshow profile cpu, block io for query 15

ǰ±ßµÄÁ½ÌõÓï¾äÒªÈçºÎÖ´ÐÐÄØ£¿

show profile cpu, block io for query 15 
ÔõôÓÃ

ѧϰÖÐ...

D:\>mysql -uroot -p -e "select * from test ; show profile cpu, block io for query 15" > e:\aa.txt

Äã¿ÉÒ԰Ѷà¸öÓï¾ä·Åµ½ÆäÖС£ËäÈ»²»·½±ã¡£

¿ÉÒÔ into outfile ô¡£¡£¡£ÎÒ¾­³£ÓÃoutfileµ¼³ö±íÀïij¸ö×ֶεIJéѯ½á¹û


ÒýÓÃ
D:\>mysql -uroot -p -e "select * from test ; show profile cpu, block io for query 15" > e:\aa.txt

Äã¿ÉÒ԰Ѷà¸öÓï¾ä·Åµ½ÆäÖС£ËäÈ»²»·½±ã¡£





ÈçÐèÒªÔĶÁ


Ïà¹ØÎÊ´ð£º

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ