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

¡¾×ª¡¿MySQLÓÅ»¯¼òÃ÷Ö¸ÄÏ

Ò»¡¢ÔÚ±àÒëʱÓÅ»¯MySQL 
Èç¹ûÄã´ÓÔ´´úÂë·Ö·¢°²×°MySQL£¬Òª×¢Ò⣬±àÒë¹ý³Ì¶ÔÒÔºóµÄÄ¿±ê³ÌÐòÐÔÄÜÓÐÖØÒªµÄÓ°Ï죬²»Í¬µÄ±àÒ뷽ʽ¿ÉÄܵõ½ÀàËƵÄÄ¿±êÎļþ£¬µ«ÐÔÄÜ¿ÉÄÜÏà²îºÜ´ó£¬Òò´Ë£¬ÔÚ±àÒë°²×°MySQLÊÊÓ¦×Ðϸ¸ù¾ÝÄãµÄÓ¦ÓÃÀàÐÍÑ¡Ôñ×î¿ÉÄܺõıàÒëÑ¡Ïî¡£ÕâÖÖ¶¨ÖƵÄMySQL¿ÉÒÔΪÄãµÄÓ¦ÓÃÌṩ×î¼ÑÐÔÄÜ¡£
¼¼ÇÉ£ºÑ¡ÓýϺõıàÒëÆ÷ºÍ½ÏºÃµÄ±àÒëÆ÷Ñ¡ÏÕâÑùÓ¦ÓÿÉÌá¸ßÐÔÄÜ10-30%¡££¨MySQLÎĵµÈçÊÇ˵£©
1.1¡¢Ê¹ÓÃpgcc£¨Pentium GCC)±àÒëÆ÷ 
¸Ã±àÒëÆ÷£¨http://www.goof.com/pcg/£©Õë¶ÔÔËÐÐÔÚ±¼ÌÚ´¦ÀíÆ÷ϵͳÉϵijÌÐò½øÐÐÓÅ»¯£¬ÓÃpgcc±àÒëMySQLÔ´´úÂ룬×ÜÌåÐÔÄÜ¿ÉÌá¸ß10%¡£µ±È»Èç¹ûÄãµÄ·þÎñÆ÷²»ÊÇÓñ¼ÌÚ´¦ÀíÆ÷£¬¾Í²»±ØÓÃËüÁË£¬ÒòΪËüÊÇרΪ±¼ÌÚϵͳÉè¼ÆµÄ¡£
1.2¡¢½öʹÓÃÄãÏëʹÓõÄ×Ö·û¼¯±àÒëMySQL 
MySQLÄ¿Ç°Ìṩ¶à´ï24ÖÖ²»Í¬µÄ×Ö·û¼¯£¬ÎªÈ«ÇòÓû§ÒÔËûÃÇ×Ô¼ºµÄÓïÑÔ²åÈë»ò²é¿´±íÖеÄÊý¾Ý¡£È´Ê¡Çé¿öÏ£¬MySQL°²×°ËùÓÐÕßÕâЩ×Ö·û¼¯£¬ÈÈÈ»¶ø£¬×îºÃµÄÑ¡ÔñÊÇָѡÔñÒ»ÖÖÄãÐèÒªµÄ¡£È磬½ûÖ¹³ýLatin1×Ö·û¼¯ÒÔÍâµÄËùÓÐÆäËü×Ö·û¼¯£º
--------------------------------------------------------------------------------
%>./configure -with-extra-charsets=none [--other-configuration-options] 
--------------------------------------------------------------------------------
1.3¡¢½«mysqld±àÒë³É¾²Ì¬Ö´ÐÐÎļþ 
½«mysqld±àÒë³É¾²Ì¬Ö´ÐÐÎļþ¶øÎÞÐè¹²Ïí¿âÒ²ÄÜ»ñµÃ¸üºÃµÄÐÔÄÜ¡£Í¨¹ýÔÚÅäÖÃʱָ¶¨ÏÂÁÐÑ¡Ï¿É¾²Ì¬±àÒëmysqld¡£
--------------------------------------------------------------------------------
%>./configure -with-mysqld-ldflags=-all-static [--other-configuration-options] 
--------------------------------------------------------------------------------
1.4¡¢ÅäÖÃÑù±¾ 
ÏÂÁÐÅäÖÃÃüÁî³£ÓÃÓÚÌá¸ßÐÔÄÜ£º
--------------------------------------------------------------------------------
%>CFLAGS="-O6 -mpentiumpro -fomit-frame-pointer" CXX=gcc CXXFLAGS="-O6 -mpentiumpro -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local --enable-assembler --with-mysqld-ldflags=-all-static --disable


Ïà¹ØÎĵµ£º

MySQL FOR LINUX


MySQL FOR LINUX
Ïȼì²éϵͳÊÇ·ñ×°ÉÏÁËmysql£¬Èç¹ûÓн«ÆäжÔصô
rpm -qa | grep mysql
×¢ÒâmysqlµÄ´óСд£¬´óСд¶¼ÓпÉÄÜ
rpm -e --nodeps mysql*
Ò»¶¨ÒªÓÃ--nodepsжÔØ£¬²»¼ì²éÒÀÀµÐÔ¹Øϵ¡£
´´½¨Óû§mysql
groupadd mysql
useradd -g mysql mysql
passwd mysql
ÔÚ/usr/localϽ¨Á¢ mysql Îļþ¼Ð
È»ºó½«°²×°Î ......

¡¾×ª¡¿MySQLÖÐSQLÓÅ»¯ºÍ¼Ü¹¹Éè¼ÆµÄһЩ¼òµ¥Ïë·¨

ÆÕͨMySQLÔËÐУ¬Êý¾ÝÁ¿ºÍ·ÃÎÊÁ¿²»´óµÄ»°£¬ÊÇ×ã¹»¿ìµÄ£¬µ«Êǵ±Êý¾ÝÁ¿ºÍ·ÃÎÊÁ¿¾çÔöµÄʱºò£¬ÄÇô¾Í»áÃ÷ÏÔ·¢ÏÖMySQLºÜÂý£¬ÉõÖÁdownµô£¬ÄÇô¾ÍÒª¿¼ÂÇÓÅ»¯ÎÒÃǵÄMySQLÁË¡£
ÓÅ»¯ÎÞ·ÇÊÇ´ÓÈý¸ö½Ç¶ÈÈëÊÖ£º
µÚÒ»¸öÊÇ´ÓÓ²¼þ£¬Ôö¼ÓÓ²¼þ£¬Ôö¼Ó·þÎñÆ÷
µÚ¶þ¸ö¾ÍÊǶÔÎÒÃǵÄMySQL·þÎñÆ÷½øÐÐÓÅ»¯£¬Ôö¼Ó»º´æ´óС£¬¿ª¶à¶Ë¿Ú£¬¶Áд·Ö¿ª
µÚÈý¸ö ......

¸ã¶¨MySQLÊý¾Ý¿âÖÐÎÄÄ£ºý¼ìË÷ÎÊÌâ

ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾­³£»á·µ»ØһЩÓëÖ®²»Ïà¹ØµÄ¼Ç¼£¬Èç²éÕÒ "%a%" ʱ£¬·µ»ØµÄ¿ÉÄÜÓÐÖÐÎÄ×Ö·û£¬È´Ã»ÓÐa×Ö·û´æÔÚ¡£±¾ÈËÒÔÇ°Ò²ÔøÓöµ½¹ýÀàËÆÎÊÌ⣬¾­ÏêϸÔĶÁMySQLµÄManual£¬·¢ÏÖ¿ÉÒÔÓÐÒ»ÖÖ·½·¨ºÜ·½±ãµÄ½â¾ö²¢µÃµ½ÂúÒâµÄ½á¹û¡£
¡¡¡¡Àý×Ó£º
¡¡¡¡Ï£Íûͨ¹ý“±êÌ┶ÔÐÂÎÅ¿â½øÐмìË÷£¬¹Ø¼ü×Ö¿ÉÄÜ°üº¬Ê ......

mysql can't create table errno 150

1¡¢Íâ¼üµÄÒýÓÃÀàÐͲ»Ò»Ñù£¬Ö÷¼üÊÇintÍâ¼üÊÇchar
2¡¢ÕÒ²»µ½Ö÷±íÖÐ ÒýÓõÄÁÐ
3¡¢Ö÷¼üºÍÍâ¼üµÄ×Ö·û±àÂë²»Ò»ÖÂ
4.»¹ÓÐÒª½¨Á¢Íâ¼üµÄ»°£¬ÒªÏȽ¨Á¢Ë÷Òý¡£Ã»Óн¨Á¢Ë÷ÒýÒ²»á³ö´í¡£
ÎÒµÄÎÊÌâ½â¾ö·½°¸ÊÇÔÚsqlºóÃæ¼ÓÉÏÁËÈçϾ仰,ok!³É¹¦µ¼Èë½Å±¾
ENGINE=MyISAM DEFAULT CHARSET=utf8;
charset¶ÔÓ¦µÄ»»³ÉÄãµÄÖ÷¼ü±íµÄ×Ö·û¼¯ ......

[ת]mysql ÓÅ»¯ÐĵÃÒ»µãµã

×î½üÍøÕ¾Êý¾ÝÁ¿½Ú½ÚÅÊÉý£¬¾ÝBD·½Ãæͨ±¨¶ÌÆÚÄÚUV»¹ÒªÉÏÉý30%-50%¡£µ±Ç°×îÍ»³öµÄÎÊÌâÊǺǫ́ÄÚÈÝÉóºËϵͳѹÁ¦Ì«´ó£¬ÒѾ­Öð½¥Á¦²»´ÓÐÄ¡£¾¡¹Ü¼ÓÁËһЩӲ¼þµ«Ð§¹û²¢²»ÊÇÌ«ÀíÏ룬Ö÷Òª»¹ÊÇÇ°Ò»¶Îʱ¼ä°Ñ¹¤×÷Öص㶼·ÅÔÚÇ°¶ËÄ£¿éÉÏÁË¡£ÄÚÈݹÜÀíƽ̨µÄ²¿·Ö´úÂëûÓÐ×ÐϸÕå×᣽ÓÏÂÀ´Ò»¶Îʱ¼ä¼¯Öо«Á¦ÓÅ»¯ºǫ́¡£
Ê×ÏȽ«¶à±íÁ¬²éµÄSQLÄóö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ