MySQL Forums :: Newbie :: aggreate data


Advanced Search

aggreate data
Posted by: Domenic Forgione ()
Date: September 26, 2010 09:47PM

I am trying to extract a value out of a database that has the maximum/average value for each day. There are 24 entries, one per hour for every filesystem.

The table contains: date, time, filesystem, total, used, available, mountpoint.


This table represents the output of the 'df -k' command on a Solaris 10 box. it is imported into a MySQL DB. I need to extract the maximum, average space used for each day for each filesystem. The maximum is the actual value in the database, while average is the average usage that is calculated for the day.

I have tried:

mysql> select *, max(used) as maxused, avg(used) as avgused from space where mountpoint='/' group by date with rollup;


It seems to select the same hour everyday, which is not the case when the maximum occurs for the column used!

Any thoughts?

PS. I have only just begun using MySQL.

Options: ReplyQuote


Subject Written By Posted
aggreate data Domenic Forgione 09/26/2010 09:47PM
Re: aggreate data Barry Galbraith 09/26/2010 09:54PM
Re: aggreate data Domenic Forgione 09/26/2010 10:02PM
Re: aggreate data Rick James 09/26/2010 10:28PM
Re: aggreate data Domenic Forgione 09/27/2010 05:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.