Good old Open Source

[TheFaQQer]

I can think of a way

DELETE FROM threads WHERE LOWER(thread_title) LIKE '%my lunch%'

That should free up a fair bit of room.

There are far bigger threads than TPD out there running vBulletin with no problems.

[DimPrawn]

better still
Drop database CUK ;

Format C:\

Even better.

[TheFaQQer]

A whip round for a few more GB of RAM might be enough to keep it going for a few hundred more posts... Will see how much this machine has in it and see what the cost would be for some more. If anyone has some optimisation tips then don't be shy.

I'd best get cracking - another 61 posts to get to 10k

[realityhack]

What about splitting TPD off into a sub-forum, TPD having a separate process?

Or deleting all threads in Light Relief except TPD, 1-a-day, the jokes thread and a few other choice ones?

Or, archiving all TPD posts older than 6 months into a separate thread off the bulletin board? A TPD Net-split?

[NickFitz]

There have been 70-odd posts on TPD since 8:30 this morning. There have been a lot more than that over that time period in General. I assume there have also been posts in B/C, A/L and Technical, and probably to other LR threads.

So why should TPD be singled out?

If it's because of the length of the thread, that would imply that the database itself needs to be optimised. It really shouldn't be breaking over something like that. Certainly that shouldn't be causing too many database connections: at present the number of people viewing each forum are:

General 185
B/C 60
A/L 108
Technical 15
Light Relief 24

and as each of those viewers requires at least one DB connection per page view, it's quite obvious that it can't be TPD consuming too many connections: it must be General that is using the greatest number of connections.

[DimPrawn]

There have been 70-odd posts on TPD since 8:30 this morning. There have been a lot more than that over that time period in General. I assume there have also been posts in B/C, A/L and Technical, and probably to other LR threads.

So why should TPD be singled out?

If it's because of the length of the thread, that would imply that the database itself needs to be optimised. It really shouldn't be breaking over something like that. Certainly that shouldn't be causing too many database connections: at present the number of people viewing each forum are:

General 185
B/C 60
A/L 108
Technical 15
Light Relief 24

and as each of those viewers requires at least one DB connection per page view, it's quite obvious that it can't be TPD consuming too many connections: it must be General that is using the greatest number of connections.

Delete everything else and leave TPD. Delete all your paying sponsors adverts.

Think like a techie for god sake!

[DiscoStu]

There must be some other way. We're a bunch of IT 'experts' here for goodness sake - can't we think of a way to keep TPD and free the forum up a bit?

Come on PHP gurus, don your thinking caps.

Where?

[TheFaQQer]

We tried to take TPD into Freelancer UK, but they kept kicking us out!

(BTW, I just tried to quote RH's post, and it failed to quote)

[DimPrawn]

Delete this thread it is using up electrons.

DELETE FROM posts WHERE user_id IN (SELECT user_id FROM morons)


Should do it.

[NickFitz]

"As I've mentioned in the beginning of my blog post – what's really cool in vBulletin 4.0 is not necessarily apparent to the untrained eye. Previously, vBulletin utilized the fulltext index on both “thread” and “post” tables making optimization and server problem resolution very expensive and complicated. vBulletin 4.0 no longer needs the fulltext index to be present in either of the “thread” or “post” tables. This means that vBulletin 4.0 database can utilize the InnoDB table engine and prevent a lot of common database issues associated with locked database queries. This is great news for small to medium board owners who will be able to resolve some performance overhead problems without having unnecessary expenditures for expensive hosting or complicated third-party search engines."

- From vBulletin.com, their emphasis.

Any plans to upgrade? IIRC they pulled some stunt like forcing you to upgrade if you want to receive updates anyway... lots of people were pretty annoyed about that.

Anyway I'll see if I can come up with anything that could help, although I don't have the vBulletin code to work with: I may have to buy a copy to see where it's failing