±£³Ö¼òµ¥¼´×îÓÅ 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¾ÍÊÇ"×î¼Ñ·½°¸"¡£
Ïà¹ØÎĵµ£º
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 ......
ÐÂÔöÓû§£º
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 ......
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 ......
ʹÓÃ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> show variables like "autocommit";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit | ON |
+---------------+-------+
1 row in set (0.00 sec)
mysql>
ÉèÖÃÍêÖ®ºó¿´¿´¸ÃÖµ
ÄãÒª¿ªÆôÒ»¸öÊÂÎñ£¬Ö±½Ó·¢ËÍbegin ¡£¡£¡£¡£commit¾Í¿ÉÒÔ£¬ºÎ±ØÒªÈ¥ ......