Post tables with more than 4 million entries

[sandstig]

I'm not sure if this is the correct forum to post this, but are there any other users here with more than 4 million posts in their post tables? What kind of hardware do you guys run on? I'm curious if I can optimize our servers further, as we're running a dedicated DB server with 1GB of RAM and a 2.4GHz P4.

[sandstig]

Better if I send in a trouble ticket?

[Steve Machol]

This issue is not strictly vB support. Have you searched the Server Configuration forums?

[Zachery]

id suggest switching to Dual Processors and more ram to start :)

[sandstig]

Noted, and dual-procs are already under consideration. Was just curious if there were other vBulletin users who've managed databases these large on similar or slower configs.

[KrON]

Noted, and dual-procs are already under consideration. Was just curious if there were other vBulletin users who've managed databases these large on similar or slower configs.

We run our database server on a dual 2.6ghz xeon w/ 2gb of ram and 3x18 gb drives in raid 5

Here's some stats: Members: 64,417, Threads: 350,020 (223 Today), Posts: 3,376,543 (3,012 Today)

[YogiTW]

How does your DB server handle searches? Ours gets quite bogged down when people do them. We have a very similar set up (specs wise). We've been trying to figure out why Search is such a problem and how we can correct it.

[KrON]

How does your DB server handle searches? Ours gets quite bogged down when people do them. We have a very similar set up (specs wise). We've been trying to figure out why Search is such a problem and how we can correct it.

The MySQL fulltext search hack (for vb2) is the only way we've found that we can use the search on the site, otherwise it's just too much. It's also what is keeping us from going to vb3 :/

[YogiTW]

Oh wow, thanks.

I'll have to see if it is adaptable to vb3.