So due to some default configuration issues I wasn't aware of, the database for this forum had expanded to 4 gigs of data and 8 gigs of logs.  The logs normally allow a database to be recovered if anything goes wrong, the amount of logs determines how far back you can go if something goes wrong.  The combination of backup and log allow you to recover most/all of your data.  Unfortunately the default setting says to track every transaction since the beginning of the forums, which meant the log was expanding to an unmanageable size.

I attempted to delete the log and set it to only track the last...X amount of transactions, then delete all the data that has nothing to do with dndorks and got it to 800MB.  Unfortunately the database corrupted itself and a whole bunch of things went wrong.  Normally I would have been able to restore from backup after I corrupted the database, but I hadn't been able to backup the database in months because of how big it was. 

So I've been poking at it for days now and each change I make seems to improve the performance by a few percent, but its still not back up to full steam.  The ultimate goal is to get it even faster than it was before. 

Today the forums seem "very" snappy for me, how is it for everyone else? The only thing slow for me at the moment is making a new post...not sure why.  What are things slow for you and I'll take a look and try to optimize the database accordingly.

The good news is with the database reasonable again I can make backups which means the site shouldn't spontaneously implode. ;)

---

Richard M.
Grimfang
"Whisper"
Xaeraes

It seems much better then it was, I was about to complain to you since it was almost as slow as ENworld and my new players where complaning...on the other hand we have what...6 people looking at the forums?

On the other hand it could just be everyone else is at work....stupid job market...

---

-Nova

IT IS THE RESPONSIBILITY of intellectuals to speak the truth and to expose lies. --The Responsibility of Intellectuals, Noam Chomsky. The New York Review of Books, February 23, 1967.

Well I'm still poking at it, but I defragged the server since my last post because I was getting I/O errors.  I've actually been able to use it, which is good.  I'm going to keep going at it, been talking to a sqldba at work too, getting input.  Unfortunately instead of offering the magical  cure I was looking for he said I was on the right track. :(

 

Keep me apprised in this thread if you notice an issue that I can duplicate.

---

Richard M.
Grimfang
"Whisper"
Xaeraes

Hey, so I found a post that was all by its lonesome.  It might have been the problem, as it was pointed to nonexistent categories.  It might have happened during the broken log file fiasco.  I just clicked through a lot and everything, including posting seems to be fast again, lets cross our fingers and hope. :)

---

Richard M.
Grimfang
"Whisper"
Xaeraes

So last night I took all of the websites down and I compressed, deleted, and reorganized all of the databases on the server, I think it was worth it.  I'm still getting some worrisome error messages, but the website has been much much snappier.  Is anyone still having issues?

---

Richard M.
Grimfang
"Whisper"
Xaeraes

I've been getting a lot of timeout errors but my router has been on the fritz latly and dropping my laptop connection so that could be the problem.

---

-Nova

IT IS THE RESPONSIBILITY of intellectuals to speak the truth and to expose lies. --The Responsibility of Intellectuals, Noam Chomsky. The New York Review of Books, February 23, 1967.

Hmm, you've been  having timeouts since yesterday? Or before?  Let me know if it keeps happening, otherwise i'm pushing forward to new and different things. :)

---

Richard M.
Grimfang
"Whisper"
Xaeraes

Since long before that.... ever since my router started dying....course I wasn't on much until my PBP started...so on to new and better things...Also if anyone has router recomendations I'm listending.

---

-Nova

IT IS THE RESPONSIBILITY of intellectuals to speak the truth and to expose lies. --The Responsibility of Intellectuals, Noam Chomsky. The New York Review of Books, February 23, 1967.