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


Ïà¹ØÎĵµ£º

java µ÷ÓÃÃüÁî ±¸·ÝmysqlÊý¾Ý¿â

 ´úÂëÈçÏ£º
  1  String command  =   " cmd /c C:/Program Files/MySQL/MySQL Server 5.0/bin>mysqldump -h localhost -u root -p aijia > E:/aijia.dmp " ;
  2      try    {
  3     Process process& ......

java µ÷ÓÃmysql¿Í»§¶Ëµ¼È룬µ¼³öÊý¾Ý

 ×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë 
/**  
 * µ¼ÈëÊý¾Ý  
  * @param  ½Å±¾µÄµØÖ·ºÍÃû³Æ  
 * @return ÊÇ·ñ³ ......

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

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

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

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

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

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