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)
Ïà¹ØÎĵµ£º
ĬÈÏÇé¿öÏÂLinuxÄÚµÄmysqlÊý¾Ý¿âmysql£¬user±íÄÚµÄÓû§È¨ÏÞÖ»ÊǶÔlocalhost¼´±¾»ú²ÅÄܵǽ¡£ÐèÒª¸ü¸ÄȨÏÞ£º
Èçϵķ½Ê½È·ÈÏ£º
root#mysql -h localhost-u mysql -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connectio ......
mysql Ŀ¼Ï嵀 my.ini ÓÐÁ½´¦ÒªÐÞ¸Ä Ò»´¦ÊÇ [mysql] default-character-set=gbk »¹ÓÐÒ»´¦ÊÇ·ñÈϽ¨±íʱʹÓõÄ×Ö·û¼¯ default-character-set=gbk Á½´¦ÐÞ¸Äһϣ¬ÖØÐ½¨Á¢Êý¾Ý¿âºÍ±íºó¾Í²»»á³öÏÖÂÒÂëÁË¡£ ½¨±íʱҲ¿ÉÒÔÖ¸¶¨Êý¾Ý¿â»ò±íËùʹÓõÄ×Ö·û¼¯ Èç¹û²»ÄÜÖØ½¨Êý¾Ý¿âÔòÖ»ÄÜÔÚÖ¸¶¨µÄÊý¾Ý¿âĿ¼Ï°ѶÔÓ¦µÄ db.opt À ......
ÔÚDOSÖнøÐÐMySQLµÄ·ÃÎÊ¿ÉÄÜÂÒÂëµÄÇé¿öÓÐÈýÖÖ£¬
Ê×ÏÈ£¬Òª×öµÄÊǼì²éMySQLµÄÅäÖ㬰²×°µÄʱºòÑ¡Ôñutf-8µÄÓïÑÔ»·¾³»áʡȥºÜ¶àµÄÂé·³
1. ¼ì²éMySQLµÄ·þÎñ¶Ë¡¢¿Í»§¶ËµÄÓïÑÔÉèÖÃÊÇ·ñΪ“utf8”£¬²»ÊǵϰÊÖ¶¯½«my.int¸ü¸Ä¹ýÀ´£»
2. ÔÚPHP½øÐеÚÒ»´Îmysql_query֮ǰÉèÖÃʹÓÃÁ¬½ÓµÄ×Ö·û¼¯Îª"SET N ......
½ñÌì¸ãÁËÒ»Ì죬ÖÕÓڸ㶨ÁË¡£
¶ÔÓÚMysqlÓÐÁ½ÖÖģʽ£¬MYISAMÓëINNODB
Èç¹ûÊÇMYISAMµÄ»°£¬ÔÚdataĿ¼ÏÂÀï»á.frm .myd .myi ÈýÖÖÎļþ£¬ÄÇôֱ½Ó°ÑDATAÒÆ¹ýÈ¥£¬ÅäÖúÃȨÏ޾ͿÉÒÔ»¹ÔÁË¡£
Èç¹ûÊÇINNODBµÄ»°£¬ÄÇÊÇÏ൱µÄ·³°¡¡£ÔÚdataĿ¼ÏÂÖ»ÓÐ.frm(ÕâÖ»ÊÇÒ»¸öÊý¾Ý¸ñʽ£©£¬Õâ¸öÒÆ¹ýÈ¥ºó£¬ÊÇÎÞ·¨»¹ÔÔʼÊý¾ÝµÄ¡£
ÕæÕýµÄÊý¾ÝÊÇÕ ......