±£³Ö¼òµ¥¼´×îÓÅ MysqlµÄ²¿ÊðÔÔò
½ñÌì¶Áµ½
When should you store serialized objects in the database?
£¬
ÆäÖÐÕë¶Ô
FriendFeedʹÓÃMysqlÀ´´æ´¢
×÷ΪÒýÌ⣬
½¨ÒéÔÚ¿¼ÂÇ´Ë·½°¸Ê±Ò»¶¨ÒªÈý˼¡£ÎªÊ²Ã´£¿²Î¿¼ÕâÀï
Kiss KISS KISS
. Æäʵ
Schema-LessûÓÐ´í£¬µ«²»ÄÜʲô³¡¾°¶¼ÉÏ´Ë·½°¸£¬Òª
·ÖÎöÀû±×£¬¼õÉÙ²»±ØÒªµÄÓ¦Óò㸴ÔÓ¶È¡£
ÎÄÖÐÌáµ½µÄSerialized objectsµÄ±£´æ¼¼Êõ£¬¾ÍÊÇ(entity-attribute-value) EAV, ˵һÏÂ×ܽáµÄȱµã£º
1.Ëü¶ÔËÑË÷²»ÓѺ㨶¼Ñ¹Ëõ´æÔÚÒ»×Ö¶ÎÀ¿Ï¶¨²»ÄÜËÑË÷£©£¬ÕâȷʵÊÇÒ»¸öÎÊÌâ¡£FriendFeedʹÓñäÏàindex£¬½â¾öÁËËüÐèÒª½â¾öµÄÎÊÌâ¡£µ«Ö»ÄÜÊǹæ±Ü¡£
2.Select¾«È·Ñ¡Ôñ×Ö¶ÎÊDz»³ÉÁË£¬Ã¿´Î¶¼ÊÇSELECT * from xx,µ±È»Ê¹ÓÃMemcache¿ÉÒÔºÜÉٵĽâ¾ö´ËÎÊÌâ¡£
3.²»
ÄܼÓÔ¼Êø(constraints)£¬Ó¦ÓòãÐèÒª×÷УÑ飬Æäʵ¾ÍÊÇÔö¼ÓÁËÊý¾Ý²ãµÄ¸´ÔÓ¿â¡£
4.Èç¹ûʹÓÃJson£¬²»ÄÜʹÓÃNumberºÍIPµÄÔʼÐÎʽ´æ´¢£¬±ØÐëת»»³ÉString¡£ÕâµãºÃÏñ²»ÊÇÄÇÃ´ÖØÒª£¬ÒòΪÎÒÃÇ¿ÉÒÔʹÓõÄÎı¾ÐÒéÓкܶࡣ±ÈÈçGoogleµÄ
protobuf
Æäʵ×îÖØÒªµÄÔÔòÔÚKiss KISS KISS
ÖÐÒѾ˵µÄºÜÇå³þ¡£¶ÔÓÚ¸Õ¿ªÊ¼µÄÓ¦Óã¬Ê¹ÓÃMaster-slaver×ãÒÔ¡£²»ÒªÊ¹ÓÃʲô"ÓÅ»¯"£¬ÄÇЩ
Æäʵ¾ÍÊÇ"³¶µ"¡£¶ÔÓÚScaling out·½°¸¸üÊÇÓ¦¸Ã¼òµ¥ÓÐЧΪÖ÷£¬Ëµ°×ÁË£¬¶ÔÓÚMysql¶øÑÔ£¬Ò»Ì¨Master¼°Ò»Ì¨»ò¼¸Ì¨slaver¾ÍÊÇ"×î¼Ñ·½°¸"¡£
Ïà¹ØÎĵµ£º
Ò»¡¢CREATE TABLE ·½·¨
Õû±í¸´ÖÆ # create table бí select * from ¾É±í;
½á¹¹¸´ÖÆ # create table бí select * from ¾É±í where 1<>1;
¶þ¡¢INSERT INTO ·½·¨
µÃµ½½¨±íÓï¾ä # show create table ¾É±í;
н¨±í
¸´ÖÆÊý¾Ýµ½Ð±í INSERT INTO new_table(col1,col2,...) (SELECT col1,col2,... from old_table); ......
1.select max(id) from user;
2.select last_insert_id() as id from user limit 1;
(Õâ¸ö²âÊԵķµ»ØidÒ»Ö±ÊÇ0£¬ÓеãÎÊÌâ)
3.´¢´æ¹ý³Ì
1£©
oracelÖÐ
create sequence seqID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
nocache
order;
create or replace procedure ......
Ò»¡¢ÊÂÎñ´¦Àí£¨myisamÒýÇæ²»Ö§³ÖÊÂÎñ£¬innodbÒýÇæÖ§³ÖÊÂÎñ£©
£¨1£©start transaction
£¨2£©commit
£¨3£©rollback£¬rollback to [savepoint name]
£¨4£©savepoint [savepoint name]
£¨5£©set autocommit=0 or 1
£¨6£©release savepoint [savepoint name]
×¢Ò⣺create¡¢dropµÈ²Ù×÷£¬²»ÄÜ»ØÍË
¶þ¡¢×Ö·û¼¯
1.×Ö·û±àÂë ......
ʹÓÃant¹¤¾ß±àÒë³ÌÐò£¬ÔËÐгÌÐò.ÃüÁî:ant -f xxx.xmlÖ¸¶¨Éú³ÉÎļþ£»ant run±àÒë²¢ÔËÐÐÎļþ¡£
Èç¹ûHibernate½«ÖÐÎIJåÈëmysqlÊý¾Ý¿â£¬µ÷ÓÃselectÓï¾äÖÐÎÄÏÔʾÂÒÂ룬ÔòmysqlµÄ±àÂ뷽ʽÉèΪgbk£¬×¢ÒâÕâÀïÊÇСд£¬²»ÓÃÖØÐ°²×°mysqlÊý¾Ý¿â£¬½«MySQL Server 5.1Ŀ¼ÏµÄmy.iniÅäÖÃÎļþÀïµÄËùÓÐdefault-character-setÉèΪgbk£¬× ......