Consolidating mysql rows
Posted on 2014-07-27
I have a small application which logs ping results when I run it, typically, 24/7 for a few days to gather some information.
Sometimes, I can have a dozen sources all sending their results to mysql so the table fills up with very large numbers of rows. I want to keep the results for historical purposes but I would like to consolidate the large number of rows.
For example, looking at mysql right now, my pings test table has 'Rows 1 to 50 of 89138 rows' of results. I certainly don't want to get rid of this data but I need to find a way of consolidating it into less rows, perhaps even into a new table.
The fields include the usual min/max/avg/loss along with a sending device id and time.
I sure would love to get a solution on how this could be accomplished without losing data.
Thanks very much.