How to change max_allowed_packet value in mysql?

If you set it in the cnf(it may be my.ini file) you will likely need to restart the server. Optionally, that is a dynamic variable and can be SET GLOBAL or SET SESSION from the command line as well.So just do as follows.

mysql>show variables like’max_allowed_packet’;

mysql>set global max_allowed_packet=67108864;

mysql>exit;

Note: If you don't use global or use session,after execute exit command,max_allowed_packet value will be still 1048576.

评论

3 楼 阿浊I 2012-02-15  

I think so,this work had done at two years ago

2 楼 zhuorulin 2012-02-15  

丁林.tb 写道

If you don't use global or use session, it is the same with useing session

yes, it will be better to understand, just mean you only update the session, not the whole mysql instance.

1 楼 丁林.tb 2012-02-14  

If you don't use global or use session, it is the same with useing session