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´æ´¢ÒýÇæÊÇÒ»¸ö"´æ¸ù"ÒýÇæ¡£Í¨¹ý´ËÒýÇæ´´½¨±í£¬µ«Ã»ÓÐÊý¾Ý±»´æ´¢ÓÚÆäÖлò´ÓÖмìË÷¡£Õâ¸öÒýÇæµÄÄ¿µÄÊÇ
Ïà¹ØÎĵµ£º
½¨Á¢Ò»¸öÖ÷Íâ¼ü¹ØÏµ
create table t_dept(
id int(4) not null, name varchar(50) not null,
primary key(id))type=innodb;
create table t_emp (
id int(6) not null,
name char(255) not null,fk_id int(4) not null,
primary key(id),
foreign key (fk_id) references t_dept (id)) type=innodb; ......
1.Ç°ÃæÒ»ÆªÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔÒò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......
1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐкÃ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» £¯£¯´ò¿ª¿â£¬Ñ§¹ýFOXBASEµÄÒ»¶¨²»»áİÉú°É
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
describe ±í ......
1.Ëü¿ÉÒÔ±»·ÖΪÈýÀࣺÊý×ÖÀàÐÍÈÕÆÚÀàºÍʱ¼äÀàÐÍ£¬×Ö·û´®ÀàÐÍ¡£
ÁÐÀàÐÍÓÃÓÚÃèÊö:
M£ºÖ¸³ö×î´óµÄÏÔʾ³ß´ç¡£×î´óµÄºÏ·¨ÏÔʾ³ß´çΪ255.
D£ºÊÊÓÃÓÚ¸¡µãÀàÐͲ¢Ö®³õ¸úËæÔÚÊ®½øÖÆÐ¡ÊýµãºóµÄÊýÂëµÄÊýÁ¿¡£×î´óµÄ¿ÉÄÜÖµÊÇ30£¬µ«ÊDz»Ó¦´óÓÚM.
2.·½À¨ºÅ("[","]")Ö¸³ö¿ÉÑ¡µÄÀàÐÍÐÞÊηûµÄ²¿·Ö£®
£ªÈôÖ¸¶¨ÁËÁÐÀàÐÍΪZEROFILL,MYSQL½«¸Ã ......