Hibernate + MYSQL½áºÏ´æ´¢ Blob ºÍ ClobÄÚÈÝ
½ñÌ죬ÕÛÌÚÁËÒ»¸öÏÂÎ磬ÖÕÓÚ½â¾öÁËHibernate ´æ´¢Blob×Ö¶Îʱ£¬Êý¾ÝÁ¿·Ç³£´óʱ×ÜÊDZ¨ can not update jdbc batchµÄ´íÎóÁË£¬ÔÀ´ÊÇMySQLÖÐûÓÐÉ趨×î´óÔÊÐíÖµËùÖ£¬ÎÒ»¹ÒÔΪÊÇHibernate²Ù×÷²»·ûºÏ±ê×¼²ÅÕâÑù¡£¡£¡£ºÇºÇ£¬ÔÚMysql 5.1ÖеÄmy.iniÅäÖÃÎļþÖмÓÈëÈçÏÂÉèÖãº
[MYSQL]
max_allowed_packet = XXXM (XXXΪ×î´óÖµ£¬MΪÕ×£¬Ò²¿ÉÒÔÓÃ1024*1024À´ÅäÖÃ)
ÕâÀï¼Ç¼ÏÂÀ´£¬ÒòΪÎÒÊDzËÄñ£¬ÎªÁ˱¸Íü°¡£¡£¡£¡£¡¹þ¹þ¹þ
Ïà¹ØÎĵµ£º
¼ÌTwitterÖ®ºó£¬Éç½»ÐÂÎÅÍøÕ¾Digg¾ö¶¨¸úMySQL˵ÔÙ¼û£¬²¢Ìæ»»µôËüµÄ´ó²¿·Ö»ù´¡ÉèÊ©×é³É£¬Digg½«´ÓLAMP£¨Linux¡¢ Apache¡¢MySQLºÍPerl/PHP/Python£©¼Ü¹¹Ç¨ÒƵ½»ùÓÚCassandraµÄNoSQL¼Ü¹¹¡£
¡¡¡¡Apache CassandraÊÇÒ»Ì׿ªÔ´·Ö²¼Ê½Êý¾Ý¿â¹ÜÀíϵͳ£¬×î³õÓÉFacebook¿ª·¢£¬ÓÃÓÚ´¢´æÌرð´óµÄÊý¾Ý¡£Cassa ......
ÐèÇó1£ºÔÚÒ»¸öselect ²éѯ¼¯ÖÐÔٴβéѯ
SELECT * from (SELECT field from table) AS alias
ÐèҪעÒâºóÃæµÄalias£¬ÔÚmysqlÖУ¬ÕâÊDZØÐëµÄ
ÐèÇó2£ºÒ»¸ö²éѯ¼¯µÄ½á¹û²»ÔÚÁíÒ»¸ö²éѯ¼¯ÖÐ
SELECT feild1 from table1 WHERE feild1 NOT IN (SELECT field2 from table2)
ÐèҪעÒ⣬ӦÓÃIN/NOT IN×Ó¾äʱ£¬±ØÐëÖ¸¶¨²éѯ×Ö¶ÎÃû£ ......
ÉèÖÃMySQLÊý¾Ýͬ²½£¨µ¥Ïò&Ë«Ïò£©
ÓÉÓÚ¹«Ë¾µÄÒµÎñÐèÇó£¬ÐèÒªÍøͨºÍµçÐŵÄÊý¾Ýͬ²½£¬¾Í×öÁ˸öMySQLµÄË«Ïòͬ²½£¬¼ÇϹý³Ì£¬ÒÔºóÓõõ½ÔÙ·³öÀ´£¬Ò²Ìù³öÀ´¹©´ó¼Ò²Î¿¼¡£
Ò»¡¢×¼±¸·þÎñÆ÷
ÓÉÓÚMySQL²»Í¬°æ±¾Ö®¼äµÄ(¶þ½øÖÆÈÕÖ¾)binlog¸ñʽ¿ÉÄܻ᲻һÑù£¬Òò´Ë×îºÃµÄ´îÅä×éºÏÊÇMasterµÄMySQL°æ±¾ºÍSlaveµÄ°æ±¾Ïàͬ»òÕ߸üµÍ£¬Ma ......
µ±ÄãÁ¬½ÓÒ»¸öMySQL·þÎñÆ÷ʱ£¬Äãͨ³£Ó¦¸ÃʹÓÃÒ»¸ö¿ÚÁî¡£¿ÚÁî²»ÒÔÃ÷ÎÄÔÚÁ¬½ÓÉÏ´«Êä¡£
ËùÓÐÆäËûÐÅÏ¢×÷ΪÄܱ»ËùÓÐÈ˶Á¶®µÄÎı¾±»´«Êä¡£Èç¹ûÄãµ£ÐÄÕâ¸ö£¬Äã¿ÉʹÓÃѹËõÐÒé(MySQL3.22ºÍÒÔÉÏ°æ±¾)ʹÊÂÇé±äµÃ¸üÄÑ¡£ÉõÖÁΪÁËʹһÇиü°²È«£¬ÄãÓ¦¸Ã°²×°ssh£¨¼ûhttp://www.cs.hut.fi/ssh)¡£ÓÃËû£¬ÄãÄÜÔÚÒ»¸öMySQL·þÎñÆ÷ºÍÒ»¸öMySQL¿Í» ......
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£¨ÍêÈ«±¸·Ý£¬ÊʺÏСÐÍÊý¾Ý¿â±¸·Ý£©
±¸·Ý²ßÂÔ ......