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


Ïà¹ØÎĵµ£º

MySql¼òÒױʼÇ


MySql¼òÒױʼÇ
 
 
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
 
 
2£º´ò¿ªmysqlµÄCMD
 
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHA ......

¹ØÓÚÅ·Ã˾ÜÅú¼×¹ÇÎÄÊÕ¹ºMYSQL¡£¡£

   Ò»°ãÈË×ÜÊÇÒòΪĿ¹â¶Ìdz¶ø´íʧ׬Ǯ»ú»á£¬larry ÔÚÑ۹ⷽÃæ×ÜÄÜ¿´µÄ³¤Ô¶£¬ÒÔǰһϵÁеÄÊÕ¹º×ãÒÔÖ¤Ã÷¡£²»¹ýÕâ´Î¾Ü¾øÅ·ÃË»á¸øOracle´øÀ´ºÜ´óµÄÂé·³£¬Å·ÖÞÊг¡²»ÒªÁË£¿ ÎÒ²ÂÒ²Ðí»á´ò¹Ù˾¡£ Oracle¶ÔSAPÏòÀ´³ðÊÓ£¬Õâ´ÎSAPÀûÓÃÅ·ÃË´òÁËÒ»¸öƯÁÁµÄ·ü»÷Õ½£¬½ÓÏÂÀ´¾Í¿´OracleÔõô·´»÷ÁË£¬ÊÃÄ¿ÒÔ´ý¡£
   ......

ʹÓà MySQL Workbench ¿ÉÊÓ»¯µÄÉè¼Æ MySQL Êý¾Ý¿â

MySQL Workbench ÊÇ MySQL ×î½üÊͷŵĿÉÊÓÊý¾Ý¿âÉè¼Æ¹¤¾ß¡£Õâ¸ö¹¤¾ßÊÇÉè¼Æ MySQL Êý¾Ý¿âµÄרÓù¤¾ß¡£
ÄãÔÚ MySQL Workbench Öн¨Á¢µÄ±»³Æ֮ΪÎïÀíÊý¾ÝÄ£ÐÍ¡£Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍÊÇÕë¶ÔÒ»¸öÌض¨ RDBMS ²úÆ·µÄÊý¾ÝÄ£ÐÍ£»±¾ÎÄÖеÄÄ£Ðͽ«¾ßÓÐһЩ MySQL µÄ¶ÀÌع淶¡£ÎÒÃÇ¿ÉÒÔʹÓÃËüÉú³É£¨forward-engineer£©Êý¾Ý¿â¶ÔÏ󣬳ýÁË°üº¬± ......

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ

À´Ô´£ºhttp://www.blogjava.net/Alpha/archive/2007/07/23/131912.html 
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ......

MySQL 6 ÂÌÉ«¾«¼òBAT°æ

 
¹Ø¼ü×Ö: mysql6 mysql6ÏÂÔØ
×÷ΪһÃû¿ª·¢ÈËÔ±,ÎÒ¶ÔÂÌɫСÈí¼þÇéÓжÀÖÓ,ÒòΪÓÃÆðÀ´·½±ã¿ì½ÝÂï,±ãÓÚЯ´ø,Ò×ÓÚÔÚÑÝʾϵͳÖÐʹÓÃ,¿ª·¢Ê±¿ÉÁ¢¼´½øÈë״̬. £¨ÔÚ¸½¼þÖУ©
ÒÔÏÂÊÇÏêϸ˵Ã÷:
MySQL 6 ÂÌÉ«¾«¼ò°æ(BAT°æ±¾)
        MySQL 6 Ö§³ÖÍâ¼ü,ÊÓͼ´æ´¢¹ý³Ì,ÊÂÎñµÈ¹¦ÄÜ(ÂÌÉ«¾« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ