Forum OpenACS Q&A: Slow Database after Power Supply Crash

Collapse
1: Slow Database after Power Supply Crash
Posted by David Kuczek on 11/24/00 11:37 AM
Does anyone have experience with his database getting slower after a
crash of the power supply?
Collapse
2: Response to Slow Database after Power Supply Crash (response to 1)
Posted by Don Baccus on 11/24/00 09:13 PM
Hey, be thankful - my computer doesn't run at all without a power supply :)

OK, I'm teasing ... this seems strange, to me.  Did you have to rebuild the database or did you just repair the machine and go off an running just fine?

Collapse
3: Response to Slow Database after Power Supply Crash (response to 1)
Posted by David Kuczek on 11/25/00 08:22 AM
Actually we just restarted the machine and then had to remove a file from the /temp directory in order to restart the database. But somehow it appears to be much slower now?!
Collapse
4: Response to Slow Database after Power Supply Crash (response to 1)
Posted by Don Baccus on 11/25/00 06:24 PM
Have you done a vacuum analyze recently?  Also, what's happening according to "top", etc - is there other stuff happening on the machine?  Are you sure it is still seeing all its RAM, etc?
Collapse
5: Response to Slow Database after Power Supply Crash (response to 1)
Posted by David Kuczek on 11/25/00 11:44 PM
I have never done a vacuum analyze before. It seems to work some faster now!! Thanks.

But what is "top"? I have restarted the database with "-B 1000". Can you check anywhere with how shared memory the databse is really allocating?

We want the database to be running on more than 16MB Ram soon. I haven't found a document on openacs to explain exactly how to do a linux kernel recompile? We have our db installed under SuSe Linux 6.3

Or am I just blind?