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

Written By
November 14, 2005 04:35PM
Re: change value of max_allowed_packet
November 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.