MySQL Forums
Forum List  »  InnoDB

max_allowed_packet error
Posted by: Ra Nala
Date: February 04, 2016 05:26AM

Hi,

I am using mysql innoDB engine and i am facing issue with max_allowed_packet.

Previously value for max_allowed_packet = 1024, to resolve issues i was changed it to 64M in my.ini file and restarted the service after that all my issues resolved.

But after one day, it was reverted to 1024 when i apply show variables option but at the same time i was checked in my.ini file and it consists 64M, then why it was reverted to 1024 when i apply show variables ?.

what is the permanent solution to maintain 64M ?

Thanks,
Ra na la

Options: ReplyQuote


Subject
Views
Written By
Posted
max_allowed_packet error
1229
February 04, 2016 05:26AM
662
February 06, 2016 03:06PM
713
February 06, 2016 07:32PM
689
February 08, 2016 12:12AM
734
February 08, 2016 01:39PM
673
February 15, 2016 07:18AM
711
February 22, 2016 01:14AM
630
February 23, 2016 11:45PM
580
February 24, 2016 01:17AM


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.