Outgrown WordPress or Host?

  • ridesign

    (@ridesign)


    14 years ago

    I have a wordpress site with 77,000 posts, and the server becomes really slow at times with the load going to 40.
    Wordpress is running with hypercache, and has about 100-200 posts added every day.

    I have a few sites on my VPS server and my host has good reviews.

    The server is running XEN, with cpanel/whm, php5.3.3
    The server spec is:
    3.0Ghz – 8 cpu’s
    2048MB RAM, and 2048MB SWAP
    Apache 2.2
    WHM/Cpanel
    Centos 5.5

    I have installed eaccelerator with a cache size of 150mb

    The mysql database for this site is 280mb. The “wp_posts” table is 180mb with 77,000 rows, and the “wp_postmeta” table has 388,626 rows.
    Also if I try to run optimize the database in phpmyadmin the server load becomes high and the website becomes very slow. And phpmyadmin becomes inaccessible.

    Have I outgrown wordpress, with this many posts, or my server, or something not right on my server?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    The database size would be my first guess as to the problem. 280mb? How big are your posts?!

    You may need to look into splitting your database up.

    Thread Starter ridesign

    (@ridesign)

    Do you mean the posts table?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    No I mean how long is each post.

    Thread Starter ridesign

    (@ridesign)

    About 1500 characters, some are smaller e.g. around 600 characters.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Yeah, you’re going to need to look into splitting your database to share the load. HyperDB comes to mind, but I’m sure there are others. Basically your database is too big to be read effectively anymore.

    Thread Starter ridesign

    (@ridesign)

    Does HyperDB let you split different tables into different databases?
    So I can have the wp_posts table in a seperate database?

    (I thought it lets you set one database for reading and one for writing.)

    Mraztek

    (@mraztek)

    mmmm ?? look i will give you advice with the amount of post you got!

    you should first optimize your mysql manually editing my.cnf on your server.

    also Tuning Apache and PHP for Speed will help alot and its really important!

    Thread Starter ridesign

    (@ridesign)

    Once my server has been optimised is wordpress suitable to support this many posts/ DB size?

    Mraztek

    (@mraztek)

    of course and after u optimised everything! ur site should be running fine and smooth

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Outgrown WordPress or Host?’ is closed to new replies.