首页 > 数据库 > mysql > 正文

ERROR : MySQL server has gone away
2020-03-26 12:50:24 点击:

mysqlslap测试连接数报错如下:mysqlslap: Cannot run query INSERT INTO t1 VALUES (73673339,& 39;BN3152Gza4GW7atxJKACYwJqDbFy
mysqlslap测试连接数报错如下:

mysqlslap: Cannot run query INSERT INTO t1 VALUES (73673339,'BN3152Gza4GW7atxJKACYwJqDbFynLxqc0kh30YTwgz3FktQ43XTrqJ4PQ25frn7kXhfXD8RuzN1j8Rf3y8ugKy6es3IbqPJM6ylCyD6xS7YcQCfHKZxYNvB7yTahm') ERROR : MySQL server has gone away


vi /etc/my.cnf  #增大以下配置值大小

max_allowed_packet = 100M


重启mysql:

service mysqld restart




重新测试,恢复正常。


相关热词搜索:

上一篇:mysqlslap测试mysql数据库性能
下一篇:mysql报错:Your password has expired