Core statistics module kills my site

ipswitch - December 2, 2008 - 17:30

Using V 6.6.
When I enable the core statistics module, I get an error at the top of the content area saying

"user warning: Got a packet bigger than 'max_allowed_packet' bytes query: UPDATE cache_menu SET data" followed by a huge amount of data.

There is a different error message displayed at the very top of the page " Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO watchdog"

I've seen that people have had similar issues with Views but I haven't been able to find anything about this error relating to statistics module. Has anybody come across this, or better yet, overcome this issue?

thanks.

» Login or register to post comments

my.cnf

James Andres - December 3, 2008 - 00:31

You need to edit your MySQL my.cnf to increase the packet size. MySQL expects each database query to be less than 1MB in size. Drupal's cache system often attempts to send queries larger than this.

The my.cnf on most of my servers is set to max_allowed_packet = 8M.

Cheers,

James Andres

Senior Developer @ Donat Group Enterprises
jamesandres.com