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

mysql Êý¾Ý¿â´óС

information_schema¿âÖаüº¬Á˶ÔÕû¸öÊý¾Ý¿âµÄºÜ¶àͳ¼ÆÐÅÏ¢£¬¿ÉÒÔͨ¹ý²é¿´ËüÃÇ£¬À´µÃµ½Êý¾Ý¿âÏà¹ØµÄÐÅÏ¢¡£
mysql> use information_schema;
Database changed
mysql> select count(1) as tables, concat(round(sum(table_rows)/1000000,2),'M') as rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') as data, concat(round(sum(index_length)/(1024*1024*1024),2),'G') as idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') as total_size,round(sum(index_length)/sum(data_length),2) as idxfrac from tables;
+--------+--------+--------+-------+------------+---------+
| tables | rows   | data   | idx   | total_size | idxfrac |
+--------+--------+--------+-------+------------+---------+
|    719 | 96.41M | 30.17G | 9.63G | 39.80G     |    0.32 |
+--------+--------+--------+-------+------------+---------+
1 row in set (1 min 9.64 sec)


Ïà¹ØÎĵµ£º

Navicat for MySQLÓëMySQL GUI Tools±È½Ï

ǰÑÔ
¡¡¡¡MySQL GUI¹¤¾ßºÜ¶à£¬±¾Îľͳ£ÓõÄNavicat for MySQLÓëMySQL GUI ToolsµÄÌØÉ«¹¦ÄÜ×öÒ»¸öÏêϸ½éÉÜÓë±È½Ï¡£
¡¡¡¡£¨Ò»£©MySQL GUI Tools
¡¡¡¡MySQL¹Ù·½ÌṩµÄÒ»¸ö¿ÉÊÓ»¯½çÃæµÄMySQLÊý¾Ý¿â¹ÜÀí¿ØÖÆÌ¨£¬ÌṩÁËËĸöͼÐλ¯Ó¦ÓóÌÐò£¬ÕâЩͼÐλ¯¹ÜÀí¹¤¾ß¿ÉÒÔ´ó´óÌá¸ßÊý¾Ý¿â¹ÜÀí¡¢±¸·Ý¡¢Ç¨ÒƺͲéѯЧÂÊ¡£ËüÃÇ·Ö±ðÊÇ£º ......

¹ØÓÚMySQL¶þ½øÖÆÈÕÖ¾BinlogµÄÈÏʶ

MySQLµÄ¶þ½øÖÆÈÕÖ¾¿ÉÒÔ˵»òÊÇMySQL×îÖØÒªµÄÈÕÖ¾ÁË,Ëü¼Ç¼ÁËËùÓеÄDDLºÍDML(³ýÁËÊý¾Ý²éѯÓï¾ä)Óï¾ä,ÒÔʼþÐÎʽ¼Ç¼,»¹°üº¬Óï¾äËùÖ´ÐеÄÏûºÄµÄʱ¼ä,MySQLµÄ¶þ½øÖÆÈÕÖ¾ÊÇʧÎó°²È«Ð͵Ä.
ÔÚ5.1µÄ°æ±¾Äã¶þ½øÖÆÈÕÖ¾»¹Ìæ´úÁËÔ­±¾µÄ¸üÐÂÈÕÖ¾.Ò»°ãÀ´Ëµ¿ªÆô¶þ½øÖÆÈÕÖ¾´ó¸Å»áÓÐ1%µÄÐÔÄÜËðºÄ(²Î¼ûMySQL¹Ù·½ÖÐÎÄÊÖ²á5.1.24°æ).¶þ½øÖÆÓÐÁ½ ......

MySQL showµÄÓ÷¨

a. show tables»òshow tables from database_name; // ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
   b. show databases; // ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
   c. show columns from table_name from database_name; »òshow columns from database_name.table_name;   // ÏÔʾ±íÖÐÁÐÃû³Æ
   ......

¹ØÓÚhibernateÅäÖÃc3p0Á¬½Ó³ØÁ¬½ÓmysqlÎÊÌâ

ǰЩÌì¿´ÁËÀî¸Õ<struts2+hibernate+spring>ÄÇÊéÉϵÄhibernate£¬ÅäÖÃÎļþÒ²Êǰ´ÕÕÉÏÃæÇýøhibernate.cfg.xmlÎļþµÄ£¬Student.javaÅäÖõÄStudent.hbm.xmlÎļþ¾õµÃҲûʲôÎÊÌ⣬µ«²»Öªµ½Ôõô»ØÊ¾ÍÊDZ¨ connection can not open¡£ÓôÃÆ°¡£¬ºóÀ´ÎҾͰÑÊéÀïÃæµÄÅäÖÃÎļþºÍÔ´Â룬¸´ÖƵ½MyEclipseÏÂÃæµÄÒ»¸öÐÂwebÏîÄ¿ÖУ¬ÔËÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ