Big WordPress XML Sitemap kills posting

WordPress XML Sitemap kills posting

To create dynamic Google XML Sitemap for my WP websites I use this plugin Google (XML) Sitemaps Generator for WordPress.

Today I have this strange problem with one of my sites. When I wrote new posts MySQL goes crazy after published them. I saw in MySQL error page some strange line about XML Sitemap that contains more that 2500 posts. This was the problem that made WordPress MySQL base goes crazy. WordPress published new post but then he tried to update xml sitemap and it was too big for him.

It was quite annoying because it happened after each post. I found simple solution to solve this, works perfect for me.

In WordPress admin panel i go to ‘Options’ -> ‘XML-Sitemap’ and then focus on ‘Advanced options’:

sitemap1 Big WordPress XML Sitemap kills posting

WordPress XML Sitemap options

Try to increase the memory limit to: (e.g. “4M”, “16M”)

By default is is empty, I setup it to ‘64M’ and my problem was fixed.

« Previous Post

Paul
30 Jun, 2009

Hi,

It is good to setup this on blogs with many posts. It will work in future for you.

Cheers, Paul
WP Design Blogger
30 Jun, 2009

It is pretty easy to implement so why not. My VPS server got 1GB of RAM and it works smooth.
BlueHornet
18 Jul, 2009

This look interesting,so far.
If there’s anyone else here, let me know.
Oh, and yes I’m a real person LOL.

See ya,