Drupal Bytes when Max Packets Allowed
02 Apr
Posted by webthingee
in drupal, mysql
It seems like every time I set up a new site I eventually see the same screen... not the welcome screen, tho I do see that every time. I'm talking about the
The max_packets_allowed screen!
If you are finding this post, you probably need to find a way to fix it... you probably don't want me to cram in some lame images and funny words... so I'll get right to it... here's my secret to fixing it quick.
- Call Hosting Company
- Tell them to set my.cnf, remind them it's part of mysql
- Please find the section called [mysqld]
- and Please change/add max_allowed_packet = 64M
- If they bock, I tell them that it is a requirement of the framework I am running on the site... and they usually do it in a few minutes.
Comments
Sounds familiar
Ah, the days of calculating the precise way to ask for support. Sounds like my experience with a whm/cpanel reliant company where the 1st level support knew little beyond the interface they were using.
Another "fix" is to disable
Another "fix" is to disable dblog.module.
Devel's Macro Generator
The only time I've hit this limit is when I forgot to turn off the Macro recorder in the Developer module. It stores every form submission in a serialized variable, which causes the {variables} table to be huge! Remember, if you're hitting that limit, that means that you're transferring at least 1MB of data from the database during the request, so you may have other performance problems, especially with unserialize() calls. While there are cases where you need to modify my.cnf, it's worth the time to double check your tables to ensure nothing has grown too large.
--Andrew
Dude, either you've got some
Dude, either you've got some crazy site that you shouldn't be trying to run on shared hosting, you've got a host that's setup to be doing little more than static HTML pages, or there's a bug in one of your contrib modules or custom code. Drupal + standard contrib modules should never hit this error on a half-decent host, even an eighth-decent host.
When you are your own hosting service
This is all so much easier. I just call myself
Max Packets... your new name :)
Yesterday, I came across this issue.
Disabling the dblog module is a good solution. However, I started to miss all of the "Recent log entries" goodness.
Thanks webthingee. You saved the day! :)
its realy good
great
Thank you for the article ;)
Sylvain
Vente vtt
thakns
Post new comment