Last March of the Penguin (Jan 29 2008)

Message boards : Technical News : Last March of the Penguin (Jan 29 2008)
Message board moderation

To post messages, you must log in.

AuthorMessage
Profile Matt Lebofsky
Volunteer moderator
Project administrator
Project developer
Project scientist
Avatar

Send message
Joined: 1 Mar 99
Posts: 1444
Credit: 957,058
RAC: 0
United States
Message 705641 - Posted: 30 Jan 2008, 0:06:05 UTC

Normal outage day for mysql database backup and compression. We took the opportunity to take care of two other things. First, we added a uniqueness constraint on a field in the analysis_config table in the science database. Interesting, no? Well, no, but long story short this constraint should have been there already, now it really is. Second, we upgraded the secondary science database server to latest Fedora rev and it seems to have accepted its new OS kindly. So far so good with that.

The recovery from the outage was slowed by a couple things. Bob also stopped/restarted mysql to incorporate/test some recently tweak config parameters. This has the unfortunate side effect of flushing the 20+ GB of memory, which means that all has to be read in again before the project comes fully back up to speed. Meanwhile I thought I'd continue tweaking the apache config on bane as it was seemingly unhappy and I ended up just making it temporarily worse. Oh well. Hang in there. Workunits will come.

Old web server penguin has been powered down and all its cables removed from the spaghetti in the closet. It has served us quite well.

- Matt
-- BOINC/SETI@home network/web/science/development person
-- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude
ID: 705641 · Report as offensive
Profile Dr. C.E.T.I.
Avatar

Send message
Joined: 29 Feb 00
Posts: 16019
Credit: 794,685
RAC: 0
United States
Message 705648 - Posted: 30 Jan 2008, 0:32:17 UTC

again, Thanks for the Post Matt - nice cleanup
BOINC Wiki . . .

Science Status Page . . .
ID: 705648 · Report as offensive
Speedy
Volunteer tester
Avatar

Send message
Joined: 26 Jun 04
Posts: 1639
Credit: 12,921,799
RAC: 89
New Zealand
Message 705738 - Posted: 30 Jan 2008, 5:28:24 UTC - in response to Message 705641.  

Flushing the 20+ GB of memory.

How long did it take to flush & reread the 20GB+ of memory?
______
Speedy
ID: 705738 · Report as offensive
Benjamin Hunt

Send message
Joined: 22 Nov 07
Posts: 1
Credit: 58,055
RAC: 0
Belgium
Message 705786 - Posted: 30 Jan 2008, 9:17:55 UTC

nice work ;)
ID: 705786 · Report as offensive
Profile Matt Lebofsky
Volunteer moderator
Project administrator
Project developer
Project scientist
Avatar

Send message
Joined: 1 Mar 99
Posts: 1444
Credit: 957,058
RAC: 0
United States
Message 705875 - Posted: 30 Jan 2008, 17:23:12 UTC - in response to Message 705738.  

[quote]How long did it take to flush & reread the 20GB+ of memory?/quote]

It's very hard to say, as while it's flooding its caches with all the tables/indexes it is desperately trying to handle 1000-2000 queries per second as we're coming out of an outage and demand is high. But to answer your question anyway, depending on the situation, roughly 10 minutes to an hour.

- Matt
-- BOINC/SETI@home network/web/science/development person
-- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude
ID: 705875 · Report as offensive
Speedy
Volunteer tester
Avatar

Send message
Joined: 26 Jun 04
Posts: 1639
Credit: 12,921,799
RAC: 89
New Zealand
Message 705960 - Posted: 30 Jan 2008, 20:12:23 UTC - in response to Message 705875.  


It's very hard to say, as while it's flooding its caches with all the tables/indexes it is desperately trying to handle 1000-2000 queries per second as we're coming out of an outage and demand is high. But to answer your question anyway, depending on the situation, roughly 10 minutes to an hour.

- Matt

Thanks Matt. Interesting to know. Thanks for all your hard work.
______
Speedy
ID: 705960 · Report as offensive

Message boards : Technical News : Last March of the Penguin (Jan 29 2008)


 
©2024 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.