Page 2 - Forum being slow?

I would go with BSD over DeadRat (aka RedHat) anyday, but hey use whatever you find works best for the job.

But I still think Windows 2000 Server with IIS would be a better choice. Also it may pay to see if you can setup forums to use MS Access database, i think the performance gains over MySQL would make it worthwhile. j/k

lol @ the MS Access joke

I used to stay away from BSD due to issues related to MySQL, but from what I hear most, if not all, of those issues have been resolved. The biggest ones being the need to compile with linux-threads but yet there being some bugs in there.

.....waiting for 2 weeks to pass....

JD

Ouch - mysql. I know zope supports postgre/firebird/others, what about VB - is mysql the only option for VB? Man, I say do a test run on some of the other DB packages out there.

As i said, MS Access would be the way to go!

Using Firebird (database not browser) or PostgreSQL would be good choices. Oracle might be a bit of overkill but hey they advertise on the site, see if you can rig up a contra deal. ie, You get Oracle, they get free advertising.

lol - ms access has problems handling my bank account, I can't see it handling devshed...

If MySQL is good enough for Yahoo! then it is good enough for us no? I am not too into triggers and other things that inherently slow down databases so I tend to stay away from most others. I used to use Oracle a lot but who has the money to pay those licensing fees?

But lets not make this a flame

No, I never get active in flame wars (well, not no more). I was just wondering as it seemed to me that MySQL could not handle the load before. When the sight was going down alot, we seen one of three things:

(a) 404 - page not found

(b) Mysql errors one after another

(c) The zope error page refering to the DB

The above leads to think that Mysql is not capable of handling this load without some sort of load balancing implementated.

Thats all I was curious about. Whatever you guys use would make it all good...

Hmm, anyhow just went through VBulletin site and it is only for MySQL. There are people talking about hacking it to work with PostgreSQL and other DB's (including Oracle) but it seems that there is nothing actually made yet.

Seems that if DB was to change then forum package would need replacement, but since new forum would have different DB design it would be an issue transferring data.

Well, as Joe said "Whatever you guys use would make it all good..."

nice grammer their

It's actually there not their and grammar not grammer

If you are going to be a complete troll and pretend to be the 'grammar police' at least make sure your grammar is correct.

LoL with Andreas :-)

Always open to new ideas, I just do not think that MySQL itself is the slow down. However, I do know there are a few things related to mysql that could be optimized and we will do so on the new servers for sure.

Maybe it is almost time to start timing what each part of the page creation takes... ie some profiling... to figure out exactly where the slow points are.

You may want to check out:

http://www.mysql.com/doc/en/Slow_query_log.html

as well.

I HIGHLY suggest mytop:

http://jeremy.zawodny.com/mysql/mytop/

as well. It can give you on-the-fly key efficiency reports.

A simple way to tune MySQL index caches in my.cnf- Find the physical size of all your .MYI and then increase your key_buffer to match this size. After this simple little tweak, your key efficiency should approach high 90s, assuming your tables are properly indexed.

I've done a lot of MySQL performance tuning (on redhat, no less) and you really can squeeze a lot out of it if you're willing to tinker.

Thanks Hero... I read about mytop on jeremy's site before but never actually used it. I guess it is about time to download it and give it a shot along with some other tweaks esp as we do the move to the new servers.