WordPress.org

1. ridesign
   Member
   Posted 1 year 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?

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #

   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.

3. ridesign
   Member
   Posted 1 year ago #

   Do you mean the posts table?

4. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #

   No I mean how long is each post.

5. ridesign
   Member
   Posted 1 year ago #

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

6. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #

   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.

7. ridesign
   Member
   Posted 1 year ago #

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

8. Mraztek
   Member
   Posted 1 year ago #

   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!

9. ridesign
   Member
   Posted 1 year ago #

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

10. Mraztek
    Member
    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.