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

MySQL¶¯Ô±14000ÈËÇ©Ãû·´¶Ô¼×¹ÇÎÄSun½»Ò×

¾Ý¹úÍâýÌ屨µÀ£¬MySQLÊý¾Ý¿âµÄ¿ª·¢ÕßMichael WideniusÒÔ¼°²¿·ÖÏà¹ØÈËÊ¿½üÈÕÏòÅ·ÖÞ¡¢ÖйúÓë¶íÂÞ˹µÄ¼à¹Ü»ú¹¹Ìá½»Á˶Լ׹ÇÎÄ-Sun½»Ò׵ķ´¶ÔÒâ¼û£¬ÓдóÔ¼14000ÈËÔÚ¸ÃÒâ¼ûÉÏÇ©×Ö±íʾËûÃǶԴËÊÕ¹ºµÄ·´¶Ô¡£Å·ÃËίԱ»á´ËÇ°Ôø·´¶Ô¼×¹ÇÎÄÊÕ¹ºSun£¬µ«Õâһ¢¶ÏÉó²é»ú¹¹ÔÚ12ÔÂÓֳƣ¬¶Ô´Ë½»Ò×´ï³ÉÒ»¸öÂúÒâµÄ½á¹û±íʾÀÖ¹Û¡£Å·ÃËίԱ»á½«ÔÚ1ÔÂ27 ÈÕ×îÖÕ¾ö¶¨ÊÇ·ñ·ÅÐÐÕâÒ»½»Òס£
WindeniusÔÚÖÜÒ»Ïò¸÷¹ú¼à¹Ü»ú¹¹Ìá½»ÁËÕâ·Ý´øÓÐÇ©ÃûµÄÒâ¼û¡£ÔÚ¼×¹ÇÎĶÔÅ·Ã˱íʾÊÕ¹ºSun²»»áÓ°ÏìÕý³£¾ºÕùºó£¬ÕâÃû¿ª·¢Õß±ãÔÚÍøÕ¾·¢ÆðÁËÒ»Ïî·´¶Ô´Ë½»Ò׵Ļ¡£
·´Â¢¶ÏÂÉʦÔø±íʾ£¬ÈôÄÜ»ñµÃ´ó¹«Ë¾µÄÖ§³Ö£¬±ã»áÓ°ÏìÒ¡°Ú²»¶¨µÄ¼à¹Ü»ú¹¹×ö³ö¾ö¶¨¡£
MySQLÊÇÊý¾Ý¿âÊг¡µÄºó½øÈëÕߣ¬¸ÃÊг¡ÓÉIT¹«Ë¾¼×¹ÇÎÄ¡¢IBMÓë΢ÈíÕ¼Áì¡£MySQLµÄ½øÈëÀ­µÍÁËÊý¾Ý¿â²úÆ·µÄ¼Û¸ñ£¬Ò²¶¯Ò¡ÁËÕâЩ¾ÞÍ·¹«Ë¾µÄͳÖεØλ¡£
WideniusÊÇÓÐÃûµÄ¿ªÔ´Èí¼þ¿ª·¢Õߣ¬ËûÈ¥Äê´ÓSun¹«Ë¾´ÇÖ°£¬´´½¨ÁË×Ô¼ºµÄÊý¾Ý¿â¹«Ë¾Monty Program Ab¡£¶øSun¹«Ë¾ÔÚ2008Äê³â×Ê10ÒÚÃÀÔªÂòÏÂÁËMySQL¡£
WideniusÔÚÌá½»µÄÒâ¼ûÊéÖгƣ¬“Ç©ÃûÕß²»ÏàÐż׹ÇÎÄ»áÉÆ´ýMySQL¡£”Ëû±íʾ½«¼ÌÐø·´¶Ô¸Ã½»Ò×Ö±ÖÁ×îÖÕ½á¹û³ö¯¡£
Ç©Ãû»î¶¯µÄ·¢ÆðÈ˳ƣ¬Óг¬¹ý5000Ãû¸öÈË¿ª·¢ÕßÔÚ·´¶ÔÒâ¼ûÊéÉÏÇ©ÊðÁË×Ô¼ºµÄÃû×Ö£¬»¹ÓÐ3000¸öÇ©ÃûÀ´×ÔÄÇЩʹÓÃMySQLµÄ¹«Ë¾Óë»ú¹¹¹ÍÔ±¡£
ÕâЩǩÃûÔÚ·´¶Ô»î¶¯¿ªÊ¼µÄÒ»ÖÜÄÚÊÕ¼¯Íê³É£¬²¢±»Ìá½»ÖÁÅ·ÃËίԱ»á¡¢Å·ÖÞÒé»á¼°Å·ÃË27¸ö³ÉÔ±¹úµÄ¢¶ÏÉó²é»ú¹¹¡£»î¶¯·¢ÆðÕß»¹ÏòÖйúÉÌÎñ²¿Óë¶íÂÞ˹Áª°î·´Â¢¶Ï´¦Ìá½»ÁËÕâЩǩÃû¡£
24СʱҽÉúÔÚÏß×Éѯ


Ïà¹ØÎĵµ£º

MySQL 5.1.42 ·¢²¼

MySQL 5.1 ÊÇ MySQL Êý¾Ý¿âÄ¿Ç°·¢²¼µÄ×îеÄÎȶ¨°æ±¾£¨5.5ÊÇbeta״̬£¬6.0ÊÇalpha״̬£©¡£
¸Ã°æ±¾Ôö¼ÓÁ˶ÔÏÂÃ漸¸öƽ̨µÄÖ§³Ö£º
Mac OS X 10.6 x86/x64
HP-UX 11.31 IA64
SLES 11 x86/x64
InnoDB ²å¼þÉý¼¶µ½ 1.0.6 °æ±¾£¬ÁíÍâͨ¹ý¶Ô²éѯ»º´æµÄËéƬÓÅ»¯ÌáÉýÁËÐÔÄÜ£¬¸ü¶àÏêϸµÄÄÚÈÝÇë¿´ÕâÀï¡£
ÏÂÔصØÖ·£ºhttp://dev. ......

mysql ´´½¨±í²¢ÉèÖÃÖ÷¼ü×ÔÔö

mysql ´´½¨±í£º
mysql> create table user(
    -> userid int(4) primary key not null auto_increment,
    -> username varchar(16) not null,
    -> userpassword varchar(32) not null
    -> );
create table log(
logid int(4) ......

linux mysqlÅäÖÃ


жÔØmysql
1¡¢²éÕÒÒÔÇ°ÊÇ·ñ×°ÓÐmysql
ÃüÁrpm -qa|grep -i mysql
¿ÉÒÔ¿´µ½mysqlµÄÁ½¸ö°ü£º
mysql-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
2¡¢É¾³ýmysql
ɾ³ýÃüÁrpm -e --nodeps °üÃû
( rpm -ev mysql-4.1.12-3.RHEL4.1 )
3¡¢É¾³ýÀÏ°æ±¾mysqlµÄ¿ª·¢Í·ÎļþºÍ¿â
ÃüÁrm -fr /usr/lib/mysql
r ......

mysqlÊý¾Ý¿â·¶Ê½Ïê½â

ÔÚÉè¼Æ¹ØϵÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØϵģʽRÖеÄÿһ¸ö¾ßÌå¹ØϵrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......

¾­µäµÄMYSQLÓï¾ä

·Ç³£³£Óõģº¾­µäµÄMYSQLÓï¾ä…… php¿ªÔ´
ÕâÕæÊÇÒ»¸öºÃ¶«Î÷£ºÑ§Ï°ºÃÁ˺ÜÊÜÓõÄŶ……
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)php¿ªÔ´
Ê×ÏÈ,¼òÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ