具体表现

    2016-08-11T17:34:01.264286Z 36668 [Note] Aborted connection 36668 to db: 'game' user: 'game28' host: 'localhost' (Got an error reading communication packets)
    2016-08-11T17:34:01.264335Z 36672 [Note] Aborted connection 36672 to db: 'game' user: 'game28' host: 'localhost' (Got an error reading communication packets)
    2016-08-11T17:34:01.264337Z 36671 [Note] Aborted connection 36671 to db: 'game' user: 'game28' host: 'localhost' (Got an error reading communication packets)
    2016-08-11T17:35:01.424325Z 36678 [Note] Aborted connection 36678 to db: 'xx' user: 'xx' host: 'localhost' (Got an error reading communication packets)
    2016-08-11T17:35:01.424335Z 36679 [Note] Aborted connection 36679 to db: 'xx' user: 'xx' host: 'localhost' (Got an error reading communication packets)
    2016-08-11T17:35:01.424372Z 36685 [Note] Aborted connection 36685 to db: 'x' user: 'xx' host: 'localhost' (Got an error reading communication packets)
    2016-08-11T17:35:01.424343Z 36680 [Note] Aborted connection 36680 to db: 'xx' user: 'xx' host: 'localhost' (Got an error reading communication packets 

    解决方法

    在my.cnf 文件中,增加 max_allowed_packet =256M

     原因 

    http://dev.mysql.com/doc/refman/5.7/en/communication-errors.html

    The max_allowed_packet variable value is too small or queries require more memory than you have allocated for mysqld

    翻译出来就是,服务器端设定max_allowed_packet的值太小或者查询要求的缓冲内存区比mysqld设定的要大。

     

     

     

    联系QQ:343886028 --加QQ群 145315854