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

MySqlÊý¾Ý¿âÖÐÎÄÂÒÂë½â¾ö·½·¨


½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢
¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
   
µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢
Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë
  
Ò³ÃæÖ®¼ä´«µÝ²ÎÊý³öÏÖµÄÂÒÂ룬¾ÍÒª½â¾öÒ³Ãæ±àÂëºÍrequsetµÄ×Ö·û¼¯ÎÊÌ⣬ÔÚ²ÎÊý´«½ø´«³öʱÖØÐÂÉèÖÃÏàÓ¦µÄ×Ö·û¼¯¡£±È
È磺request.setCharacterEncoding("UTF-8");
3¡¢Êý¾Ý¿âÂÒÂ루ÏÂÃæÏêϸ½éÉÜ£©
¶þ¡¢
Êý¾Ý¿âÂÒÂë½â¾ö·½·¨£¨Mysql£©
  
Ò³ÃæºÍÒ³Ãæ´«Öµ¶¼Ã»ÓÐÎÊÌ⣬½á¹û·¢ÏÖ´æ´¢ÔÚÊý¾Ý¿âÖеÄÊý¾Ý³öÏÖÁËÂÒÂ룬ÔòÎÊÌâÊdzöÏÖÔÚÊý¾Ý¿âµÄ±àÂëÎÊÌâ¡£
  
ÏÂÃæÎÒÒÑMySqlÊý¾Ý¿âΪÀý˵Ã÷½â¾ö·½·¨£º
    Èç¹ûÄã°²×°Êý¾Ý¿âµÄʱºò×Ö·û¼¯Ê¹ÓõÄĬÈÏÑ¡Ïlatin1
   
DOSÃüÁîϽøÈëÊý¾Ý¿âshow Ò»ÏÂ×Ö·û¼¯£¨ÃüÁshow variables like"%char%"; £©ÏÔʾÈçÏ£º
Java´úÂë
+--------------------------+---------------+   
| Variable_name            | Value         |   
+--------------------------+---------------+   
| character_set_client     | latin1        |   
| character_set_connection | latin1        |   
| character_set_database   | latin1        |   
| character_set_filesystem | binary        |   
| character_set_results    | latin1        |   
| character_set_server     | latin1        |   
| character_set_system&nbs


Ïà¹ØÎĵµ£º

MySQLÓëÊÂÎñ


×÷ÕߣºÀÏÍõ
MySQL5.X¶¼ÒѾ­·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵģ¬Æäʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃ棬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓ ......

ÅäÖÃMySQLÖ÷´Ó¸´ÖÆ(Replication)


MySQLÖ§³Öµ¥Ïò¡¢Òì²½¸´ÖÆ£¬¸´Öƹý³ÌÖÐÒ»¸ö·þÎñÆ÷³äµ±Ö÷·þÎñÆ÷£¬¶øÒ»¸ö»ò¶à¸öÆäËü·þÎñÆ÷³äµ±´Ó·þÎñÆ÷¡£Ö÷·þÎñÆ÷½«¸üÐÂдÈë¶þ½øÖÆÈÕÖ¾Îļþ£¬²¢Î¬»¤ÈÕÖ¾ÎļþµÄÒ»¸öË÷ÒýÒÔ¸ú×ÙÈÕ־ѭ»·¡£µ±Ò»¸ö´Ó·þÎñÆ÷Á¬½Óµ½Ö÷·þÎñÆ÷ʱ£¬Ëü֪ͨÖ÷·þÎñÆ÷´Ó·þÎñÆ÷ÔÚÈÕÖ¾ÖжÁÈ¡µÄ×îºóÒ»´Î³É¹¦¸üеÄλÖᣴӷþÎñÆ÷½ÓÊÕ´ÓÄÇʱÆð·¢ÉúµÄÈκθüУ¬È ......

sphinxÕûºÏµ½mysql(master/slave)ÖÐ

sphinx°æ±¾Ê¹ÓõÄÊÇcoreseekÐ޸ĵÄÖ§ ³ÖÖÐÎļìË÷µÄ°æ±¾,ÖÐÎÄ´Ê¿âʹÓà coreseek¿ª·¢µÄlibmmseg
mysqlÊÜsphinxÖÐsphinxseÒýÇæÒªÇó°²×°ÁËmysql-5.0.37×öÉú²ú»·¾³µÄmysql-5.0.70µÄ´Ó¿â
±àÒësphinx,libmmsegÒÔ¼°mysql:
±àÒë°²×°libmmseg:
./configure --prefix=/usr/local/mmseg && make -j5 && make instal ......

MySQLÖÐÎÄÂÒÂë½â¾ö·½°¸

˵Ã÷: ÔÚMYSQLÖУ¬Èç¹ûʹÓÃȱʡµÄ×Ö·û¼¯£¬ÔÚ½¨¿â¡¢½¨±íʱ£¬Ä¬ÈÏʹÓõÄÊÇlatin1×Ö·û¼¯£¬
ΪISO 8859-1Î÷Å·×Ö·û¼¯¡£²åÈëÖÐÎÄ×Ö·ûʱ£¬ÓëÖ®²»Æ¥Å䣬¾Í»á³öÏÖÂÒÂë¡£
¡¾½â¾ö·½°¸¡¿
1. ´ò¿ªÎļþ: C:\Program Files\MySQL\MySQL Server 5.0\my.ini;
2. ½«ÆäÖеÄdefault-character-set=latin1¸ÄΪdefault-character-set=gb2312, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ