Asylum Feedback/Support Audio Asylum feedback, support and feature wish list.

---

[ Follow Ups ] [ Post Followup ] Thread: [ Display  All  Email ] [ Asylum Feedback/Support ]

---

[ Alert Moderator ]

---

RE: Man, that's a lot of bandwidth for just talkin' audio!

Posted by Rod M (W) on May 31, 2007 at 06:59:50

In Reply to: Man, that's a lot of bandwidth for just talkin' audio! posted by darkmoebius on May 30, 2007 at 21:39:15:

I recall at the time seeing sites nearly die or get corrupted with half as much traffic as we get. You think that most of them have figured out how to make it work better though at least one that was one of the worst has disappeared. The problem being that most of them rely completely on the db and doing maps from this to that to print a page. Once the system gets loaded up, there is just too much processing going on.

I've noticed that several sites using vBulletin archive off posts older than some date, so there must be a reason, probably because the main tables get too big. And their search is often very slow.

Initially, when we added the db, we definately had issues. Then, I added separate search tables for each forum. That solved most of the problems, but searching across all forums still used one huge table. So, I created another separate table for all forum search. A problem still remained with the main table primarily for backup because mysql does table locking in MyISAM files which you need to use for the fulltext search function.

In this release, I converted the main table and some new tables to INNODB which is more transactional with row level locking and a special forum/message number key. That seems to have made a big difference in performance. The Threads and eThreads views now use the db a lot, but I still caxhe a lot of data like the message threading that takes a lot of cycles to recreate from the db.

Throwing hardware at the problem does help scalibility. Right now, I think we could easily double or triple in size before we ran into major issues. The change to not arching old messages will likely become an issue at some point for the Threads and eThreads views. I'm not sure how many open threads they'll be able to handle before the get a performance hit.

-Rod

This post is made possible by the generous support of people like you and our sponsors:

VH Audio

---

[ Top of Page ] [ Contact Us ] [ Support/Wish List ] [ Copyright © 2024, Audio Asylum, all rights reserved ]

---

[ General ] [ Speakers ] [ Tubes ] [ Vinyl ] [ Digital ] [ Hi-Rez ] [ Video Asylum ] [ Cables ] [ Tweaks/DIY ] [ Music ] [ Films ]

---