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¼ÈÓÐÉÌÒµÊý¾Ý¿â£¬Ò²ÓпªÔ´Êý¾Ý¿â£¬²ÉÈ¡ÁËÁ½ÊÖ·¢Õ¹µÄ²ßÂÔ£¬ÎÊÌâÖ»ÊÇʲôʱºò´ÓÄ»ºó×ßµ½Ì¨Ç°°ÕÁË¡£”½Ê×Ⱥ˵¡
Ïà¹ØÎĵµ£º
Unix&Linux£º
1.ÓÃroot»òÕßÔËÐÐmysqldµÄÓû§µÇ¼ϵͳ£»
2£®ÀûÓÃkillÃüÁî½áÊøµômysqldµÄ½ø³Ì£»
3£®Ê¹ÓÃ--skip-grant-tables²ÎÊýÆô¶¯MySQL Server
shell>mysqld_safe --skip-grant-tables &
4.Ϊroot@localhostÉèÖÃÐÂÃÜÂë
shell>mysqladmin -u root flush-privileges password "newpassword" ......
InnoDBÊÇmysqlÊý¾Ý¿âÖÐΨһһ¸öÖ§³ÖÍâ¼üµÄÒýÇ棬µ«ÊDzîÖµµÄʱºòÈ´µÃ×¢ÒâÒ»ÏÂ
±ÈÈçÓÐÁ½ÕÅ±í£¬album(id,name,path) £¬picture(id,name,path,parent_album)£¬ÆäÖбí2ÖÐparent_albumÊÇÍâ¼ü
´Ëʱ²îÖµinsert into picture (name,path,parent_album) values ("pic","path",68) (68ÊÇÒ»¸öÏà²áµÄid)
mysql»á±¨´í"Failed to read a ......
×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõĻ°¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËÇ°±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼Æà ......
Analyze Table
MySQL µÄOptimizer£¨ÓÅ»¯Ôª¼þ£©ÔÚÓÅ»¯SQLÓï¾äʱ£¬Ê×ÏÈÐèÒªÊÕ¼¯Ò»Ð©Ïà¹ØÐÅÏ¢£¬ÆäÖоͰüÀ¨±íµÄcardinality£¨¿ÉÒÔ·ÒëΪ“É¢Áг̶Ȕ£©£¬Ëü±íʾij¸öË÷Òý¶ÔÓ¦µÄÁаüº¬¶àÉÙ¸ö²»Í¬µÄÖµ——Èç¹ûcardinality´ó´óÉÙÓÚÊý¾ÝµÄʵ¼ÊÉ¢Áг̶ȣ¬ÄÇôË÷Òý¾Í»ù±¾Ê§Ð§ÁË¡£
ÎÒÃÇ¿ÉÒÔʹÓÃSHOW& ......