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 GUI¹¤¾ßºÜ¶à£¬±¾Îľͳ£ÓõÄNavicat for MySQLÓëMySQL GUI ToolsµÄÌØÉ«¹¦ÄÜ×öÒ»¸öÏêϸ½éÉÜÓë±È½Ï¡£
¡¡¡¡£¨Ò»£©MySQL GUI Tools
¡¡¡¡MySQL¹Ù·½ÌṩµÄÒ»¸ö¿ÉÊÓ»¯½çÃæµÄMySQLÊý¾Ý¿â¹ÜÀí¿ØÖÆÌ¨£¬ÌṩÁËËĸöͼÐλ¯Ó¦ÓóÌÐò£¬ÕâЩͼÐλ¯¹ÜÀí¹¤¾ß¿ÉÒÔ´ó´óÌá¸ßÊý¾Ý¿â¹ÜÀí¡¢±¸·Ý¡¢Ç¨ÒƺͲéѯЧÂÊ¡£ËüÃÇ·Ö±ðÊÇ£º ......
mysql> flush privileges;ʲôÒâ˼£¿
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';
mysql> flush privileges;
mysql> quit
´ð:
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......
ΪÁ˸øG×¼±¸ÂÛÎÄ£¬ÏëÖ±½ÓÓÃÒ»¸öÏîÄ¿¡£
ÄǸöÏîÄ¿ÔÀ´ÓõÄÊý¾Ý¿âÊÇORACLE£¬µ«ËûµÄ»úÆ÷ÅäÖõͣ¬ÄÚ´æÖ»ÓÐ256M£¬ÅÜORALCEÁËÌ«³ÔÁ¦ÁË¡£ÓÚÊǾÍÏë°ÑÊý¾Ý¿â²¿·ÖÒÆÖ²µ½MYSQL¡£×Ô¼ºÏÈ
×öʵÑ飬Äêǰ¾Í×°ÁË£¬ÏÖÔÚÏë×öÒÆÖ²£¬ROOTÃÜÂë¸øÍüÁË¡£µ¹ÊÇ¿ÉÒÔ֨װ£¬¿ÉÄÇÒ»¶¨²»ÊÇ×î¼Ñ½â¾ö·½°¸¡£
UNIX°æ
1.ÏÈÍ£µômysql
# /etc/rc.d/init.d/mys ......
/**********************************
APACHE
***********************************/
±à¼²ÎÊý£º
./configure" \
"--prefix=/usr/local/apache" \
"--enable-so" \
"--enable-ssl" \
"--enable-mods-shared=most" \
"--with-mpm=event" \
"--with-ssl=/usr/local/openssl" \
"--enable-cache" \
"--enable-mem- ......
mysql Ŀ¼Ï嵀 my.ini ÓÐÁ½´¦ÒªÐÞ¸Ä Ò»´¦ÊÇ [mysql] default-character-set=gbk »¹ÓÐÒ»´¦ÊÇ·ñÈϽ¨±íʱʹÓõÄ×Ö·û¼¯ default-character-set=gbk Á½´¦ÐÞ¸Äһϣ¬ÖØÐ½¨Á¢Êý¾Ý¿âºÍ±íºó¾Í²»»á³öÏÖÂÒÂëÁË¡£ ½¨±íʱҲ¿ÉÒÔÖ¸¶¨Êý¾Ý¿â»ò±íËùʹÓõÄ×Ö·û¼¯ Èç¹û²»ÄÜÖØ½¨Êý¾Ý¿âÔòÖ»ÄÜÔÚÖ¸¶¨µÄÊý¾Ý¿âĿ¼Ï°ѶÔÓ¦µÄ db.opt À ......