WordPress.org

1. skydrak
   Member
   Posted 5 years ago #

   Hello,

   if I'm writing a new static page in wordpress, the update procedure of the permalinks in the database kills my server. I have to restart mysql that my site is reachable...

   Currently using WP 2.0.5.

   I have to say that I have currently over 1000 static pages...

   Someone know how to fix this problem?

2. JeremyVisser
   Member
   Posted 5 years ago #

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

3. fabiobon
   Member
   Posted 5 years ago #

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

4. skydrak
   Member
   Posted 5 years ago #

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

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

5. JeremyVisser
   Member
   Posted 5 years ago #

   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. ;)

6. Ajd777
   Member
   Posted 5 years ago #

   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.

7. skydrak
   Member
   Posted 5 years ago #

   Ajd, that sounds nice, but I'm not so good in programming. :(

8. kineda
   Member
   Posted 5 years ago #

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

Topic Closed

This topic has been closed to new replies.