Support » Fixing WordPress » How to prevent overhead on wordpress_options? 600KB in 1hour

  • Hi,

    does anyone know how to prevent overhead on the table wordpress_options?

    I noticed that in last hour I got a 650KV overhead.Should I run a cronjob to optimize every hour? I have disabled 90% of all plugins, why do I still get so much overhead?

    Also, does anyone have any recommendations for new indexes for the table wordpress_posts? (I have 1700 posts)

    I added an index for post_date like this, is this correct?
    http://www.tinyimg.org/images/466indexes.jpg

    Thanks for any input, much appreciated

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Why are you worried about 650KB? That’s nothing in the grand scheme of things. I generally don’t worry about that sort of thing until a database size of 80 MB or more.

    Also, it’s unlikely you need a post_date index. The usual selection by date order also includes type and status, and you have a combined index for those.

    Also, it’s unlikely you need a post_date index. The usual selection by date order also includes type and status, and you have a combined index for those.

    Yea that’s what I thought, thanks man.

    I’m worried about the overhead because I had a lot of disk IO and my server became unresponsive a couple times per day. Fragmented tables can be one cause of this 🙁

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to prevent overhead on wordpress_options? 600KB in 1hour’ is closed to new replies.