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

MySQLµ¹Ïºó¿ªÔ´Êý¾Ý¿â»áºÜÊÜÉË

2008Äê2Ô±»SunÒÔ10ÒÚÃÀÔªÊÕ¹ºµÄMySQL£¬Ç°Â·ÈÔÈ»ÄÑÁÏ¡£¶ÔÓÚ´ó¼ÒÀ´Ëµ£¬±È½ÏÓÐÒâ˼µÄÊÇ£¬10ÔÂ27ÈÕ£¬Red HatÐû²¼ÒÔ1900ÍòÃÀԪע×Ê¿ªÔ´Êý¾Ý¿â³§ÉÌ—EnterpriseDB¡£ÏûÏ¢Ò»³ö£¬Á¢¿Ì±»Òµ½ç½â¶ÁΪRed HatÁí±Ùõ辶·¢Õ¹¿ªÔ´Êý¾Ý¿â£¬²»ÏëÒÔºóÊÜÖÆÓÚOracleºÍMySQL¡£
Èç¹ûMySQLµÄ´óÆìµ¹ÏÂÁË£¬ÖÚ¶àÁ¦Á¿·ÖÉ¢ÇÒÈõСµÄ¿ªÔ´Êý¾Ý¿â½«Õ¹¿ª¼¤ÁÒµÄÕù¶á£¬¿ªÔ´Êý¾Ý¿âÊг¡Ò²Ðí½«½øÈë´ºÇïÕ½¹úʱÆÚ£¬¶øË­ÓÖ»áÊÇÏÂÒ»¸öÊг¡ÁìÐäÄØ?
“±ê¸Ë”MySQL
ÔÚ¼¸°ÙÒÚÃÀÔª¹æÄ£µÄÊý¾Ý¿âÊг¡ÖУ¬¿ªÔ´Êý¾Ý¿âµÄ·Ý¶î΢ºõÆä΢¡£ÒÔIDC 2007Äê¶ÔÈ«ÇòÊý¾Ý¿âÊг¡µÄͳ¼ÆΪÀý£¬ÔÚ×ܹ²188ÒÚÃÀÔªµÄÊг¡ÖУ¬Oracle¡¢IBM¡¢Î¢ÈíλÁÐÇ°Èý룬ºÏ¼ÆÊг¡·Ý¶î´ïµ½83.8%£¬¶øMySQLÒÔ3800ÍòÃÀÔªµÄÊÕÈëÕ¼µ½0.2%¡£GartnerÔ¤¼Æ£¬2013Ä꿪ԴÊý¾Ý¿âÊг¡½«Í»ÆÆ10ÒÚÃÀÔª£¬µ«ÓëÕû¸öÊý¾Ý¿âÊг¡Ïà±È£¬ÒÀȻСµÃ¿ÉÁ¯¡£
²»¹ý£¬¿ªÔ´Êý¾Ý¿âȴչʾ³öÁ˸߳ɳ¤ÐÔ¡£GartnerÊý¾ÝÏÔʾ£¬2008Ä꿪ԴÊý¾Ý¿âµÄÊÕÈëÔö³¤ÁË42.4%£¬¿ªÔ´Êý¾Ý¿âµÄʹÓÃÔö³¤ÁË50%£¬±»µ÷²éµÄÆóÒµÖУ¬73%ÕýÔÚʹÓÿªÔ´Êý¾Ý¿â£¬Ïà±ÈÉÏÄêµÄ49%ÓкܴóÔö³¤¡£
ÔÚÕâ¸ö²»´óµÄÊг¡ÉÏ£¬MySQLÓÐ×ÅÖØÒªµÄµØλ¡£Öйú¿ªÔ´Èí¼þÍƽøÁªÃËÖ÷ϯ½Ê×Ⱥ±íʾ£¬MySQL¡¢PostgreSQL¡¢EnterpriseDBÊÇÈ«ÇòÈý´ó¿ªÔ´Êý¾Ý¿â¡£MySQL¼ÈÊÇÒ»¸ö¿ªÔ´µÄ¿ª·¢ÉçÇø£¬Ìṩ×ÔÓÉÏÂÔØʹÓõÄÃâ·Ñ°æ±¾£¬Ò²ÌṩÉÌÆ·»¯µÄ²úÆ·£¬ÊÕÈ¡¼¼ÊõÖ§³Ö·þÎñ·ÑÓá£
Êý¾ÝÏÔʾ£¬½ØÖÁ2009Äê1Ô£¬MySQLµÄÓû§ÓÐ1100Íò£¬¹È¸è¡¢ÑÅ»¢ºÍÑÇÂíÑ·µÈÐí¶à»¥ÁªÍø¹«Ë¾¶¼ÊÇËüµÄÓû§¡£±»SunÊÕ¹ºÖ®ºó£¬MySQLÏȺ󿪷¢³öMySQL5.0¡¢MySQL enterpriseµÈвúÆ·£¬ÔÚMySQL5.1¶ÔÍ⿪·ÅµÄÍ·10ÌìÄÚ£¬ÏÂÔØ´ÎÊý¾Í³¬¹ýÁË25Íò´Î¡£
½Ê×Ⱥ±íʾ£¬MySQLÔÚÖйúÊг¡Ò²Óв»´íµÄÏúÊÛÒµ¼¨¡£2007Ä꣬»ªÎª¡¢°®Á¢ÐÅÖйú¡¢Î÷ÃÅ×ÓÖйúµÈ´óÆóÒµ¶¼²É¹ºÁËMySQLµÄ²úÆ·¡£2008Ä꣬MySQLÓÖ»ñµÃÁËÐÂÀ˵ȹ«Ë¾µÄÇàíù£¬µ±ÄêÔÚÖйúÊг¡µÄÏúÊÛ¶î´ïµ½1500ÍòÔª£¬¹À¼Æ½ñÄêµÄÊÕÈ뽫³¬¹ý2000ÍòÔª¡£
Òò´Ë£¬MySQLµÄÒ»¾ÙÒ»¶¯¶¼ÊÇ¿ªÔ´Êý¾Ý¿âÊг¡µÄ·çÏò±ê¡£Èç½ñ£¬ËüµÄǰ;ÒòΪOracleÓëSun²¢¹ºµÄÐü¶øδ¾ö¶øÆ®ºö²»¶¨¡£¾¡¹ÜOracle³Ðŵ»á±£³ÖMySQLµÄ¶ÀÁ¢ÐÔ£¬Öڶ෴¶ÔÕß»¹Êǵ£ÐÄ£¬Èç¹ûMySQL±»×î´óµÄ˽ÓÐÊý¾Ý¿â³§ÉÌOracleÊÕ¹é÷âÏ£¬¿ÉÄÜÔâµ½OracleµÄÅ×ÆúÉõÖÁ´òѹ¡£
MySQLǰ;ÄÑÁÏ
×î½ü¼¸Ä꣬ÔÚ¿ªÔ´´óÊÆ֮ϣ¬Oracle¡¢IBM¡¢Î¢ÈíµÈÒѾ­·×·×Ïò¿ªÔ´Éì³öÁËéÏé­Ö¦¡£“IBMºÍOracle¼ÈÓÐÉÌÒµÊý¾Ý¿â£¬Ò²ÓпªÔ´Êý¾Ý¿â£¬²ÉÈ¡ÁËÁ½ÊÖ·¢Õ¹µÄ²ßÂÔ£¬ÎÊÌâÖ»ÊÇʲôʱºò´ÓÄ»ºó×ßµ½Ì¨Ç°°ÕÁË¡£”½Ê×Ⱥ˵¡


Ïà¹ØÎĵµ£º

MySQL 5.4µÄÐÂÌØÐÔ½âÎö

Author: Ivan@mysqlab.net/Ì·¿¡Çà תÔØÇë×¢Ã÷À´Ô´URIÁ´½Ó:
http://www.mysqlab.net/blog/2009/04/mysql-54µÄÐÂÌØÐÔ½âÎö/
MySQL 5.4 Ö®ËùÒÔÃüÃûΪ5.4£¬¶ø²»ÊÇ5.2 ÊÇÒòΪ֮ǰµÄ5.2°æ±¾±»ÃüÃûΪ6.0ÁË£¨Õâ¸öÓ¦¸ÃÊÇÉÌÒµÉϵÄÔ­Òò£¬¾ÍÏñjava1.6±»ÃüÃûΪ6.0£©¡£ÏÖÔÚµÄ5.4 preview release ÊÇÔÚµ±Ç°MySQL5.1µÄ»ù´¡ÉÏ£¬¶Ô Innodb ½ø ......

Windowsƽ̨¶àMYSQLÅäÖÃ(¶àMy.ini)

    ×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõĻ°¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËÇ°±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼Æà ......

MySqlͨÓô洢·ÖÒ³

DELIMITER $$
DROP PROCEDURE IF EXISTS `hotel`.`prc_page_hotel_result`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE  `hotel`.`prc_page_hotel_result`(
in currpage      int,
in columns       varchar(500),
in tablename   &n ......

dz̸MySQLÂý²éѯÈÕÖ¾¼°microslow patch(msl patch)

mysql(°üÀ¨ËùÓÐ5.*ϵÁÐ,5.1.21֮ǰ)µÄÂý²éѯÈÕ־ĬÈÏÊÇÒÔÃëΪµ¥Î»µÄ,¿ÉÒÔͨ¹ýset [session|global] long_query_time=1Õâ¸ö×îµÍÒ²¾ÍÊÇ¿ÉÒÔÉèÖõ½1Ãë,¶ÔÓÚ0.5,0.005Ö®Àà¾ÍÎÞÄÜΪÁ¦ÁË,Õâʱºò¿ÉÒÔÓÐmicroslow patch(msl patch)²¹¶¡À´Íê³ÉÕâÒ»¹¤×÷,Õâ¸ö¹¦Äܵĺô¦×ÔÈ»²»ÑÔ¶øÓ÷. ÔÚmysql5.1.21¼°ÒÔºó°æ±¾¿ÉÒÔͨ¹ýset [session|gl ......

Myeclipse7.5Á¬½ÓMySQLÊý¾Ý¿â

Èý²½×ߣº
1.ÔÚwindows-->perspective-->DB browser
 
2.Create a database connection profile
 
  Çý¶¯ÏÂÔØ£º http://dev.mysql.com/downloads/
  ÎļþÃû£ºmysql-connector-java-5.0.4-bin
3.Open a database connection
 
Á´½Óʱ¿ÉÄܳöÏÖ´íÎó£¬ÄÇôÇë³¢ÊÔÈçÏ·½·¨£º
Err ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ