[ZendTo] ZendTo System Statistics Question

[Jules]

Brian,

The graphs are all generated, and the data managed, by "rrdtool":
     http://oss.oetiker.ch/rrdtool/

One of the great advantages of rrdtool is that its own data file from 
which it draws the graphs does *not* grow over time as it collects more 
data. Which means it never needs any maintenance from you.

So don't expect to be able to extract all the numbers that have ever 
been fed into it. You can't. It keeps what it needs to draw the graphs, 
but no more. You cannot ask it to "draw a detailed graph for this 
particular day 6 months ago".

And the ZendTo database does not keep historical data either. Once a 
drop-off has been expired, it's gone from the ZendTo data completely. 
Again, that is to stop database tables growing over time, which requires 
maintenance effort to prune.

I've tried quite hard to make ZendTo a package that needs no maintenance 
at all, once in production.

Cheers,
Jules.

On 17/05/2017 20:17, Ricky Boone wrote:
> The RRD scripts are pulling info from the database.  Depending on
> which database type you're using (SQLite, MySQL, etc.) and how you
> intend on displaying this information may dictate how easy it will be
> to do.  If what you're doing can be done locally, SQLite or MySQL
> scripting should be pretty easy.  If it's remote, MySQL may be
> required (not sure about good ways to do full remote access to SQLite
> without causing other issues).
>
> For example, one of the SQL queries involved against a MySQL instance is:
>
> SELECT * FROM dropoff ORDER BY created
>
> The SQL query called by the same PHP function for SQLite3 is:
>
> SELECT rowID,* FROM dropoff ORDER BY created
>
> It might help to understand what you're intending on doing.
>
> On Wed, May 17, 2017 at 8:49 AM, Brian Novogradac
> <Brian.Novogradac at utoronto.ca> wrote:
>> Is there any way to get some numerical stats based on the graphs provided in
>> the admin console (System Statistics).  Where is it pulling these values
>> from?
>>
>>
>>
>>
>>
>>
>>
>> Brian Novogradac
>> Intermediate Systems Administrator (I&ITS)
>>
>>
>> Information Security Is Everyone’s Responsibility. Learn more:
>> http://uoft.me/cyberaware
>>
>>
>> University of Toronto at Mississauga
>> 3359 Mississauga Road N.
>> Mississauga, Ontario, L5L 1C6
>>
>> (P) 416-435-2543
>> (F) 905-569-4343
>> (E) brian.novogradac at utoronto.ca
>>
>> (W) www.utm.utoronto.ca/iits
>>
>> This E-mail contains privileged and confidential information intended only
>> for the individual or entity named in the message. If the reader of this
>> message is not the intended recipient, or the agent responsible to deliver
>> it to the intended recipient, you are hereby notified that any review,
>> dissemination, distribution or copying of this communication is prohibited.
>> If this communication was received in error, please notify the sender by
>> reply E-mail immediately, and delete and destroy the original message.
>>
>>
>>
>>
>> _______________________________________________
>> ZendTo mailing list
>> ZendTo at zend.to
>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto

Jules

-- 
Julian Field MEng CEng CITP MBCS MIEEE MACM

'Ever since the dawn of civilization, people have craved for an
  understanding of the underlying order of the world: why it is as
  it is, and why it exists at all. But even if we do find a complete
  theory of everything, it is just a set of rules and equations. What
  is it that breathes fire into the equations, and makes a universe
  for them to describe?' - Stephen Hawking

www.Zend.To
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654