Something we've been lagging on is separating the database count totals on the server status page. Currently we're showing "totals" - for example, the "results ready to send" is a sum of both SETI@home and Astropulse results ready to send. For diagnostic purposes, it would be much better to split these into two separate columns.

However, this isn't so easy, as such queries become suddenly very expensive if we're adding an additional "where appid = N" conditional (AstroPulse and SETI@home are considered two different "applications" in the BOINC realm). I'm talking the difference being a 3 second query versus a 3600 second query. Yup. We've made joint indexes in the past for servers that needed them, but this hasn't been a priority for diagnostic stuff. We also don't really have the memory/resources to keep such extra indexes around. In any case, Bob pointed out that newer versions of mysql are smarter - doing the index joins automatically - so we may push on upgrading mysql sooner than later.

Today I'm actually lost in mundane bureaucracy land. I also should be working on the new software radar blanking embedder code. Sigh.

- 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

Thanks for the info...moving at the speed of state, eh??

---

Clk2HlpSetiCty:::PayIt4ward

. . . Thanks for the Post Matt - it'll get done when it's done, right ;)

---

BOINC Wiki . . .

Science Status Page . . .

Something we've been lagging on is separating the database count totals on the server status page. Currently we're showing "totals" - for example, the "results ready to send" is a sum of both SETI@home and Astropulse results ready to send. For diagnostic purposes, it would be much better to split these into two separate columns.

However, this isn't so easy, as such queries become suddenly very expensive if we're adding an additional "where appid = N" conditional (AstroPulse and SETI@home are considered two different "applications" in the BOINC realm). I'm talking the difference being a 3 second query versus a 3600 second query. Yup. We've made joint indexes in the past for servers that needed them, but this hasn't been a priority for diagnostic stuff. We also don't really have the memory/resources to keep such extra indexes around. In any case, Bob pointed out that newer versions of mysql are smarter - doing the index joins automatically - so we may push on upgrading mysql sooner than later.

Today I'm actually lost in mundane bureaucracy land. I also should be working on the new software radar blanking embedder code. Sigh.

- Matt

Might give the science status page a swift kick. Seems to be stuck.

However, this isn't so easy, as such queries become suddenly very expensive if we're adding an additional "where appid = N" conditional (AstroPulse and SETI@home are considered two different "applications" in the BOINC realm). I'm talking the difference being a 3 second query versus a 3600 second query. Yup.

What about this?
select
count(*) as total_count,
sum(case appid when "N" then 1 else 0) as Astropulse_count
from table

Then do total_count - Astropulse_count = Enhanced_count

Something we've been lagging on is separating the database count totals on the server status page. Currently we're showing "totals" - for example, the "results ready to send" is a sum of both SETI@home and Astropulse results ready to send. For diagnostic purposes, it would be much better to split these into two separate columns.

However, this isn't so easy, as such queries become suddenly very expensive if we're adding an additional "where appid = N" conditional (AstroPulse and SETI@home are considered two different "applications" in the BOINC realm). I'm talking the difference being a 3 second query versus a 3600 second query. Yup. We've made joint indexes in the past for servers that needed them, but this hasn't been a priority for diagnostic stuff. We also don't really have the memory/resources to keep such extra indexes around. In any case, Bob pointed out that newer versions of mysql are smarter - doing the index joins automatically - so we may push on upgrading mysql sooner than later.

Today I'm actually lost in mundane bureaucracy land. I also should be working on the new software radar blanking embedder code. Sigh.

- Matt

Might give the science status page a swift kick. Seems to be stuck.

Specifically, the "signals already found" stats AND the "overflow rate" have been stuck for over a week!

---

.

Hello, from Albany, CA!...

Talking about the science status page, there is something strange left of the google skymap:

"SDSS" left of "Google"

---

mic.

"SDSS" left of "Google"

Yeah.. that's saying the data is coming from the Sloan Digital Sky Survey. The Google API is kinda mysterious, and the documentation even more so - I have no idea how to remove that string (or even place it in a less clumsy spot).

- 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

Something we've been lagging on is separating the database count totals on the server status page. Currently we're showing "totals" - for example, the "results ready to send" is a sum of both SETI@home and Astropulse results ready to send. For diagnostic purposes, it would be much better to split these into two separate columns.

However, this isn't so easy, as such queries become suddenly very expensive if we're adding an additional "where appid = N" conditional (AstroPulse and SETI@home are considered two different "applications" in the BOINC realm). I'm talking the difference being a 3 second query versus a 3600 second query. Yup. We've made joint indexes in the past for servers that needed them, but this hasn't been a priority for diagnostic stuff. We also don't really have the memory/resources to keep such extra indexes around. In any case, Bob pointed out that newer versions of mysql are smarter - doing the index joins automatically - so we may push on upgrading mysql sooner than later.

Today I'm actually lost in mundane bureaucracy land. I also should be working on the new software radar blanking embedder code. Sigh.

- Matt

Might give the science status page a swift kick. Seems to be stuck.

Seems to be working again, so thanks.

---

Might give the science status page a swift kick. Seems to be stuck.

Seems to be working again, so thanks.

The overflow rate is still stuck at 5%, though...

---

.

Hello, from Albany, CA!...