Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»ù´¡²Ù×÷

 1¡¢ÏµÍ³¹ÜÀí
¡¡¡¡mysql -hÖ÷»úµØÖ· -uÓû§Ãû -p
¡¡¡¡Á¬½ÓMYSQL(ÔÚmysql/bin)
¡¡¡¡exit
¡¡¡¡Í˳öMYSQLÃüÁî
¡¡¡¡mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë passwordÐÂÃÜÂë
¡¡¡¡ÐÞ¸ÄÃÜÂë(ÔÚmysql/bin)
¡¡¡¡grantselect[insert][,update][,delete]onÊý¾Ý¿â.*toÓû§Ãû@localhost("%"£¬ ±íʾÈκÎÖ÷»ú)identifiedby "ÃÜÂë"
¡¡¡¡ ......

¿ÉÁ¯µÄ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Îļþ
¡¡¡¡¡¡ ......

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

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

phpµ÷ÓÃmysql´æ´¢¹ý³Ì·µ»Ø¶à¸ö½á¹û¼¯µÄ´¦Àí

 ·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
    select * from `user`.`user` limit 0, 50;
    select coun ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ