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


Ïà¹ØÎĵµ£º

Mysql֪ʶµã×ܽ᣺Flush privileges

mysql> flush privileges;ʲôÒâ˼£¿­
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';­
mysql> flush privileges;­
mysql> quit­
´ð:­
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......

mysql ͼÐιÜÀí¹¤¾ß

myphpadmin¹¦ÄÜËäÈ»ÒѾ­ºÜÇ¿£¬µ«Óû§ÌåÑé·½Ãæ²¢²»ºÜºÃ¡£
SQLyog
Mysql-front
EMS MySQL Manager
Mysqlcc
Navicat for MySQL
mysql-gui-tools
MySQL ͼÐι¤¾ß½éÉÜ£¨×ªÔØ£©
1¡¢Navicat
NavicatÊÇÒ»¸öÇ¿´óµÄMySQLÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢¹¤¾ß¡£Navicatµ¼º½Îª×¨Òµ¿ª·¢ÕßÌṩÁËÒ»Ì×Ç¿´óµÄ×ã¹»¼â¶ËµÄ¹¤¾ß£¬µ«Ëü¶ÔÓÚÐÂÓû§ÈÔÈ» ......

C# ²Ù×÷MySQLÊý¾Ý¿âµÄ¼òµ¥Àý×Ó

ʾÀýÑÝʾÁËÓÃC#²Ù×÷MySQLµÄ·½·¨£¬ÌṩÁËÈý¸ö¿ÉÖØÓõÄÀàMySqlDBUtil,MySqlPageUtil,Page¡£
±¾Ê¾ÀýÓÉ C#²Ù×÷AccessÊý¾Ý¿âµÄ¼òµ¥Àý×Ó£¨http://www.albertsong.com/read-56.html£©Ð޸ĶøÀ´¡£
1.Ê×ÏÈÏÂÔØMySQLÊý¾Ý¿âµÄ.NETÇý¶¯
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.8.1-noinstall.zip/ ......

mysqlÖÐÓÃÃüÁîÐи´ÖƱí½á¹¹µÄ·½·¨

1.Ö»¸´ÖƱí½á¹¹µ½Ð±í
CREATE TABLE бí SELECT * from ¾É±í WHERE 1=2
»òCREATE TABLE бí LIKE ¾É±í
2.¸´ÖƱí½á¹¹¼°Êý¾Ýµ½Ð±í
CREATE TABLE бí SELECT * from ¾É±í
3.¸´ÖƾɱíµÄÊý¾Ýµ½Ð±í(¼ÙÉèÁ½¸ö±í½á¹¹Ò»Ñù)
INSERT INTO бí SELECT * from ¾É±í
4.¸´ÖƾɱíµÄÊý¾Ýµ½Ð±í(¼ÙÉèÁ½¸ö±í½á¹¹²»Ò»Ñù)
......

ÈçºÎÒÆÖµ£¨»Ö¸´¡¢»¹Ô­£©MysqlÖеÄinnoDBµÄÊý¾Ý¿â¡£

½ñÌì¸ãÁËÒ»Ì죬ÖÕÓڸ㶨ÁË¡£
¶ÔÓÚMysqlÓÐÁ½ÖÖģʽ£¬MYISAMÓëINNODB
Èç¹ûÊÇMYISAMµÄ»°£¬ÔÚdataĿ¼ÏÂÀï»á.frm .myd .myi ÈýÖÖÎļþ£¬ÄÇôֱ½Ó°ÑDATAÒÆ¹ýÈ¥£¬ÅäÖúÃȨÏ޾ͿÉÒÔ»¹Ô­ÁË¡£
Èç¹ûÊÇINNODBµÄ»°£¬ÄÇÊÇÏ൱µÄ·³°¡¡£ÔÚdataĿ¼ÏÂÖ»ÓÐ.frm(ÕâÖ»ÊÇÒ»¸öÊý¾Ý¸ñʽ£©£¬Õâ¸öÒÆ¹ýÈ¥ºó£¬ÊÇÎÞ·¨»¹Ô­Ô­Ê¼Êý¾ÝµÄ¡£
ÕæÕýµÄÊý¾ÝÊÇÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ