MySQL Forums :: Database Administration & Monitoring :: change value of max_allowed_packet

Advanced Search

Re: change value of max_allowed_packet
Posted by: Arun Venkatesan ()
Date: November 25, 2005 01:41AM

You could do it in either of the following ways:

1. Change in the my.ini file. Include the single line under [mysqld] in your file

# sets max_packet to 500 MB

now restart the MySQl service and you are done

2. At the command prompt, execute the foll. command
mysql> set global max_allowed_packet = 500 * 1024 * 1024;

This will set the global max packet size to 500 MB. All subsequent MySQL client connections will get this value as their session value for max packet

Options: ReplyQuote

Subject Written By Posted
change value of max_allowed_packet Kevin Wen 11/14/2005 04:35PM
Re: change value of max_allowed_packet Arun Venkatesan 11/25/2005 01:41AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.