Quote:
Originally Posted by Bobblehead
Thanks, I'm always curious how the backend works.
Can you pass on any DB statistics? I'm assuming it is MySQL. (I'm an Oracle dba, so I'm curious about your table sizes, schemas, etc.)
|
Sure, the schema is done by vbulletin so we don't have any control.. There's 169 tables, 20 of them are for the flashchat program, the rest for vb. As you can imagine most of the tables are really small, except for the post table which has 1.5 million records and is over 1.1GB. The rest of the database is 100MB or less, and there's 2.4 million records total.
All the tables are MyISAM except for a couple of memory tables, which is interesting since MyISAM only supports table locking if I recall. Still the query cache gets good use and the mysql load on the server is pretty steady but not extreme; we're not limited by mysql at this point.
I've done some reading about guys with really huge forums that have rewritten quite a few of the queries in vb as well as made some tables innodb as they ran into a bit bottleneck with locking.
Now that you mention it I'm taking a look at the database stats and while they're good, they could be better. It looks like there are some tables that could use some indexes, and my query cache is probably too small.
Hm... server's been up for 14 days (did some updates that needed a reboot), averaging 26 queries per second.