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

MySQL ±àÂë»úÖÆ

Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ
¶¼ÊÇÓà set NAMES character
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharacter_set_resultsÖÐÉ趨µÄ×Ö·û¼¯·¢Ë͸øÓû§¡£
DISCUZ²¢Ã»ÓÐʹÓÃset NAMES character

SET NAMES 'x'Óï¾äÓëÕâÈý¸öÓï¾äµÈ¼Û£º
mysql> SET character_set_client = x; mysql> SET character_set_results = x; mysql> SET character_set_connection = x;
¶øDISCUZÀïÃæÊÇ
¸´ÖÆ´úÂë
´úÂëÈçÏÂ:
@mysql_query("SET
character_set_connection=$dbcharset, character_set_results=$dbcharset,
character_set_client=binary", $this->link);
SET character_set_client = binary;ʹÓöþ½øÖÆ×Ö·û¼¯²éѯ
´ËÈý´¦µÄ×Ö·ûÉ趨ºÜ´ó³Ì¶ÈÉÏ»á½â¾öÂÒÂëÎÊÌ⣬ÄÇô×ÅÈý¸öÉ趨¾ßÌåÓÐʲô×÷ÓÃÄØ£¿
character_set_client
Ö¸
¶¨µÄÊÇSqlÓï¾äµÄ±àÂ룬Èç¹ûÉèÖÃΪ binary£¬mysql¾Íµ±¶þ½øÖÆÀ´´¦Àí£¬character_set_connectionÖ¸¶¨ÁËmysql
ÓÃÀ´ÔËÐÐsqlÓï¾äµÄʱºòʹÓõıàÂ룬Ҳ¾ÍÊÇ˵£¬³ÌÐò·¢Ë͸øMySQL
µÄSQLÓï¾ä,»áÊ×Ïȱ»MySQL´Ócharacter_set_clientÖ¸¶¨µÄ±àÂëת»»µ½character_set_connectionÖ¸¶¨µÄ
±àÂ룬Èç¹ûcharacter_set_clienÖ¸¶¨µÄÊÇbinary£¬ÔòMySQL¾Í»á°ÑSQLÓï¾ä°´ÕÕ
character_set_connectionÖ¸¶¨µÄ±àÂë½âÊÍÖ´ÐÐ.
µ±Ö´ÐÐSQLÓï¾äµÄ¹ý³ÌÖУ¬±ÈÈçÏòÊý¾Ý¿âÖвåÈë×ֶεÄʱºò£¬×Ö¶ÎÒ²ÓÐ
±àÂëÉèÖã¬Èç¹û×ֶεıàÂëÉèÖúÍcharacter_set_connectionÖ¸¶¨µÄ²»Í¬£¬ÔòMySQL
»á°Ñ²åÈëµÄÊý¾Ýת»»³É×Ö¶ÎÉ趨µÄ±àÂë¡£SQLÓï¾äÖеÄÌõ¼þÅжϺÍSQL²åÈëÓï¾äµÄÖ´Ðйý³ÌÀàËÆ.
µ±SQLÖ´ÐÐÍê±ÏÏñ¿Í»§¶Ë·µ»ØÊý¾ÝµÄʱºò£¬»á
°ÑÊý¾Ý´Ó×Ö¶ÎÖ¸¶¨µÄ±àÂëת»»Îªcharacter_set_resultsÖ¸¶¨µÄ±àÂ룬Èç¹ûcharacter_set_results=NULL
Ôò²»×öÈκÎת»»¶¯×÷£¬£¨×¢ÒâÕâÀïÉèÖÃΪNULL²»µÈÓÚûÓÐÉèÖã¬Ã»ÓÐÉèÖõÄʱºòMySQL»á¼Ì³ÐÈ«¾ÖÉèÖã©,
¹¤×÷ÖбȽÏÓÐÓõľÍÊÇÀûÓÃMySQL½øÐÐתÂë¡¢²»Í¬±àÂëµÄÊý¾Ý¿âÖ®¼ä¹²ÓÃÊý¾Ý¡£


Ïà¹ØÎĵµ£º

MysqlÖ÷´Ó·þÎñÆ÷µÄÅäÖñʼÇ

×¢: ´ÓMySQL´Ó·þÎñÆ÷µÄ°æ±¾²»ÄÜСÓÚÖ÷·þÎñÆ÷µÄ°æ±¾ ʵÑé»·¾³ Master Mysql·þÎñÆ÷°æ±¾5.1.36,IP:192.168.128.130 Slave Mysql·þÎñÆ÷°æ±¾5.1.36,IP:192.168.128.132 Ò». MySQLÖ÷·þÎñÆ÷ÅäÖà 1.½¨Á¢ÊÚȨÓû§ Ó÷¨:grant replication slave on *.* to ¡®Óû§Ãû¡¯@'Ö÷»ú¡¯ identified by ¡®ÃÜÂ롯; mysql>grant replicatio ......

ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â


ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â
Ô­ÎÄ£ºhttp://blogs.mysql.com/kaj/2007/12/10/combining-mysql-proxy-with-mysql-cluster/
       ²»¾Ãǰ£¬ÎÒºÍStewart Smith, Vinay Joosery, Monty Taylor ÒÔ¼°ÆäËûµÄmysqlʹÓÃÕߣ¨ËûÃDZÈÎÒ¸üÊìϤMySQL Cluster £©Õ¹¿ªÁËÒ»´ÎÌÖÂÛ£ ......

¹ØÓÚMySQLµÄLIMIT Ó﷨СÓÅ»¯£¡

   
½ñÌìÓÐÅóÓÑÎÊÆð´ËÀàÓï¾äµÄÓÅ»¯£¬ÎÒ´óÖ¸øËû½éÉÜÁËÏ´ÓSQL½Ç¶È×ö¼òµ¥µÄÓÅ»¯£¬ÖÁÓÚÓ¦ÓóÌÐò·½ÃæµÄ¿¼ÂÇÔÛÔÝʱ²»¿¼ÂÇ¡£
ÏÂÃæÎÒÀ´¾ÙÒ»¸ö
¼òµ¥µÄÀý×Ó¡£
¿¼ÂÇÈçÏÂ
±í½á¹¹£º
/*DDL Information
For - t_girl.t_page_sample*/
----------------------------------------------
Table   ......

hibernate+mysql Á¬½Ó³¬Ê±½â¾ö°ì·¨Ò»£¬£¨ÍøÉÏÕҵģ©


½â¾öhibernate+mysql³öÏֵĸôÌìÁ¬½Ó³¬Ê±ÎÊÌâ
³öÏÖ´íÎó£ºSQL Error: 0, SQLState: 08S01
Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Software caused connection abort: socket write error
STACKTRACE:
java.net.SocketExcepti ......

½â¾ömySQLÕ¼ÓÃÄڴ泬´óÎÊÌâ

½â¾ömySQLÕ¼ÓÃÄڴ泬´óÎÊÌâ
ΪÁË×°mysql»·¾³²âÊÔ£¬×°ÉϺó·¢ÏÖÆô¶¯ºómysqlÕ¼ÓÃÁ˺ܴóµÄÐéÄâÄڴ棬´ï8°Ù¶àÕס£ÍøÉÏËÑË÷ÁËһϣ¬µÃµ½¸ßÈËÖ¸µãmy.ini¡£ÔÙҲû¼ûÔÙÏêϸµÄÁË..Ö»ºÃ´ò¿ªmy.iniÖðÐеĿУ¬ËäȻӢÎIJîÁ˵㣬²»¹ý¶àÉÙM»¹ÊÇ¿´µÃÃ÷µÄ^-^
 
¸ü¸ÄºóÈçÏ£º
innodb_buffer_pool_size=576M ->256M InnoDBÒýÇæ»º³å ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ