Reply to: Good old Open Source

[Sysman]

Reports of use of INNODB over MyISAM - good to stop table locking, which may be the problem here, but users often end up going back to MyISAM due to performance issues from threads that I have read in the past.

I've been looking at implementing InnoDB on and off for a while now, (though have held off because I'm using a shared hosting solution and can't knobble the MySQL parameters).

Various folks have done it with Drupal, usually needing to hack it a bit to do certain things in a more InnoDB friendly way, and the current development version (V7 - the next major release) uses InnoDB as the default.

Yes, what suits Drupal won't necessarily fit VBulletin requirements, but there's some good experience out there which is probably highly relevant.

Converting your Drupal MySQL database from MyISAM to InnoDB - do follow the links here

In particular, search tables are probably best left as MyISAM, and the default buffer pool sizes for InnoDB are pitifully low.

Referring back to:

Tips optimising servers for large forums (>1m posts)

I've just changed all my InnoDB tables back to MyISAM because:
a) InnoDB seemed to use more memory
b) InnoDB causes load to go up - changing back to MyISAM dropped my loads down by 90%!!!
c) InnoDB used more hard disk space
d) InnoDB is slower than MyISAM

1. Yes it can use more memory, but that also gives faster performance
2. In one case I read about, this was because it was actually doing more useful work - i.e. the bottleneck had shifted
3. dumping the MyISAM database by primary key apparently solves this
4. Way too general a statement - it depends on what it's being asked to do

MySQL Engines: MyISAM vs. InnoDB again follow the links
MySQL InnoDB: performance gains as well as some pitfalls - take note of the stuff about locking, autoincrement fields and SELECT (*) COUNT (SELECT (*) MAX is better if that fits the app).
InnoDB Performance Tuning

I got this little lot from Googling "drupal 7 innodb" - there were plenty more hits.

[TheFaQQer]

Because it must remain until the end of the universe.

HTH

Sometime around 2050 when the oil runs out, then?

[DiscoStu]

it's test, please delete, sho why don't you delete it after all?

Because it must remain until the end of the universe.

HTH

[xchaotic]

it's test, please delete, sho why don't you delete it after all?

[TheFaQQer]

I wonder whether the newer version of vBSEO would make any difference. Not knowing what runs on the site, I have no idea - just something else to throw into the mix.

[realityhack]

Having been a moderator for Usenet newsgroups and mailing lists, I can assure you it is no reward.

WHS with bells on. Not a job to be envied at times. And if someone really wants to be a mod, they probably shouldn't be allowed to be one, if you catch my drift.

[RichardCranium]

I think Nick should be a moderator, as a reward for his help.

Having been a moderator for Usenet newsgroups and mailing lists, I can assure you it is no reward.

It is not out of fear that I do not abuse the mods, it is out of pity.

[TheFaQQer]

I think Nick should be a moderator, as a reward for his help.

Then we can watch General get deleted in an afternoon....

[realityhack]

NF, you're a star.

Admin, if/when this all gets sorted, can we move to design and IA next?

[RichardCranium]

OK, I've bought myself a copy of vBulletin.

[ctdctd]

Will the patient survive ?

This is better than X-Factor.

So:-

NickFitz = Jedward
Churchill + Cailin = Stavros
EO = Susan Boyle

(OK, not all in the X-Factor but near enough!)

Any other suggestions?

[OwlHoot]

As TPD doesn't seem to have caused any resource problems until now, I suggest:

1. Lock TPD (for read only)

2. Start a new thread called TPD2

3. Sorted

[Board Game Geek]

Wow, this is all so exciting !

We've got the collective geniuses of the crème de la crème IT contracting in the UK, working bravely to save a thread from extinction, before it crashes and burns and takes out the rest of the board with it.

It's like open-heart surgery, on a patient without anaesthetic.

The stakes are high, the die is cast, now the work begins.

Can they pull it off ?

Will the patient survive ?

This is better than X-Factor.

In fact, using that parallel, Admin could be Simon Cowell, and the contestants are the forum users.

Who's suggestion is going to make the grade this week, and who get's booted off ?

The tension is nearly unbearable. The crowd are going wild.

There's everything to play for, and some are going home empty-handed.

Gripping stuff indeed !

[NickFitz]

OK, I've bought myself a copy of vBulletin. The idea is to set up an Apache/PHP server and a mySQL server, hopefully configured similarly to the existing forums.CUK setup, then set up one or more additional servers to replay traffic that causes the fail. This means that I can test various options for tuning the database server, hopefully finding some tweaks to the configuration that will address the issues.

If that doesn't work, I may need to figure something else out that the good people of CUK can deploy without having to worry about breakage from future upgrades to the vBulletin software.

It would be handy to have some examples of the kind of traffic that has been causing the problems: we have a very clear timeframe today, so info from the HTTP logs would be useful, as long as it's cleaned of IP addresses and anything else that could be exploited to identify users.

Of course it'll all be more complicated than that, and I can't promise a rapid (or any) solution, but maybe something can be done - well, something other than just shutting down General, which is clearly the root of the problem

Luckily I have a (possibly incomplete) copy of TPD that I can start with

[AtW]

Failing that, just ban atw!

I've got plenty of other sockies

sasguru