This is a MySQL question in Elasticsearch discussion, you can not expect many answers.
Consider the following:
the data size has nothing to do with max_allowed_packet. There is no practical limit.
the default max_allowed_packet can be viewed with show variables like 'max_allowed_packet' in MySQL client.
Increase number carefully. A number too high will have massive impact on your system, it will not work any more. Maximum should be around 16M. 1G is much too high.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.