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


Ïà¹ØÎĵµ£º

ÐÞ¸ÄmysqÁ¬½ÓÊýºÍÆô¶¯mysql·þÎñ

my.cnf »òÕßÊÇ my.ini
ÔÚ[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]ÅäÖöÎÌí¼Ó£º
max_connections = 1000
±£´æ£¬ÖØÆôMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñ¡£
È»ºóÓÃÃüÁ
MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)admin -uroot -p variables 
ÊäÈërootÊý¾Ý¿âÕ˺ŵÄÃÜÂëºó¿É¿´µ½ 
| max_connections | 1000 |
Æô¶¯mysql·þÎñ
RedHat ......

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


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

PHPÍæ×ªMySQLÖ®Íâ¼üÔ¼Êø ÄÏÈý·½

ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Ñ§Ï°ÈçºÎͨ¹ýPHP 5µÄÒ»¸ö»ù±¾³éÏóÀàʹÓÃÍâ¼üÔ¼ÊøÀ´¸üÐÂÁ½¸öInnoDB±íµÄÊý¾Ý¡£ ÎÒÃǽ«Í¨¹ý¾ßÌåʾÀýÀ´ËµÃ÷ÈçºÎͨ¹ý·þÎñÆ÷¶Ë½Å±¾ÓïÑÔÀ´Ê¹ÓÃÍâ¼üÔ¼Êø¡£
¡¡¡¡Ò»¡¢ÀûÓÃÍâ¼üÔ¼Êø¸üÐÂMySQLÖеÄÊý¾Ý
¡¡¡¡ÏÖÔÚ£¬×îÁ÷ÐеĿªÔ´¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ·ÇMySQLĪÊô£¬¶øMySQLÓÖÖ§³Ö¶à¸ö´æ´¢ÒýÇæ£¬ÆäÖÐĬÈϵÄÒ²ÊÇËٶȽϿìµÄ´ ......

MySql³£ÓÃÃüÁî

Ðè×¢ÒâÒÔÏÂÈýµã£º
1¡¢´´½¨Êý¾Ý¿âµÄʱºò£ºCREATE DATABASE `database`
                        CHARACTER SET 'utf8'
         ......

MySQL Cluster Multi Computer Configuration


For our four-node, four-host MySQL Cluster, it is necessary to
write four configuration files, one per node host.

Each data node or SQL node requires a
my.cnf
file that provides two pieces of
information: a connectstring
that tells
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ