Message boards :
Technical News :
Last March of the Penguin (Jan 29 2008)
Message board moderation
Author | Message |
---|---|
Matt Lebofsky Send message Joined: 1 Mar 99 Posts: 1444 Credit: 957,058 RAC: 0 |
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 |
Dr. C.E.T.I. Send message Joined: 29 Feb 00 Posts: 16019 Credit: 794,685 RAC: 0 |
|
Speedy Send message Joined: 26 Jun 04 Posts: 1639 Credit: 12,921,799 RAC: 89 |
Flushing the 20+ GB of memory. How long did it take to flush & reread the 20GB+ of memory? ______ Speedy |
Benjamin Hunt Send message Joined: 22 Nov 07 Posts: 1 Credit: 58,055 RAC: 0 |
nice work ;) |
Matt Lebofsky Send message Joined: 1 Mar 99 Posts: 1444 Credit: 957,058 RAC: 0 |
[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 |
Speedy Send message Joined: 26 Jun 04 Posts: 1639 Credit: 12,921,799 RAC: 89 |
Thanks Matt. Interesting to know. Thanks for all your hard work. ______ Speedy |
©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.