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

mysql Êý¾Ý´æ´¢×ܽá

ÓÉÓÚ×î½üÒ»Ö±ÔÚÁ˽âmysql¡£¸÷ÖÖ±íÀàÐ͵ÄÊý¾Ý´æ´¢ÒÔ¼°Ïà¹ØÏÞÖƾÍÊDZØÐëÁ˽âµÄ·½ÃæÁË¡£
×Ô¼ºµÄ·þÎñÆ÷»·¾³£ºOS Cent OS ext3£¬memory 4G£¬ disk 2T block size 4K¡£
¾­µ÷²é£¬linuxÏÂÎļþ×î´óÊÇ´æÔÚÏÞÖƵġ£È¥googleÉÏËÑÁËËÑ£¬´ó¼Ò˵·¨²»Ò»£¬×îÖÕ×Ô¼º»¹ÊÇÕÒµ½±È½Ï¹Ù·½µÄ˵¡£Ïê¼ûhttp://en.wikipedia.org/wiki/Ext3 ËùÒÔ×Ô¼ºµÄ·þÎñÆ÷×î´óÎļþÏÞÖÆΪ2T¡£
Õâµã¸ãÇå³þºó£¬ÔÚÊý¾Ý¿â²¿ÊðÉè¼ÆÉϾ͵ÿ¼Âǵ½Õâµã¡£
¼òµ¥ËµÒ»ÏÂ×Ô¼ºµÄÊý¾Ý¿â¼Ü¹¹£¬ÊDzÉÓñȽÏͨÓúͳÉÊìµÄ×ö·¨£¬¼´£º2¸ömaster£¬Ö®¼ä´æÔÚHA£»N¸öslaves£¬¸ºÔØ·Öµ£¶ÁµÄ¸ºÔØ¡£masterºÍslaves²ÉÓÃreplicationÒ첽ͬ²½¡£masterÉϵÄÊý¾Ý¿â±íÀàÐÍΪinnodb£¬¸ÃÀàÐÍÓÐÊÂÎïµÄ¸ÅÄ²¢ÇÒÊʺÏƵ·±¶Áд¡£slavesÊý¾Ý¿â²ÉÓÃmyisam±íÀàÐÍ£¬¿ÉÒÔ¸üºÃµÄ´¦Àí¶ÁÇëÇó¡£ËùÒÔÔÚ´ËÌÖÂÛÕâÁ½ÖÖÀàÐÍÊý¾ÝµÄ´æ´¢ÐÎʽ¡£
innodbĬÈϵÄÊǹ²Ïí±í¿Õ¼äµÄ£¬ÕâµãÔÚmysql¹Ù·½ÍøÕ¾ÎĵµÉÏÓкÜÃ÷È·µÄ˵Ã÷¡£ÎҾͲ»·Ñ»°ÁË¡£Èç¹û²ÉÓù²Ïí±í¿Õ¼ä£¬¿ÉÒÔÅäÖöà¸öÊý¾ÝÎļþµ½²»Í¬µÄ´ÅÅÌ£¬À´½â¾öÊý¾Ý´æ´¢Æ¿¾±¡£µ«ÊÇ×Ô¼ºÊ¼ÖÕ¾õµÃ£¬´óÎļþ²¢²»Ì«ÀûÓÚά»¤£¬ÀïÊý¾ÝÒƶ¯µÈ¡£ËùÒÔ»¹¿ÉÒÔ²ÉÓÃper-table±í¿Õ¼ä£¬µ«ÊÇÎÊÌâÓÖ¾ÍÀ´ÁË£¬Ã¿¸ö±íµÄÊý¾ÝºÃÏñÖ»ÄÜ´æ´¢µ½mysqlÅäÖõÄÊý¾ÝĿ¼ÄÚ¡£Õâµã×Ô¼ºÃ»ÓÐÕÒµ½ºÏÊʵĽâ¾ö·½°¸¡£
myisam±íÀàÐÍ£¬ËüµÄindex±íºÍdata±í¶¼ÊÇ¿ÉÒÔÔÚcreate tableµÄʱºòÖ¸¶¨Â·¾¶µÄ¡£ËùÒÔÎÒÃÇ¿ÉÒÔÖ¸¶¨µ½²»Í¬µÄ´ÅÅÌÉÏ£¬½â¾öδÀ´µÄÊý¾Ý´æ´¢Æ¿¾±¡£ºÜ¼òµ¥ºÜÇ¿´ó¡£


Ïà¹ØÎĵµ£º

¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË

write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂ붼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42    Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68    ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMaster·þÎñÆ÷
¡¡¡¡1¡¢±à¼­MasterÉϵÄ/etc/my.cnfÎļþ
¡¡¡¡¡¡ ......

MySQL²éѯµÄÐÔÄÜÓÅ»¯

²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½ÓÉ¿Í»§¶Ë·¢À´µÄSQLÓï¾äºó£¬Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ø ......

Mysql½ø»¯ÂÛ2


MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇ棿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql ......

MySQL ÃüÁîÐÐ

 MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ