MySQL server has gone away µÄ½â¾ö°ì·¨
ÓÐʱºòʹÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÃüÁîÐе¼È뱸·Ýʱ»á³öÏÖ“MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) server has gone away”´íÎó£¬Õâ¿ÉÄÜÊÇÒòΪÆäÖÐһЩinsertÓï¾äµÄ´óС³¬³öÁËMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)Ä¿Ç°ÉèÖõĻº³åÇø´óС¡£
½â¾ö°ì·¨
1.ʹÓÃphpmyadmin ±¸·ÝMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄʱºò£¬Ö»Ñ¡Ôñ
Êý¾Ý:
ÍêÕû²åÈë
À©Õ¹²åÈë
À©Õ¹²åÈë²»Òª¹´Ñ¡
2.ʹÓà MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)dump ±¸·ÝµÄʱºò²»Ìí¼Ó --opt
ÕâÑù¾ÍÖ»»áÉú³ÉÍêÕûµÄinsertÓï¾ä£¬µ¼Èëʱºò²»»á³ö´í¡£
3.ÐÞ¸Ämy.ini
´ò¿ªmy.ini ÕÒµ½[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]ÕâÒ»ÐУ¬ÏÂÃæÌí¼Ó
[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]
#À©´ó»º³åÇø
max_allowed_packet=32M
±£´æºó£¬ÖØÆôMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
±¾ÎÄÀ´×ÔSunShine£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://do.jhost.cn/sunshine/ReadNews?action=read&id=110
Ïà¹ØÎĵµ£º
±¾ÎÄÈí¼þµÄÏÂÔصØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
1.Ê×ÏÈ£¬ÉèÖÃÊý¾Ý¿âÖ§³ÖÖÐÎÄgb2312/gbk¡£
¾ßÌå·½·¨£º
´ò¿ªmySQLÎļþ¼Ð£¬ÐÞ¸Ämy.iniÅäÖÃÎļþ¡£
[client]
port=3306
default-character-set=gb2312
ÒÔ¼°
[mysqld]쵀
default-character-set=gb2312
Ð޸ģ¬±£´æ£¬ÖØÆô¡£ÈôÉèΪSystem·þÎñ£¬¿ÉÒÔÔÚ¿ØÖÆÃæ°å-¹ÜÀí¹¤¾ß-·þÎñÖÐÕÒµ½mySQL·þÎñ£¬ÖØÆô¡£
2.±£Ö¤Web ......
Another Look at MySQL 5.1's SQL Diagnostic Tools
http://dev.mysql.com/tech-resources/articles/mysql_51_diagnostic_tools.html Êý¾Ý¿âµÄÐÔÄܾö¶¨ÒòËØ£º
£¨1£©Êý¾Ý¿âµÄÉè¼Æ
£¨2£©SQL´úÂë ¿ÉÒÔÓÃÒÔϼ¸ÖÖ·½·¨À´½â¾öһЩÐÔÄÜÎÊÌ⣺
£¨1£©Ë÷Òý
£¨2£©Ë®Æ½·ÖÇø
£¨3£©ÁÐÊÊÓ¦µÄ±í
colum ......
ÔÚmenzhi007µÄblogÀï¿´µ½·Ç³£ÓÐÒâ˼µÄ¶«Î÷£ºhttp://hi.baidu.com/menzhi007/blog/item/c2e98551a18754848c54301c.html
ÔÚmysqlÊÖ²áÀ
http://www.phpchina.com/manual/mysql/functions.html#comparison-operators
MySQL°´ÕÕÒÔϹæÔò½øÐÐÊýÖµ±È½Ï£º
ÈôÓÐÒ»¸ö»òÁ½¸ö²ÎÊýΪ NULL£¬³ý·ÇNULL-safe <=> µÈËã·û£¬Ôò±È ......