WordPress.org

Ready to get started?Download WordPress

Forums

Updating permalink-structure crashes my server (8 posts)

  1. skydrak
    Member
    Posted 7 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 7 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 7 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 7 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 7 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 7 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 7 years ago #

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

  8. kineda
    Member
    Posted 7 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic