Updating permalink-structure crashes my server

Perhaps it’s related to the amount of RAM in your server. Does MySQL actually crash, or just “hang” using 100% CPU?

wpdb store records with full path.
for example:
https://www.site.com/?page_id=10
or
https://www.site.com/10/10/23
ecc.

In the server is 2 gb ram, i think it is ok. ??

The apache-thread goes up to 99,99% cpu usage…

Hmm. Does it eventually come good if you leave it? Do you need to optimise your database tables?

I don’t have any experience with WordPress on such a scale. I’m pretty clueless. ;)

Your best bet is to get a dump of the rewrite rules for the pages; then hack the core and have it only create new rewrite rules for pages over a certain ID; then manually include your dump of page rewrite rules.

This way you will cut out a few thousand queries.

Ajd, that sounds nice, but I’m not so good in programming. ??

Ajd777 – Any idea how the code would look for this?