Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄʱºòÖ¸¶¨Â·¾¶µÄ¡£ËùÒÔÎÒÃÇ¿ÉÒÔÖ¸¶¨µ½²»Í¬µÄ´ÅÅÌÉÏ£¬½â¾öδÀ´µÄÊý¾Ý´æ´¢Æ¿¾±¡£ºÜ¼òµ¥ºÜÇ¿´ó¡£


Ïà¹ØÎĵµ£º

ubuntu°²×°MySQL£¬Apache

 °²裝MySQL-Server
$ sudo apt-get install mysql-server
°²裝Apache HTTP Server
$ sudo apt-get install apache2
°²裝PHP for Apache HTTP Server
$ sudo apt-get install php5
°²裝MySQL for Apache HTTP Server
$ sudo apt-get install libapache2-mod-auth-mysql
$ sudo apt-get ......

linuxÏÂapache£¬php,mysqlÕûºÏtomcat

1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔ­Òò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......

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ºÅ