Search Posts

Author: sagar reddy

how to delete and update the rows when converetd mins data to hours in database

this is continuation of the post need database hourly data before two months hostname | cpuload | freedisk | freemem |timestamp localhost.localdomain | 0.15 | 136052 | 383660 | 2017-08-01 00:10:08 localhost.localdomain | 0.03 | 136492 | 383660 | 2017-08-01 00:20:08 localhost.localdomain | 0.01 | 133456 | 383660 | 2017-08-01 00:30:08 localhost.localdomain | 0.10 | 64544 | 383660 | 2017-08-01 00:40:08 localhost.localdomain | 0.01 | 68148 | 383660 | 2017-08-01 01:00:08 output obtained is hostname […]

need database hourly data before two months

I have a table with cpuload,freememory,diskspace, cpu utilization and hostname feilds. i am running a cron job to get the data for every 10 mins in all hosts(ex: 4 hosts). Now i have one year data in database. i want to convert that data into hourly average data. but i need only for the data which is before two months. last two months data should not disturb. my data is like this hostname | cpuload […]