ËÄÜÌṩϹØÓÚinnodb±¸·Ý¹¤¾ßxtrabackupÔÚwindowϵı¸·ÝÓ뻹ԵÄÑùÀý£¬
СµÜÅöµ½ÎÊÌâÊÇÕâÑùµÄ£¬¿ÉÒԳɹ¦±¸·Ý£¬Ò²¿ÉÒÔÖ¸¶¨±í±¸·Ý£¬
1¡¢¹ØÓÚ¶à±í±¸·ÝÔõôʵÏÖ£¿
2¡¢±¸·Ý³öÀ´ºóÖ»ÓÐÊý¾ÝÎļþidb£¬£¨Í¨¹ýÐÞ¸ÄÅäÖÃÎļþÖвÎÊý£¬ÒÑÈø÷±íµÄÊý¾ÝÎļþ¶ÀÁ¢´æÔÚ£©£¬Ã»Óбí½á¹¹£¬Ôõô°ì£¿ÒòΪÔÀ´µÄÊý¾Ý¿âµÄ±íÐèÒª±»Ïú»Ù¡£
3¡¢Èç¹û ......
´ó¼ÒÏÖÔÚÓõÄmysql°æ±¾¶¼ÊÇ Äĸö£¿ ±È½ÏÎȶ¨µÄ£¿
SQL code:
mysql> select @@version;
+----------------------+
| @@version |
+----------------------+
| 5.1.37-community-log |
+----------------------+
http://dev.mysql.com/downloads/
mysql 5.1.42
5.0Óë5.1ÔÚÓÅ»¯ÉÏÓÐÊ²Ã´Ç ......
ÎÒµÄtomacatÒ»Æô¶¯¾Í±¨Õâ¸ö´íÎó¡£²»ÖªµÀΪʲô£¿
ÓÃnavicat ¾ÍÁ¬½Ó²»ÉÏÁË¡£
ÊÇmysqlµÄÁ¬½ÓÓÐÎÊÌ⣡ÄãtomcatÏÂÊDz»ÊÇÓкܶàµÄÏîÄ¿ÄØ£¿ÊDz»ÊÇijһ¸öÏîÄ¿³öÏÖÁËÕâ¸öÎÊÌ⣡×ÐϸÕÒһϰɣ¡
ÐÞ¸ÄÒ»ÏÂÅäÖÃÎļþ
ÄãµÄ³ÌÐòÔÚ·þÎñÆ÷Æô¶¯Ê±Õ¼ÓÃÁËÌ«¶àÁ¬½Ó¡£Äã¼ì²éÏÂÄãµÄ´úÂ룬ÊÇ·ñÓеط½Ñ»·µØ´´½¨ÁËÁ¬½Ó¡£Õâ¸öÎÊÌâÓ¦¸ÃÊÇ ......
mysql> show global status like 'Qcache_hits';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Qcache_hits | 0 |
+---------------+-------+
1 row in set (0.03 sec)
mysql> show global status like 'Com_select ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔõôÀ´ÊµÏÖÄØ£¿
(ÓÃmysqlµÄapi£¿ËÓÃC++µÄ£¬ÄÜÌṩµãÀý×Ó×îºÃÁË)
ר¼Ò ¸ßÊÖ ÓÐ×öµÄ ÅóÓÑÃÇ Ö¸µãÏÂ
ht ......
ÎÒ¿ÉÄÜÊÇÓùßÁË ms sql µÄÄǸö profiler, ÏÖÔÚÏ뿪ʼ¼à²âһϠmysql ¿Í»§¶ËµÄËùÓз¢¹ýÀ´µÄquery¡£ ÓÚÊÇÍøÉÏ¿ªÊ¼ÕÒÁËһЩ£¬
²»¹ý¼òÖ±¶¼Ì«²î¾¢ÁË£¬²»¹âÄÑÓ㬻ù±¾É϶¼²»ÄÜʵʱµÄ¼ì²âµ½¿â»§¶Ë·¢¹ýÀ´µÄÓï¾ä¡£ ÄÄλ֪²»ÖªµÀÓкÃÒ»µãµÄ£¬
°¥Ñ½£¬ÏÖÔÚ¶¼²»ÇóºÃ²»ºÃÓÃÁË£¬ËÄÜ·ÖÏí¸öÄÜʵʱ¼à²âµ½¿Í»§¶Ë·¢¹ýÀ´µÄËùÓÐ Query ......