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

Æô¶¯Mysql ´íÎó 1067 ½ø³ÌÒâÍâÖÕÖ¹µÄÒ»ÖÖ½â¾ö·½·¨
mysqld-nt --defaults-file=my.ini --standalone --console
²é¿´ÐÅÏ¢ÄÚÈÝ
·¢ÏÖMYSQL INNODB³õʼ»¯´íÎó¡£
´íÎóÈçÏ£º
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100115 10:14:04  InnoDB: Setti ......

ʹÓÃÓαêʵÏÖ mysql ´æ´¢¹ý³ÌÖеÄÑ­»·

create   procedure   all_joiner_message(   in   captions   varchar(255),  in contents text,   in objectid int, in types int  ,  out count int)
begin
 declare   userids   int;
 DECLARE _done IN ......

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

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

Safe Shutdown and Restart of MySQL Cluster


To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:

shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ