ºìÁªLinuxÃÅ»§
Linux°ïÖú

ÍêÉÆ×ÔÎÒµÄMySQL

·¢²¼Ê±¼ä:2007-01-14 00:20:19À´Ô´:ºìÁª×÷Õß:linuxcms
¡¡¡¡ÔÚ2006ÄêÔâÓö×îΪ¡°²ÒÖØ¡±µÄµ±ÊôMySQL¡£

¡¡¡¡MySQL¿ªÔ´Êý¾Ý¿â²ÉÓõÄÊÇË«ÖØÊÚȨ²ßÂÔ£¬¶ÔÓÚ²»Ô¸¹«¿ª×Ô¼ºÔ´´úÂëµÄʹÓÃÕߣ¬ÐèÒª¸¶·ÑʹÓÃMySQL, ¶ø¶ÔÓÚ¿ª·ÅÔ´´úÂëµÄʹÓÃÕߣ¬¿ÉÒÔ»ùÓÚGNUµÄ¹«¹²Ðí¿ÉЭÒéGPLÀ´Ê¹Óá£

¡¡¡¡MySQLÊý¾Ý¿â²¢Ã»ÓÐÊôÓÚ×Ô¼ºµÄÓÃÓÚ¸ºÔðÊý¾ÝµÄÎïÀí´æ´¢ºÍË÷ÒýµÄ´æ´¢ÒýÇ棬ËüÆÕ±éʹÓñðµÄ¿ªÔ´Êý¾Ý¿âÒýÇæ×öΪ×Ô¼ºµÄ¹Ø¼üÐÔ´æ´¢ÒýÇæ¡£MySQLÔø¾­°ÑInnoDB×öΪ×Ô¼ºµÄÊÂÎïÐÍÊý¾Ý´æ´¢ÒýÇ棬°ÑBerkeleyDB×öΪ×Ô¼ºµÄǶÈëʽÊÂÎïÐÍ´æ´¢ÒýÇæ¡£ÕâÁ½ÖÖ¿ªÔ´Êý¾Ý¿â±»OracleÊÕ¹ºÖ®ºó£¨InnoDBÔÚ2005Äê10Ô·ݱ»ÊÕ¹º£¬BerkeleyDBÔÚ2006Äê2Ô·ݱ»ÊÕ¹º£©£¬MySQLÔÚ×öÁËһЩӦ¼±´ëÊ©¼°µÃµ½Ò»Ð©¡°°ïÖú¡±Ö®ºó£¨2006Äê2Ô£¬MySQL¹ÍÓ¶ÁËǶÈëʽ¿ªÔ´Êý¾Ý¿âFirebirdÏîÄ¿µÄ¹Ø¼üÈËÎïJim Starkey£»2006Äê9Ô·ݣ¬Ðû²¼È¥³ýµô¶ÔBerkeleyDB´æ´¢ÒýÇæµÄÖ§³Ö£»2006Äê7ÔÂ25ÈÕ£¬×¨ÃÅΪMySQLÁ¿Éí¶¨×öµÄBeta°æ SolidDB Storage EnginÕýʽ¶ÔÍâ·¢²¼£©ÕýÔÚ¼Ó½ôÑз¢×Ô¼ºµÄ´æ´¢ÒýÇæ¡£

¡¡¡¡MySQLÆð³õҲûÓÐ×Ô¼ºµÄ´æ´¢¹ý³Ì (Stored Procedure)ÓïÑÔ£¬ÔÚµ±Ê±ÕâÊǶÔÏ°¹ßÓÚÆóÒµ¼¶Êý¾Ý¿âµÄ³ÌÐòÔ±µÄ×î´óÏÞÖÆ¡£¶àÓï¾äSQLÃüÁî±ØÐëͨ¹ý¿Í»§·½´úÂëÀ´Ð­µ÷£¬ÕâÖÖÇéÐÎÊǽèÖúÓÚÏ൱½¡È«µÄ²éѯÓïÑԺ͸³Óè¿Í»§¶ËËø¶¨ºÍ½âËø±íµÄÄÜÁ¦£¬ÕâÑù²ÅÔÊÐíµÄ¶àÓï¾äÔËÐС£ µ«ÔÚMySQL 5.0·¢²¼Ö®ºó£¬MySQLÐû³ÆÒѾ­ÍêÈ«Ö§³Ö´æ´¢¹ý³Ì¡£

¡¡¡¡µ«ÊÇMySQLĿǰûÓÐ×Ô¼ºµÄ´æ´¢ÒýÇæ¡£MySQLµÄ´æ´¢ÊÇÒԿɲåÈ¡µÄ´æ´¢ÒýÇæ´æÔڵģ¬Ëü²ÉÓò»Í¬µÄ´æ´¢ÒýÇæ¼¼Êõ°ÑÊý¾Ý´æ´¢ÔÚÎļþ»òÕßÄÚ´æÖС£ MySQLÓжàÖÖ´æ´¢ÒýÇæ:MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢ FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£¿ÉÒÔ²ÉÓÃÄÚ´æ´æ´¢ÒýÇæ´æ´¢ÁÙʱÊý¾Ý£¬²ÉÓÃÊÂÎï´æ´¢ÒýÇæÀ´Íê³ÉÊÂÎï´¦Àí£¬µÈµÈ¡£Ïà±È֮ϣ¬ÆäËüµÄһЩÊý¾Ý¿âϵͳ(°üÀ¨´ó¶àÊýÉÌҵѡÔñ)½öÖ§³ÖÒ»ÖÖÀàÐ͵ÄÊý¾Ý´æ´¢¡£¶ÔÓÚÓû§¶øÑÔ£¬ÕâÖÖÑ¡Ôñ²»Í¬µÄ´æ´¢ÒýÇæÀ´´æ´¢ºÍ¼ìË÷Êý¾ÝµÄÁé»îÐÔ£¬ÊDZȽÏÊÜ»¶Ó­µÄ¡£È»¶ø£¬OracleÒ²ÕýÊÇ¿´ÖÐÁËÕâÒ»µã£¬²Å¶ÔMySQL·¢ÄÑ¡£

¡¡¡¡Ñз¢×Ô¼ºµÄ´æ´¢ÒýÇæÊÇMySQLÔÚ2007ÄêؽÐè½â¾öµÄÈÎÎñ¡£2006ÄêÄêµ×£¬MySQL AB¹«Ë¾ºÍNitroSecurity¹«Ë¾´ï³ÉЭÒ飬˫·½ÁªºÏÑз¢Ò»¿î»ùÓÚNitroEDBTM¸ßËÙ¹ØϵÊý¾Ý¿â¼¼ÊõµÄMySQLÊý¾Ý¿âÒýÇæ¡£ NitroSecurity¼¼ÊõʹÓöÀÌصÄË÷Òý¼¼Êõ¡¢Êý¾Ý¹ÜÀí·½·¨ºÍ²éѯ´¦ÀíËã·¨£¬¸Ã¼¼Êõ¿ÉÒÔÇáËÉ´¦Àí´óÈÝÁ¿µÄÊý¾Ý¿â²Ù×÷£¬¶øδÀ´µÄMySQLÊý¾Ý¿â·þÎñÆ÷°æÖн«Ç¶ÈëNitroSecurityµÄNirtroEDBÊý¾Ý¿â´æ´¢ÒýÇ棬²¢ÇÒÕâÖÖ½â¾ö·½°¸¿ÉÒÔÓë¾É°æ±¾µÄMySQLÊý¾Ý¿âµÄÓ¦ÓóÌÐò»¥Ïà¼æÈÝ¡£¶øÔÚ 2007ÄêµÄ¿ªÊ¼£¬ÒѾ­ÓÐÏûÏ¢´«³öÕë¶ÔÅúÁ¿Web·þÎñÆ÷»·¾³¶øÉè¼ÆµÄÄÚ²¿²âÊÔ°æÐÂMySQL´æ´¢ÒýÇæÒѾ­·¢²¼£¬ÒÔÓÃÓÚϸ»¯MySQLµÄ´æ´¢ÒýÇæµÄ¹¦ÄܺÍÐÔÄÜ¡£

¡¡¡¡2007ÄêеÄÒ»ÄêÖУ¬MySQL²»½öÒªÔÚ´æ´¢ÒýÇæÉÏ×ö³öŬÁ¦£¬»¹ÒªÔÚ´ÅÅÌ´æ´¢¡¢ÄÚ´æËðºÄ¡¢¼¯Èº¼¼ÊõÒÔ¼°ÆäËûµÄÆóÒµ¼¶ÐÔÄܺ͹¦ÄÜÉÏÓÐ×Ô¼ºµÄÍ»ÆÆ¡£ÁíÍ⣬Ãæ¶ÔʱϵĿªÔ´»·¾³£¬MySQLÒ²Ó¦¸Ã×Ðϸ¿¼ÂÇ×Ô¼ºµÄ·¢ÐзÑÓ÷½Ê½µÄת±ä¡¢Åàѵ¡¢¹Ø¼üÐÔ²¿ÊðµÈ·Ç¼¼ÊõÐÔÎÊÌâ¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ