WordPress.org

1. codehooligans
   Member
   Posted 5 years ago #

   Greeting all,

   I'm running into an issue on my server where I'm hitting a limit of some sorts. It started earlier in the week when I tried to save new posts I received the error 'WordPress database error: [Got a packet bigger than 'max_allowed_packet' bytes]'. This will followed by a very large INSERT record dump. Large meaning this is almost 100 page!

   Tried to up the setting in MySQL through the my.cnf. This seemed to solve the issue for a while but I keep having to increase the size of memory. As of today is sits at 100M.

   The bigger issue is that saving an entry takes what seems like forever. I've done some timed edits this afternoon and the time to save a page is upwards of 6-8 minutes.

   What is going on? I have almost 2000 records in the wp-posts table. These are mostly Pages not posts if it matters. Also each page has anywhere from 3-5 custom fields (post-meta) associated with it.

   Is there any way to purge and recreate the rewrite rule record from the wp_options table?

2. maerk
   Member
   Posted 5 years ago #

   What do you mean, purge the rewrite rule record?

3. vkaryl
   Member
   Posted 5 years ago #

   What wp version are you using?

4. codehooligans
   Member
   Posted 5 years ago #

   Sorry. Should have posted the version.

   To vkaryl: I'm on version 2.0.3. I'm using WP-Cache plugin.

   To maerk: What I mean is. Can I remove the row from the wp_options table for the rewrite_rules entry and possibly expect WP to recreate the entry. My suspicion is that the entry may be corrupt or somehow hacked.

   Since my initial writting I have since renamed the 'rewrite_rules' and 'page_uris'. And yes WP does rebuild these.

Topic Closed

This topic has been closed to new replies.