Got a packet bigger than ‘max_allowed_packet’ bytes,cpp mysql insert multiple values and exceed maximum capacity

admin • 2023年4月19日上午9:11 • C/C++ • 阅读 214

You can also log into MySQL console and run the following command to set max_allowed_packet size for the duration of the session.

set global net_buffer_length=1000000; 
set global max_allowed_packet=1000000000;

When finished above commands,exit and restart mysql then login again.

show variables like 'max_allowed_packet';

Got a packet bigger than 'max_allowed_packet' bytes,cpp mysql insert multiple values and exceed maximum capacity

set global net_buffer_length=1000000;set global max_allowed_packet=1000000000;show variables like 'max_allowed_packet';

exit and login again

Got a packet bigger than 'max_allowed_packet' bytes,cpp mysql insert multiple values and exceed maximum capacity

原文链接: https://www.cnblogs.com/Fred1987/p/16950163.html

欢迎关注

微信关注下方公众号，第一时间获取干货硬货；公众号内回复【pdf】免费获取数百本计算机经典书籍;

也有高质量的技术群，里面有嵌入式、搜广推等BAT大佬

Got a packet bigger than 'max_allowed_packet' bytes,cpp mysql insert multiple values and exceed maximum capacity

原创文章受到原创版权保护。转载请注明出处：https://www.ccppcoding.com/archives/401245

非原创文章文中已经注明原地址，如有侵权，联系删除

关注公众号【高性能架构探索】，第一时间获取最新文章

转载文章受原作者版权保护。转载请注明原作者出处！

Got a packet bigger than ‘max_allowed_packet’ bytes,cpp mysql insert multiple values and exceed maximum capacity

相关推荐