PDA

View Full Version : mysql table called 'post' vbulletin

briank
10-02-2007, 11:22 PM
Hi everyone,

The mysql table called 'post' vbulletin is ~250MB on my server. Is it supposed to be this large? I have 23,000 members, and 744,074 posts.

My forums are loading extremely slow. Could this be the cause of it?

Thanks in advance, everyone!
armatik
10-03-2007, 01:36 AM
If you have 744,074 posts, that seems about right. Atleast, it would seem that it'd be pretty big, if you have that many posts.

Do you run any hacks/plugins? Those could be the reasons for your slow boards.
briank
10-03-2007, 01:37 AM
I don't really run any hacks/mods. :/
armatik
10-03-2007, 01:46 AM
I can't imagine this being the reason why your forums run slow. I mean, I'm not an expert on how this caching stuff works, but I think that takes quite a bit of pressure off the database, and the post table size really shouldn't be affecting your forum all that much.

Alternatively, you could simply backup that table alone, prune around half your topics, and see if you notice any difference.
Dismounted
10-03-2007, 05:46 AM
What's your site running on? A VPS? Dedicated?
briank
10-03-2007, 01:37 PM
Servint.net - Signature VPS - 500 GB Monthly Transfer - 20 GB Storage - 2GB* Ram

2 GB Burst RAM
512 MB Guaranteed RAM
4 IP Addresses
Unlimited Domains
Unlimited User Accounts
CentOS 4 Operating System
cPanel and Plesk 8 Available
+more info
Madspot
10-03-2007, 02:01 PM
get a better server either canaca.net or sumthing
Marco van Herwaarden
10-03-2007, 06:52 PM
Funny to see some people recommending switching hosts, before it is even clear what the problem is.
Eikinskjaldi
10-04-2007, 11:32 AM
Are you running a memory cache?
briank
10-14-2007, 03:43 AM
Are you running a memory cache?

Not totally sure. We upgraded the server again and now we can hold 200 users online at once and its just a little bit slow when that happens.
DivisionByZero
10-14-2007, 11:48 PM
make some software changes! :)
briank
10-14-2007, 11:49 PM
Back to PunBB? haha
Eikinskjaldi
10-15-2007, 02:51 AM
Not totally sure. We upgraded the server again and now we can hold 200 users online at once and its just a little bit slow when that happens.

Get your sysadm to install apc. If you are not using vbadvanced then also set your datastore to memory cache in config.php.

You will see a many-fold improvement in performance.