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

±£³Ö¼òµ¥¼´×îÓÅ 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¾ÍÊÇ"×î¼Ñ·½°¸"¡£



Ïà¹ØÎĵµ£º

mysqlÖвåÈëÒ»Ìõ¼Ç¼·µ»Ø¸Ã¼Ç¼id

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 ......

mysqlÐÂÔöÓû§ºÍµÇ¼


ÐÂÔöÓû§£º
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ÄãµÄÔ¶¶Ëip' IDENTIFIED BY 'ÄãµÄÃÜÂë' WITH GRANT OPTION;
È磺
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.19.220' IDENTIFIED BY '123456' WITH GRANT OPTION;
µÇ¼µ½ÐÂÔöµÄÓû§£º£¨¼ÙÈçÔ­ÊÚȨ»úµÄIPΪ10.10.19.222£©
mysql -uroot  -p123456&n ......

mysql³£¼ûÃüÁî

net  start  mysql    //Æô¶¯mysql·þÎñ
net  stop  mysql    //Í£Ö¹mysql·þÎñ
mysqld-nt  --remove  //ɾ³ýmysqlºǫ́·þÎñ
mysqld-nt  --install    //°²×°mysqlºǫ́·þÎñ
mysqld-nt¿ÉÒÔ»»³Émysqld-max-nt»òmysqld
mysql -u root ......

Hibernate²åÈëmysqlÊý¾Ý¿âÖÐÎÄÂÒÂë½â¾ö


ʹÓÃant¹¤¾ß±àÒë³ÌÐò£¬ÔËÐгÌÐò.ÃüÁî:ant -f xxx.xmlÖ¸¶¨Éú³ÉÎļþ£»ant run±àÒë²¢ÔËÐÐÎļþ¡£
Èç¹ûHibernate½«ÖÐÎIJåÈëmysqlÊý¾Ý¿â£¬µ÷ÓÃselectÓï¾äÖÐÎÄÏÔʾÂÒÂ룬ÔòmysqlµÄ±àÂ뷽ʽÉèΪgbk£¬×¢ÒâÕâÀïÊÇСд£¬²»ÓÃÖØÐ°²×°mysqlÊý¾Ý¿â£¬½«MySQL Server 5.1Ŀ¼ÏµÄmy.iniÅäÖÃÎļþÀïµÄËùÓÐdefault-character-setÉèΪgbk£¬× ......

mysql ÖÐµÄ autocommit ±äÁ¿

mysql> show variables like "autocommit";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit | ON |
+---------------+-------+
1 row in set (0.00 sec)
mysql>
ÉèÖÃÍêÖ®ºó¿´¿´¸ÃÖµ
ÄãÒª¿ªÆôÒ»¸öÊÂÎñ£¬Ö±½Ó·¢ËÍbegin ¡£¡£¡£¡£commit¾Í¿ÉÒÔ£¬ºÎ±ØÒªÈ¥ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ