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

Ö§³ÖMySqlÒ»°Ñ

ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£

ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡


´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ²¿ÊÜÀí´ËÊ£¬ÊÇ·ñÐèÒªÖйú¿ªÔ´Èí¼þÍÆ½øÁªÃ˰ïÖú?
¾Ý·͸ÉçÏûÏ¢£¬MySQL´´Ê¼ÈËMichael Widenius ÏÖÔÚÕýÔÚѰÇóÖйúºÍ¶íÂÞ˹Õþ¸®µÄ°ïÖú£¬ÒÔ·´¶ÔOracle
ÊÕ¹ºSun¹«Ë¾£¬Michael Widenius ֮ǰºôÓõÅ·ÃËÍ£Ö¹´ËÏî½»Ò×£¬µ«¸ù¾ÝÏÖÓеÄÇé¿öÀ´¿´£¬Å·ÃË»ò½«Åú×¼´ËÏî½»Òס£Îª´ËMichael
WideniusÕýÔÚѰÇóÖйúÕþ¸®µÄ°ïÖú£¬ËûÖ¸³öĿǰÔÚÈ«ÇòÖÐÓг¬¹ý3ÍòMySQLÓû§Ç©Ãû±íʾ·´¶Ô´ËÏî½»Ò×£¬Ï£ÍûÓиü¶àµÄÈ˲ÎÓë½øÀ´¡£ÍøÖ·ÊÇ
helpmysql.org¡£
WideniusÏÖÔÚÏ£ÍûÖйúÉÌÎñ²¿ºÍ¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÄܽéÈë´ËÊ£¬×èÖ¹½»Ò×ʼþ½øÒ»²½·¢Õ¹¡£“ËûÃǷdz£Ç¿´ó£¬×ÔÐźͿªÔ´ÓѺõĹú¼Ò£¬ËûÃÇÍêÈ«ÓÐȨÀûºÍ»ú»áÔÚÕâ¼þÊÂÉÏ×öµÄ±ÈÅ·Ã˸üºÃ”£¬Widenius˵¡£Ä¿Ç°¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÒѾ­¾Í´ËʽéÈëµ÷²é¡£
À´Ô´£ºhttp://osss.cn/news/2010/01/19/mysql%E5%88%9B%E5%A7%8B%E4%BA%BA%EF%BC
%9A%E5%B8%8C%E6%9C%9B%E5%BE%97%E5%88%B0%E4%B8%AD%E5%9B%BD%E6%94%BF%E5%BA%9C%E7%9A%84%E5%B8%AE%E5%8A%A9/
·͸É籨µÀ£ºhttp://www.reuters.com/article/idUSTRE60G1Z120100117
Osss.cn ¿ªÔ´ÉçÇø
Http://osss.cn


Ïà¹ØÎĵµ£º

MySQL´æ´¢ÒýÇæ Ó¦ÓÃ


MySQL·þÎñÆ÷²ÉÓÃÁËÄ£¿é»¯·ç¸ñ£¬¸÷²¿·ÖÖ®¼ä±£³ÖÏà¶Ô¶ÀÁ¢£¬ÓÈÆäÌåÏÖÔÚ´æ´¢¼Ü¹¹ÉÏ¡£´æ´¢ÒýÇæ¸ºÔð
¹ÜÀíÊý¾Ý´æ´¢£¬ÒÔ¼°MySQLµÄË÷Òý¹ÜÀí¡£Í¨¹ý¶¨ÒåµÄAPI£¬MySQL·þÎñÆ÷Äܹ»Óë´æ´¢ÒýÇæ½øÐÐͨÐÅ¡£Ä¿Ç°Ê¹ÓÃ×î¶àµÄÊÇMyISAMºÍInnoDB¡£
InnoDB±»OracleÊÕ¹ººó£¬MySQL×ÔÐпª·¢µÄд洢ÒýÇæFalcon½«ÔÚMySQL6.0°æ±¾Òý½ø¡£
MyISAMÒýÇæÊÇÒ ......

mysqlÖÐÎÄÂÒÂë½â¾ö

ÓÉÓÚÄÜÖ±½ÓÔÚMYSQLÊý¾Ý¿âÀïÌí¼ÓÖÐÎÄÊý¾Ý,²¢ÇÒÄÜÕý³£ÏÔʾ,˵Ã÷ÎÒµÄ±í¶¼Ê¹ÓÃÁËÕýÈ·µÄ×Ö·û±àÂë,¾­¹ý²é¿´ºó,È·ÈÏÁË,ÎÒÈ«²¿µÄ±íÒÔ¼°×ֶζ¼Ê¹ÓÃÁËUTF-8µÄ±àÂë,µ«ÊÇΪʲô³ÌÐòÌí¼ÓµÄÖÐÎÄÊý¾Ý¾Í²»ÐÐÄØ?
Æäʵ,Ô­ÒòÔÚÓÚMYSQL·þÎñÆ÷ʹÓõÄĬÈϱàÂë,ÒÔ¼°Êý¾Ý¿âµÄĬÈϱàÂë,ºÜ¶àÈËÒѾ­ºÜСÐĵÄÔÚ½¨Á¢±íʱ¹Ø×¢±íµÄ×Ö·û±àÂë,È´ºöÂÔÁËÊý¾Ý¿â ......

mysql һЩ¼òµ¥²Ù×÷ Rubicon

Á˽âÁËһЩ×î»ù±¾µÄ²Ù×÷ÃüÁîºó£¬ÎÒÃÇÔÙÀ´Ñ§Ï°ÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í¡£
¡¡¡¡1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES; +----------+
| Database | +----------+ | mysql |
| test | +----------+ 3 rows in set (0.00 sec)
¡¡¡¡2¡¢´´½¨Ò»¸öÊý¾Ý¿âabccs
¡¡¡¡mysql> ......

ת MYSQLÖеÄmy.ini»òmy.cnfÅäÖÃ˵Ã÷

mysqld³ÌÐò--Ŀ¼ºÍÎļþ
basedir = path ʹÓøø¶¨Ä¿Â¼×÷Ϊ¸ùĿ¼(°²×°Ä¿Â¼)¡£
character-sets-dir = path ¸ø³ö´æ·Å×Å×Ö·û¼¯µÄĿ¼¡£
datadir = path ´Ó¸ø¶¨Ä¿Â¼¶ÁÈ¡Êý¾Ý¿âÎļþ¡£
pid-file = filename Ϊmysqld³ÌÐòÖ¸¶¨Ò»¸ö´æ·Å½ø³ÌIDµÄÎļþ(½öÊÊÓÃÓÚUNIX/Linuxϵͳ); Init-V½Å±¾ÐèҪʹÓÃÕâ¸öÎļþÀïµÄ½ø³ÌID½áÊømysqld½ø ......

linuxϵ¼Èë¡¢µ¼³ömysqlÊý¾Ý¿âÃüÁî

Ò»¡¢µ¼³öÊý¾Ý¿âÓÃmysqldumpÃüÁעÒâmysqlµÄ°²×°Â·¾¶£¬¼´´ËÃüÁîµÄ·¾¶£©£º
1¡¢µ¼³öÊý¾ÝºÍ±í½á¹¹£º
mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
#/usr/local/mysql/bin/mysqldump -uroot -p abc > abc.sql
Çûسµºó»áÌáʾÊäÈëÃÜÂë
2¡¢Ö»µ¼³ö±í½á¹¹
mysqldump -uÓû§Ãû -p -d Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
# ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ