Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³£ÓÃSQLÓï¾ä

Ò»¡¢±íµÄµ¼Èëµ¼³öÓï¾ä¼°Ê±¼ä×Ö·û´®²¿·Ö´¦Àíº¯Êý
µ¼³öÊý¾Ý¿âËùÓбíµÄ½á¹¹               mysqldump -uroot -proot db_name -d > d:/export_db.sql(½áβ²»Ó÷ֺÅ)
µ¼³öÊý¾Ý¿âij¸ö±íµÄ½á¹¹               mysqldump -uroot -proot db_n ......

mysqlÔ¶³Ì·ÃÎʵÄÉèÖÃ

µÇ½ÒÔºóÔËÐÐÒÔÏÂÃüÁ¸øÓèÔ¶³Ì·ÃÎʿͻ§¶ËȨÏÞ..
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';
remote±íʾÓû§Ãû.
'172.16.21.39' Ô¶³ÌipµØÖ·
password±íʾԶ³ÌµÇ½ÃÜÂë.
ĬÈÏ×´¿öÏ£¬³öÓÚ°²È«¿¼ÂÇ£¬mysqlÊý¾Ý¿âÆÁ±ÎÁËÔ¶³Ì·ÃÎʹ¦ÄÜ¡£ È»¶øÔÚÐí¶à×´¿öÏ£¬ÄãÐèÒªÔÚ¼Ò
»òÕß´Óweb³ÌÐòÈ¥·ÃÎÊ ......

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

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

mysqlÖÐÓÃÃüÁîÐ޸ıí½á¹¹µÄ·½·¨

ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec …]
alter_specification:
       ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
   or ADD INDEX [index_name] (index_col_name,…)
   or ADD PRIMARY KEY (index_col_name,&hell ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ