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

Mysql½ø»¯ÂÛ2


MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇæ£¿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql£©¡£
¼òµ¥µÄ˵£¬¾ÍÊÇÒ»¸öMysqlÊý¾Ý¿â£¬ÓÐןܶàµÄ´æ´¢·½°¸¡£ÓÉÓÚ²»Í¬µÄ´æ´¢ÒýÇæµÄ´æ´¢·½°¸Óв»Í¬µÄÓÅÊÆÓë²»×㣬ͨ¹ý¶Ô²»Í¬µÄËÑË÷ÒýÇæµÄÖ§³Ö£¬¶ø´ïµ½¸üΪǿ´ó£¬¸üÓе¯ÐÔµÄÊý¾Ý¿â¡£
ÈÃÎÒÃÇÏÈ´ÓÈý¸öÌåϵ½á¹¹¿ªÊ¼£º
A-Mysql·Ö²ãÌåϵ½á¹¹
ÆäÖÐÓ¦ÓòãΪËùÓеÄÓû§ÌṩµÄ½Ó¿Ú£¬Âß¼­²ã°üÀ¨ÁËËùÓкËÐŦÄܵÄʵÏÖ£¬ÎïÀí²ãÓÃÀ´¸ºÔð½«Êý¾Ý´æ´¢ÔÚÓ²ÅÌÉÏ¡£Í¼Öп¿ÓÒϲ»¶µÄÂß¼­²ãµÄ×é³É£¬²éѯ´¦Àí×Óϵͳ£¬ÊÂÎñ¹ÜÀí×Óϵͳ£¬»Ö¸´¹ÜÀí×ÓϵͳºÍ´æ´¢¹ÜÀí×Óϵͳ¹²Í¬×é³ÉÁËMysqlµÄÂß¼­²ã¡£Í¨¹ý´æ´¢¹ÜÀí(Storage Management)À´¹ÜÀíÿ¸ö´æ´¢ÒýÇæ(Storage Engine)¡£
B-ÏêϸÌåϵ½á¹¹
C-MysqlÌåϵ
MysqlÖ§³Ö¶à¸ö´æ´¢ÒýÇæÓÃÀ´¶Ô²»Í¬µÄ±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£Mysql´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎﰲȫ±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎﰲȫ±íµÄÒýÇæ¡£Äã¿ÉÒÔ°´ÕÒϲºÃͨ¹ýÅäÖÃMysqlÀ´ÔÊÐí»ò½ûÖ¹ÈÎÒ»ÒýÇæ¡£*ͨ¹ý¸ü¸ÄSTORAGE_ENGINEÀ´ÅäÖÃĬÈϵĴ洢ÒýÇæ¡£
1.MyISAM¹ÜÀí·ÇÊÂÎï±í¡£ËüÌṩ¸æËß´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡£MyISAMÔÚËùÓÐMysqlÅäÖÃÀï±»Ö§³Ö£¬ÎªMysqlĬÈϵĴ洢ÒýÇæ¡£ËüʵÔÚWeb£¬Êý¾Ý²Ö¿âºÍÆäËûÓ¦Óû·¾³ÏÂ×ʹÓõĴ洢ÒýÇæ¡£
2.MEMORY´æ´¢ÒýÇæÌṩ“ÄÚ´æÖД±í£¬±»È·¶¨ÎªHEAPÒýÇæ.MEMORY½«ËùÓÐÊý¾Ý±£´æÔÚRAMÖУ¬ÔÚÐèÒª¿ìËÙ²éÕÒÒýÓÃºÍÆäËûÀàËÆÊý¾ÝµÄ»·¾³Ï£¬¿ÉÒÔÌṩ¼«¿ìµÄ·ÃÎÊ¡£
3.MERGE´æ´¢ÒýÇæÔÊÐí¼¯ºÏ½«±»´¦ÀíͬÑùµÄMyISAM±í×÷Ϊһ¸öµ¥¶ÀµÄ±í¡£¾ÍÏñMyISAMÒ»Ñù£¬MEMORYºÍMERGE´æ´¢ÒýÇæ´¦Àí·ÇÊÂÎï±í£¬ÓëMEMORYÒýÇæÄ¬Èϰüº¬ÓëMysqlÖС£ÔÊÐíMysql DBA»ò¿ª·¢ÈËÔ±½«Ò»ÏµÁеÈͬµÄMyISAM±íÒÔÂß¼­·½Ê½×éºÏÔÚÒ»Æð£¬²¢×÷Ϊ1¸ö¶ÔÏóÒýÓÃËüÃÇ¡£¶ÔÓÚÖîÈçÊý¾Ý²Ö¿âµÈVLDB»·¾³Ê®·ÖÊʺϡ£
4.InnoDBºÍBDB´æ´¢ÒýÇæÌṩÊÂÎﰲȫ±í¡£BDB±»°üº¬ÔÚΪ֧³ÖËüµÄ²Ù×÷ϵͳ·¢²¼µÄMysql-max¶þ½øÖÆ·Ö·¢°æÖС£InnoDBҲĬÈϰüÀ¨ÔÚÆäÖС£InnoDB¶àÓÃÓÚÊÂÎï´¦ÀíÓ¦ÓóÌÐò£¬¾ßÓÐÖÚ¶àÌØÐÔ£¬°üÀ¨ACIDÊÂÎïÖ§³Ö¡£¶øBDB¿ÉÒÔÌæ´úInnoDBµÄÊÂÎïÒýÇæ£¬Ö§³ÖCOMMIT,ROLLBACKºÍÆäËûµÄÊÂÎïÌØÐÔ¡£
5.ECAMPLE´æ´¢ÒýÇæÊÇÒ»¸ö"´æ¸ù"ÒýÇæ¡£Í¨¹ý´ËÒýÇæ´´½¨±í£¬µ«Ã»ÓÐÊý¾Ý±»´æ´¢ÓÚÆäÖлò´ÓÖмìË÷¡£Õâ¸öÒýÇæµÄÄ¿µÄÊÇ


Ïà¹ØÎĵµ£º

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ÐÔÄÜÓÅ»¯2

 MySQL´Ó4.1¿ªÊ¼Ö§³ÖSQLµÄ×Ó²éѯ¡£Õâ¸ö¼¼Êõ¿ÉÒÔʹÓÃSELECTÓï¾äÀ´´´½¨Ò»¸öµ¥ÁеIJéѯ½á¹û£¬È»ºó°ÑÕâ¸ö½á¹û×÷Ϊ¹ýÂËÌõ¼þÓÃÔÚÁíÒ»¸ö²éѯÖС£ÀýÈ磬ÎÒÃÇÒª½«¿Í»§»ù±¾ÐÅÏ¢±íÖÐûÓÐÈκζ©µ¥µÄ¿Í»§É¾³ýµô£¬¾Í¿ÉÒÔÀûÓÃ×Ó²éѯÏÈ´ÓÏúÊÛÐÅÏ¢±íÖн«ËùÓз¢³ö¶©µ¥µÄ¿Í»§IDÈ¡³öÀ´£¬È»ºó½«½á¹û´«µÝ¸øÖ÷²éѯ£¬ÈçÏÂËùʾ£º
DELETE from ......

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

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

Mysql¡¢Apache¡¢PhpµÄÐ¶ÔØ (Linux)

 Ð¶ÔØMysql
[root@localhost ~]# rpm -qa | grep mysql
mysql-3.23.58-9
php-mysql-4.3.4-11
mod_auth_mysql-20030510-4.1
mysql-server-3.23.58-9
˵Ã÷£ºrpm –qa | grep mysql ÃüÁîÊÇΪÁ˰ÑmysqlÏà¹ØµÄ°ü¶¼ÁгöÀ´£¬Ð¶Ôض¼´Ó×îÏÂÃæµÄÒ»¸ö°ü¿ªÊ¼£¬Ö±µ½Ð¶ÔصôµÚÒ»¸öΪֹ¡£Ö´ÐÐrpm -q php£¬Èç¹û·µ»Øphp°æ±¾£¬ ......

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

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